Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 07:26 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2011 at 03:39 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 07:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2011 at 02:26 PM

    To resolve this issue we wrote ABAP code in BADI.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.