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 lower consolidation group need to reflected (consolidated) in the higher level group.

Following is an example:

Group1 is the parent of Group2 and Group3.The manual adjustment in 2015,FEB is :

TIME      GROUP     RPTCURRENCY    ENTITY  INONE CATEGORY  ACCOUNT AUDITID   SIGNDATA

2015.02  Group1        USD                       E100      I_NONE Acutal          A1000       Journal_M   1000

2015.02  Group2        USD                       E100      I_NONE Acutal          A2000       Journal_M   100

2015.02  Group3        USD                       E100     I_NONE Acutal           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  INONE CATEGORY   ACCOUNT    AUDITID     SIGNDATA

2015.02  Group1        USD                       E100      I_NONE Acutal          A1000             Journal_M   1000+100+100

The question here is : When executing BPC consolidation business rule, 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 his functionality, there are some subsequent fixes in later SPs,refer to note 2073249,2098172 and KB 2163803.

Enjoy.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply