Standard MDG Financials Validations
Standard MDG Financials Validations
Standard MDG Financials Validations
CL_USMDZ7_RS_ACCOUNT
1
10
Validation Checkpoints for Entity
Entity
Account Type X
Once an account has been activated, the account type must not be changed.
Account Group
The Account Group is mandatory. Its value has to be defined for the current chart of X
accounts. A new or changed account group has to be valid for the current account ID.
The account group defines the interval for the account IDs. The current account ID has
to part of this interval.
Group Account
If the current chart of accounts uses a group chart of accounts, the Group Account is X
mandatory. The chosen value has to be valid. The current account and the group
account have to have the same account type. The Group Account must not be defined
as "Statistical Indicator".
Account ID
The account can only be created using the current ID, if there is no secondary cost X
element having the same ID. Cost elements using the same ID have to be primary cost
elements.
Functional Area
Balance Sheet Accounts must not have a functional area. Primary cost elements of the X
account have to use the same (inherit) functional area.
Hierarchy Assignment
Check Parent.
FRS Item is the only valid parent (see below for exceptions)
Special Items 'Financial Statement Notes', 'Not Assigned', 'P+L Result', 'Net Result: Loss'
and 'Net Result: Profit' cannot be used as parent.
Check Number of Assignments in Hierarchy X
Common FRS Items allow one or two assignments of the account in the complete
hierarchy.
Contra FRS Item requires exactly two assignments of the account in the complete
hierarchy (current item and its contra item).
All siblings are accounts having the same account type.
Hierarchy Attributes 'Credit relevant' and 'Debit relevant' are mandatory.
An account assigned to a common FRS Item has to set both. This is either done in the
single assignment, or with opposite values in the implicit 'contra' assignment.
An account assigned to two contra FRS Items has to set opposite values. All siblings
below a contra FRS item have to use the same value (e.g. credit only or debit only).
Account Name
The Account Name has to be defined in the default language of the current chart of X
accounts.
New Account X
The New Account must not be a self-reference.
Checkpoints for Entity Changed in
Change Request Edition Release
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X MDG 8.0
X X MDG 7.0
X - -
Account in Company Code
CL_USMDZ7_RS_ACCCCDET
1
10
11
12
13
14
15
16
17
18
19
20
21
22
Validation Checkpoints for Entity
Entity
Currency
Show a warning in case of changes. X
Only Balances in Local Currency
Show a warning in case of changes. The indicator should not be set if the actual
currency of the company code differs from the default in customizing. The usage of X
local currency is only allowed for balance sheet accounts.
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X -
X X MDG 8.0
X X MDG 8.0
X X MDG 8.0
Company Validation Checkpoints for Entity
CL_USMDZ7_RS_COMPANY Entity Change Request
Check Required Fields
The company defines the following fields as
mandatory:
• TXTLG – Name 1
• STREET – Street
• POST_COD1 – Postal Code
1 • CITY1 – City X X
• COUNTRY – Country
Fields City and Street must not contain more
than 30 characters.
Company Address
Validate the postal code (zip code) against its
country since the Company entity does not
provide all address data for a complete
2 check. The check is the same as executed in X X
SAP ERP customizing maintenance for
companies.
ints for Entity Changed in
Edition Release
X -
- -
Financial Reporting
Structure
CL_USMDZ7_RS_FRS
10
11
12
13
Validation Checkpoints for Entity
Entity
Assignment of Functional Areas permitted
Deselecting the indicator is not allowed if any FRS Item of the current financial reporting
structure hierarchy contains already an assignment of functional areas. X
Special Items
1. All Special Items should be defined. X
2. A single FRS Items can only be assigned once as special item.
Special Items in Hierarchy
1. Item 'Not Assigned' must not have any children at all.
2. Item 'P+L Result' must not have any children at all.
3. Item 'Net Result: Loss' must not have any children at all. X
4. Item 'Net Result: Profit' must not have any children at all.
X X -
X X -
X X -
X X -
X X -
X - -
X - MDG 7.0
- X -
- X -
- X -
- X -
- X -
- X -
FRS Item
CL_USMDZ7_RS_FRSI
1
5
6
Validation
FRS Item ID
The FRS Item ID must not be the same as the related FRS ID.
Contra Item
1. The contra item must not be a self-reference to the current FRS item.
2. Execute the hierarchy specific checks for the contra item (CHECK_FRSICONTR).
a) The contra item has to be a bi-directional assignment. If item ABC references to contra item XYZ, item XYZ has to reference t
item ABC, too.
b) The direct children of the FRS item and its contra items must be accounts.
c) The direct children of the FRS item and its contra item must be absolutely identical (same accounts).
d) Identical accounts require that the 'Credit relevant' and 'Debit Relevant' indicators are set to opposite values. A single contra
item is either 'Credit' or 'Debit' only.
X X X - - - -
X X X - - - MDG 8.0
X X - - - - MDG 7.0
X X - - - - -
- - - X X X -
Cost Center
CL_USMDZ7_RS_CCTR
10
11
Validation
Cost Center ID
1. The ID is mandatory.
2. The ID must not contain a star (*) and / or comma (,)
Logical System
If ALE replication via logical systems is active for the current controlling area, the logical system must have the same
value as defined in customizing. Otherwise the field has to be empty.
Business Area
1. The current company code can define the business area as a mandatory field.
2. The change of an existing business area is only valid for a new fiscal year.
Functional Area
The current company code can define the functional area as a mandatory input field.
Currency
1. The controlling area can define the usage of the company code's currency as mandatory.
2. The change of an existing currency is only valid for a new fiscal year.
Company Code
1. The current controlling area defines a list of company codes in customizing that are valid for the controlling area.
The current company code must be part of this list.
2. The change of an existing company code is only valid for a new fiscal year.
Profit Center
1. If profit center accounting is active, the field should be filled.
2. Active data should only be changed if a new accounting period starts.
3. The Profit Center itself must be active (postable) for the current cost center's company code.
4. The validity of the Profit Center and the current Cost Center has to match.
Address
Execute the standard checks of the business address service.
Tax Jurisdiction Code
1. Existence Check: the tax jurisdiction code must exist either in SAP customizing or in external providers.
2. Company Code Validation: if the tax jurisdiction code is determined from SAP customizing, it must be valid for the
assigned company code of the cost center.
3. Validation vs. external providers: if the tax jurisdiction code is determined by external providers, the same are
used for checking.
X X X -
X X X -
X X X -
X X X -
X X X -
X X X -
X X X -
X X X
MDG 7.0
X X X MDG 7.0
X X -
X X X
MDG 8.0
Cost Center Group
CL_USMDZ7_RS_CCTRG
3
Validation Checkpoints f
Entity
Cost Center Group ID
1. The cost center group ID (name) must fulfill the required format as defined for the current system. X
2. The cost center group ID (name) must differ from hierarchy names.
Hierarchy Assignment (Single Object Maintenance)
1. The cost center group must not be assigned multiple times in a single hierarchy. X
Complete Hierarchy
1. Cost Centers must not have children.
2. Each Cost Center should be assigned to the standard hierarchy.
3. Each Cost Center Group node should appear only once in the hierarchy. -
4. Each Cost Center should appear only once in the standard hierarchy.
5. Ranges of cost centers are forbidden in the standard hierarchy.
Checkpoints for Entity Checkpoints for Hierarchy Changed in
Change Request Edition Entity Change Request Edition Release
X X - - - -
X X - - - MDG 8.0
- - X X X MDG 8.0
Cost Center Group
Hierarchy
CL_USMDZ7_RS_CCTRH
1
Validation Checkpoints f
Entity
Cost Center Group Hierarchy ID
1. The cost center group hierarchy ID must not be longer than 10 characters. X
2. The cost center group hierarchy ID must differe from existing cost center group IDs.
Checkpoints for Entity Changed in
Change Request Edition Release
X - MDG 7.0
Cost Element
CL_USMDZ7_RS_CELEM
1
6
Validation
Hierarchy Assignment
Checks for single entity processing are only executed in MDG 8.0 and newer!
1. The cost Element must not be assigned multiple times in a single hierarchy.
Currency
1. The controlling area can define the usage of the company code's currency as mandatory.
2. The change of an existing currency is only valid for a new fiscal year.
Short Text (Name)
The cost element name (short text) is mandatory.
Checkpoints for Entity Changed in
Entity Change Request Edition Release
X X X -
X X X -
X X X -
X X X -
X X X -
X X - -
Cost Element Group
CL_USMDZ7_RS_CCTRG
3
Validation
X X X - - - -
X X X - - - MDG 8.0
- - - X X X MDG 8.0
Cost Element Group
Hierarchy
CL_USMDZ7_RS_CELEMH
1
Validation Checkpoints f
Entity
Cost Element Group Hierarchy ID
1. The cost element group hierarchy ID must not be longer than 10 characters. X
2. The cost element group hierarchy ID must differe from existing cost element group IDs.
Checkpoints for Entity Changed in
Change Request Edition Release
X - MDG 7.0
Profit Center
CL_USMDZ7_RS_PCTR
1
10
11
Validation
Profit Center ID
The profit center ID must not be a hash-tag (#) or contain any comma (,) or star (*).
Existence Check for Company Codes of Controlling Area
The chosen controlling area must have at least one company code assigned.
Logical System
The current controlling area defines whether a logical system has to be assigned or not. Check the system
customizing vs. the current value.
Assignment to Company Codes
1. If the indicator 'Postable in all Company Codes' is set, there have to be company codes assigned to the profit
center.
2. With MDG 7.0: if the indicator 'Postable in all Company Codes' is set, additionally all assigned company codes
must have their specific 'Postable' indicator set to true.
3. If the indicator 'Postable in all Company Codes' is not set, at least one of the assigned company codes must not
have set the specific 'Postable' indicator.
4. If the 'Postable' indicator for a specific company code that is assigned to a profit center is removed, a cross check
vs. cost centers is required. Cost centers use profit centers as a cross reference. This relation requires that the profit
center is postable in the company code used by the cost center (e.g. if the cost center uses company code 0001, the
profit center must be assigned to company code 0001 and the specific 'Postable' indicator has to be set).
Segment
The usage of the segment is defined by the system's customizing.
1. Inactive usage: there must not be any value for the segment attribute of the profit center.
2. Active usage: if related split method is active, too, and split fields are defined, the segment should contain a value.
3. The change of an already active value is forbidden.
Blocking Indicator
The blocking indicator must not be set for the SAP dummy profit center.
Address
Execute the standard checks of the business address service.
Tax Jurisdiction Code
1. Existence Check: the tax jurisdiction code must exist either in SAP customizing or in external providers.
2. Company Code Validation: if the tax jurisdiction code is determined from SAP customizing, it must be valid for the
assigned company code of the profit.
3. Validation vs. external providers: if the tax jurisdiction code is determined by external providers, the same are
used for checking.
X X X -
X X X -
X X X -
X X X -
X X X -
X X X MDG 7.0
X X X MDG 7.0
X X - MDG 7.0
X X X MDG 8.0
- - X
MDG 8.0
Profit Center Group
CL_USMDZ7_RS_PCTRG
3
Validation Checkpoints f
Entity
Profit Center Group ID
1. The Profit center group ID (name) must fulfill the required format as defined for the current system. X
2. The Profit center group ID (name) must differ from hierarchy names.
Hierarchy Assignment (Single Object Maintenance)
1. The Profit center group must not be assigned multiple times in a single hierarchy. X
Complete Hierarchy
1. Profit Centers must not have children.
2. Each Profit Center should be assigned to the standard hierarchy.
3. Each Profit Center Group node should appear only once in the hierarchy. -
4. Each Profit Center should appear only once in the standard hierarchy.
5. Ranges of Profit centers are forbidden in the standard hierarchy.
Checkpoints for Entity Checkpoints for Hierarchy Changed in
Change Request Edition Entity Change Request Edition Release
X X - - - -
X X - - - MDG 8.0
- - X X X MDG 8.0
Profit Center Group
Hierarchy
CL_USMDZ7_RS_PCTRH
1
Validation Checkpoints f
Entity
Profit Center Group Hierarchy ID
1. The profit center group hierarchy ID must not be longer than 10 characters. X
2. The profit center group hierarchy ID must differe from existing profit center group IDs.
Checkpoints for Entity Changed in
Change Request Edition Release
X - MDG 7.0