According to some customer’s business requirement, manual adjustments to automatic consolidation result is required. So they configure a ‘M’ type data source (audit ID) particularly for this and post journal entries by this data source to adjust the consolidation result.
In this scenario, there is a common requirement that manual entries posted at a lower consolidation group needs to be reflected (consolidated) in the higher level group.
Below is an example:
Group1 is the parent of Group2 and Group3.The manual adjustment in 2015,FEB is :
TIME GROUP RPTCURRENCY ENTITY IntCo CATEGORY ACCOUNT AUDITID SIGNDATA
2015.02 Group1 USD E100 I_NONE Actual A1000 Journal_M 1000
2015.02 Group2 USD E100 I_NONE Actual A2000 Journal_M 100
2015.02 Group3 USD E100 I_NONE Actual A3000 Journal_M 100
The customer expects the data of group2 and group3 to be consolidated to the group1 as below:
TIME GROUP RPTCURRENCY ENTITY IntCo CATEGORY ACCOUNT AUDITID SIGNDATA
2015.02 Group1 USD E100 I_NONE Actual A1000 Journal_M 1000+100+100
The question here is : When executing the BPC consolidation business rules (Automatic Adjustments), it only takes care of the data source (Audit ID) whose type is set to be ‘A’.
How can this be achieved?
It is not well known that we can use the property ‘DATASRC_STAGE’ of the AUDITID (datasource) dimension to achieve this
Regarding how to make the configuration for this is not documented on SAP help. But this is introduced on SAP Note 2049932. This functionality is available since BPC 10 NW SP15.
Please note:for this functionality, there are some subsequent fixes in later service packs, please refer to SAP Notes 2073249, 2098172 and 2163803.