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