How to see data in hierarchy

[Former Member]

Experts,

I was searching on the forums, but could not find an appropriate thread on this. I want to see data

1. In PSA tables or equivalent for the hierachy data after succesful infopackage load. I can see the number of records in the monitor for infopack, but how to see the actual data for that run some where like 'ALE Inbox'.

2. When I click on 'display' of the hierarchy, I can see the infoobjects under the hierarchy, but how to see the actual data inside those infoobjects?

Please list the tcodes if possible.

[Former Member · Accepted solution]

Hi Latha,

Whenever you create a hierarchy and activate it, an internal ID called Hierarchy ID will be generated and this information is stored in the table RSHIEDIR. In SE12 go to this table and in place of HIENM give the name of your Hierarchy and IOBJNM as the name of the infoobject for which you created this hierarchy(0costelmnt in this case). With this you will get a HIEID.

Pass this HIEID to the Hierarchy (H) table of the costelement infoobject(/BI0/HCOSTELMNT) and here you will find all the 9 records that you loaded for your hierarchy. Hope this helps solve your issue.

[Former Member · Accepted solution]

Srikanth,

You said: "In SE12 go to this table and in place of HIENM give the name of your Hierarchy and IOBJNM as the name of the infoobject for which you created this hierarchy(0costelmnt in this case). With this you will get a HIEID".

In SE12(it's same as SE11) I entered the table name and got into the table, but I don't see any place to enter the value for HIENM? It's just a display of all fields/data elements of the table. Please explain in detail.

[Former Member · Accepted solution]

Srikanth,

I found this in SE16. Thanks a bunch. Assigned full points.

[former_member184494]

Hierarchies are usually ttransferred using the iDoc interface which means that they do not use PSA... the only way to see the data for a hisrearchy would be to see it in the maintain hierarchy option in RSA1 or in the infoobject details screen.

[Former Member]

Arun,

Here is what I found: when I ran infopack for 0COSTELMNT_HIER, I see 9 records loaded in the monitor, but as I check the hirarchy, all I see is two folders Revenue internal and revenue external. the first folder has one subfolder and the second one has two taking that a total of 5 folders. Considering each folder is a record, where are the other folders gone?

In ECC, when I ran RSA3, I can see the data clearly. Is there a way to check iDoc content? Thanks in advance.

[raju_saravanan]

Dear Latha

After Succesful load to PSA , You need to scheudle to object for hierarchy.

After the succeful schedule ,you can see hierarchy data loaded in different objects in Maintain hierarchy.

You can't see the hierachy data without scheduling from PSA to Object. But raw data can be seen in PSA.

Regards

Raju Saravanan

[Former Member]

Check out 0Costelement_hier in RSH1 tcode.

[Former Member]

Raju,

As I am given to understand, hierarchy data is loaded via idocs and not PSA. If it is via PSA, please list the steps how to check data in PSA?

[Former Member]

It is the same in RSH1 too. Basically, RSH1 has all the hierarchies in one signle place. Content wise, it has the same content as you check via RSA14 or RSA15.

[raju_saravanan]

Dear Latha;

I am explaning all about using Flat File extraction for hierarchy.

After scheduling , you can see all data in Segment level.

This is just like ordinary extraction method and flat file should be in organized way to load as hierarchy will follow only in 3x method.

Get back any issues on.

Regards

Raju Saravanan