Extracting Hierarchy node values

[Former Member]

Greetings,

I am looking for an F/M or ABAP code that would allow me to extract the contents of a hierachy node.

I have a Characteristic - 0GL_ACCOUNT that has hierarchies and I need to be able to extract the contents of a node/sub node in that hierarchy.

The extraction of the contents will help drive a Z delete program to clean up previously loaded data in a datasource.

Thank you

[Former Member]

Let me provide additional details.

I am not trying to load G/L hierarchies into our Warehouse, they are already there.

What I need to do it to extract the specific G/L accounts under a node/subnode in BW so that a delete program can remove entries out of a datasource.

The datasource gets its data from other datasources.  So I have created a general use Zdelete program that will have a variant.  The variant will control which entries will be deleted based on the G/L accounts of a hierachy node.  The nodes designate the source of the data.

Currently I have hard coded the accounts for each source, however the nodes can change which then require an update to the delete program.  It would be more efficient to refer to the node in the zdelete program.

[former_member197610]

Bill,

In this case, If you have ABAPer in your team, get help from them showing the source tables and the criteria's need to be extracted. They will help you getting the data what you want.

Hope this helps...

[former_member197610]

Check the Tables,

FAGL_011ZC - Fin. Statement Structure: Assignment FS  Items - G/L Account

FAGL_011QT  - Fin. Statement Structure: Text for Fin. Statement Items

Below are the tables related to Financial statement version

FAGL_011FC

FAGL_011PC

FAGL_011QT

FAGL_011SC

FAGL_011TC

FAGL_011VC

FAGL_011ZC

Get help from ABAPer to use these tables in your extractor.

[Former Member]

Thanks Suresh, but these tables are on ECC.

What I am looking for is way of extracting the contents of hierarchy nodes already stored on the BW side or the name of the table in BW that stores the node names and the contents.

[former_member197610]

Bill,

Hierarchy table in BW would be /BI0/HGL_ACCOUNT.

[Former Member]

Yes, my apologies for not mentioning that I was referring to that table.

I was just trying to find an existing function module or program that already existed instead of building one from scratch.

[former_member197610]

Bill,

Check the FM's,

RSSH_HIERARCHY_SELECT

RSNDI_SHIE_STRUCTURE_GET3

RSSH_HIERARCHY_READ

RSSH_HIERARCHY_GET

[former_member197610]

Hi Bill,

You can see the GL _account hierarchy, the financial statement version in the Txn - FSE3.

Use the standard DS - 0GL_ACCOUNT_T011_HIER and load the data into BW, you all set.

Hope this helps..

[former_member182346]

Hi,

Why you are not using standard hierarchy datasources for extracting the GL a/c hierarchy maintained in ECC ?

Is there any specific reason ?

Their is a std datasource given by SAP to extract hierarchy structure.

Thank-You.

Regards,

VB