Adding a G/L under an Alternative number

[Former Member]

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

[kohesco · Accepted solution]

Hi,

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

Grtz

Koen

[former_member210321]

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,