Sharing a hierarchy from 0ACCOUNT with 0GL_ACCOUNT

[Former Member]

Is it possible to share a hierarchy that pertains to 0ACCOUNT with another info-object (eg, 0GL_ACCOUNT) ?

How can this be accomplished, without resorting to a flat file download / upload ?

Regards,

Frederick

[Former Member]

We had a similar requirement (to include a 0GL_ACCOUNT hierarchy in a profit centre report) so I'm posting our solution for the benefit of anyone searching the topic in the future.

My (probably imperfect) understanding is that 0ACCOUNT includes the full list of accounts within a chart of accounts within a controlling area. 0GL_ACCOUNT includes the subset that has been maintained in the hierarchies of financial statements (of which there may be a number of named versions). These hierarchies include the groupings of Assets and Liabilities, and Revenue and Expense items needed to generate balance sheets or income (profit and loss) statements.

So for many reporting purposes the two can be regarded as synonymous and interchangable. To include a 0GL_ACCOUNT hierarchy in a report that contains 0ACCOUNT:

• add 0GL_ACCOUNT as a navigation attribute of 0ACCOUNT
• assign 0ACCOUNT to 0GL_ACCOUNT in the master data update process
• make the navigation attribute (0GL_ACCOUNT) available in your cube and query

Be aware that this may result in accounts that are not GL accounts being added to the GL master data, but when reporting against transactional data this should not matter -- only those used in a given context will be referenced.

Naturally you could add 0ACCOUNT to 0GL_ACCOUNT in the same way.

[Former Member]

Hi,gurus,

the blow thread can help you possiblely,

[http://forums.sdn.sap.com/thread.jspa?threadID=1668243|http://forums.sdn.sap.com/thread.jspa?threadID=1668243]

Edited by: lenolotus on Feb 10, 2012 4:03 AM

[Former Member]

Thanks for your replies.

I found this article which might help...

http://www.element61.be/e/resourc-detail.asp?ResourceId=189

[anindya_bose]

Please check my last reply...Once try with export DS of InfoObject...0ACCOUNT

[anindya_bose]

If you create export DataSource for 0ACCOUNT , it will create one DS 80ACCOUNTH ...this is a hierarchy DS.

Check if you can attach this to 0GL_ACCOUNT ofr ZGL_ACCOUNT

Create transfer rule by right clicking on the new export DS , in the InfoSource assignment select other. It will show 0GL_ACCOUNT. Check if data can be loaded.

Regards

Anindya

Edited by: Anindya Bose on Feb 10, 2012 6:23 AM

[former_member182346]

I doubt it is possible since even using reference char wont share the hierarchy table with original object, I was thinking of creating zobject with ref. to 0ACCOUNT and try, but not possible.

0ACCOUNT and 0GL_ACCOUNT are not having reference too.

Thank-You.

Vinod

[Former Member]

0ACCOUNT denotes the operational GL account in the function of Profit Center Accounting while 0GL_ACCOUNT denotes the operational GL account in the function of General Ledger Accounting.

Could you please tell me more about your requirement?