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

Adding a G/L under an Alternative number

Hello experts,

I have a requirement do create a hierarchy of alternative account and G/L accounts underneath of each alternative account. This alternative acc are selected based on chart of accounts. There is a set created on the alternative number. I have created a custom hierarchy and loaded it into BW

. t

This hierarchy structure is created under a G/L based infoObject. Which means that , the leaf node must be a G/L.

The G/L, and the Alternative account number are stored in SKB1 table. The Alternative number description is stored in SKA1 table. Those 2 tables are linked by the alternative number.

The hierarchy structure I have in BW, shows only the alternative numbers and the ranges. How do I automatically add corresponding GL?

Thanks for sharing your knowledge and experience on how I can achieve this requirement

intervals.gif (9.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 26, 2016 at 09:44 AM

    Hi,

    • create Alternative account number as infoobject
    • add that infoobject to GL account infoobject as external char in Hierarchy
    • load the hierarchy

    Grtz

    Koen

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2016 at 07:09 AM

    Hi,

    You can add alternative number as an attribute to GL in BI, then through ABAP in the EXIT you can load the alternative number to BI.

    If you want to use the hierarchy on Alternative number, then use the option Addional functions --> Generate Export Datawource from the infoobject GL. It will create an datasource naming 80GL_ACCOUNTH, then map it to the alternative number so as to load the hierarchy.

    Regards,

    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.