Skip to Content
0
Former Member
Apr 18, 2011 at 04:09 PM

How to load GL Account?

341 Views

The topic might seems simple, but I have the following complications and scenario:

0GL_ACCOUNT has master data while the GL account FSV (Financial Statement Version or hierarchy in simple terms) is on 0GLACCEXT. 0GLACCEXT is an attribute of 0GL_ACCOUNT.

0GL_ACCOUNT has master data and 0GLACCEXT has hierarchy (no master data).

In BPC, while using the standard DM package, when I am pulling master data from 0GL_ACCOUNT, it comes fine. But since there is no hierarchy, the text nodes dont come in. Now, when I pull FSV (or hierarchy) from 0GLACCEXT, it says "missing text nodes". tried a work around by creating another InfoObject (ZGL_ACCT) - 0GL_ACCOUNT feeds master data while 0GLACCEXT feeds FSV (or hierarchy). Now ZGL_ACCT has both - master data and hierarchy.

The issue is - accounts are marked as debit or credit. so any account that comes into BW, is tagged with either "A", "1A" and "2A". When I am pulling master data in BPC - these A, 1A and 2A done come in - though I can see them in master data of ZGL_ACCT in BW. Why so???

Eg:

BW -

ZGL_ACCT

1000

1000 A

10001A

10002A

BPC

GL Account dimension

1000

<nothing else>

Can someone suggest what could be issue or how to make this work??

Thanks.

Anand