How to RollUp Amount data based on SAP BI GL Account to BPC Grp GL Account

[Former Member]

Hi All,

Initial data format

EXTERN INTERNAL AMT

GL Acco Grp GL ACC AMT

0200001 100000 0100

1000000 100000 0200

1000010 100000 0300

1000011 100000 0400

1000012 100000 0500

1000020 200000 0010

1000030 200000 0020

1001000 200000 0030

1001001 200000 0040

1001002 200000 0050

We are having Group GL Account as our master data in member sheet of Account dimension. And we are having GL accounts coming in BPC from SAP BI System ( ECC ) and are mapped (as in above) to Group GL Account in N:1 mapping.

We need to get the expected Rollup Amount data (Refer 3rd column) as below.

Expected Rollup Amount

Column 1 Column 2 Column 3

EXTERN INTERNAL AMT

GL Acco Grp GL ACC AMT

0200001 100000 0100

1000000 100000 0300

1000010 100000 0600

1000011 100000 1000

1000012 100000 1500

Please share your valuable inputs in this regard.

Regards

Amit

[Former Member · Accepted solution]

Hi,

Since, you are converting all the external GL accounts to the same internal Group GL account, it wont be rolled up. Instead, it will be aggregated.

If you report on 100000, you will see the data as a total sum.

Hope you got the idea.

So, this means, you cannot map all of them to the same internal member. You need to map them to different members and you need to create a hierarchy on those members for the correct rollup to take place.

Hope this helps.

[Former Member]

To resolve this issue we wrote ABAP code in BADI.

[Former Member]

Can you please post your Data Model of your Account Dimension and its properties

[Former Member]

Hi Experts,

Thanks for your help and suggestions. This issue was resolved by BADI.

To roll up GP GL account to operational account we used BADI. Its working fine.

Regards.

Amit

[Former Member]

Hi Experts,

I hope you people clear about my query. Related to below issue let me know any details required from my end.

Please share your valuable input.

Regards

Amit