Skip to Content
avatar image
Former Member

GL Account summary in Report Painter

Hi Gurus

I have a question around Report painter report. We have such reports where the Profit center is based on the PC group set-up in the PCA Master records. The result is that we can analyze our report painter reports by clicking on a heirarchy and view the output for specific PC only. We want to do the same thing for our GL accounts. For example say 10 GL accounts belong to level 1 and 5 belong to level 2. When we clisk level 1 in Report painter report, the output should be only for 10 accounts.

The issue is that I don't see any place to create GL structure like we have for PC. Can someone please help me if it possible to create suc Account summary nodes?

Thanks,

Shalu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 02, 2011 at 09:31 PM

    If you enter cost element (G/L account) group in the report selection, it returns result in cost element hierarchy.

    For example, S_ALR_87013613 - all you need to do to click to collapse the icon on the left margin of report. It closes by account group level.

    Another alternative is to hard code the account group in the report row.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 02, 2011 at 09:39 PM

    Hi,

    use a financial statement version (which is nothing else than a hierarchy of accounts grouped to nodes) that fits your requirement and create sets that can be used in report painter by using T-code KE5B.

    Or create the account sets manually using GS01 T-code.

    best regards, Christian

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 03, 2011 at 03:40 AM

    Hi Shalu

    I had this requirement once and I addressed it using SETS

    1. Create a Basic SET from GS01.... Basic Set would mean individual groups....

    2. Then create a Multi SET from GS01, which would be a combination of Basic Sets...

    For eg: GLs for Basic Salary + DA + HRA can be part of Basic Set.... This Basic Set can be part of a Multi Set called Operating expenses

    Basically, you can design your sets in the same manner as Your Financial Statement version... While defining the report, you can include your Set in the report definition and choose to "Explode" it or Not... If you explode - Each individual GL account will be shown.... Else, only the group would be shown

    Br, Ajay M

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Shalu,

      The concept of 'Single Set' and 'Multi set' lies in the fields you are using.

      In 'Single Set' you can use only 'Single sets' with one field for example 'RACCT' .

      But in 'Multi set' you can use 'Single Sets' which have many fields like 'RACCT' , 'BUKRS'..etc

      In your scenario i guess you are using only one field 'RACCT' so you can use only 'Single Set' grouped with many 'Single Sets' and 'Basic Set' with values.

      ~Andrew