Skip to Content
author's profile photo Former Member
Former Member

Hierarchie load from Flat file

Gurus,

1) I installed 0HIER_NODE but I can not see this infoobject in RSA14. But I can see 0HIER_TYPE. Is this the cause for the failure of data load from flat file? 'Coz in the sample flat file in the forums, there is 0HIER_NODE. I could not find any sap note on this.

2) How does data look in a hierarchy? For 0CUST_SALES_TID_LKDH_HIER, I see 6 records in RSA3, but I don't 6 records in hirearchy in BI.

3) I don't see manage option for any of the hierarchy datasources, and don't see PSA icon from InfoPackage. How to check the data?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 22, 2009 at 03:54 PM

    Hierarchies are usually loaded as an iDoc ... and PSA is not used for the same. Also RSA3 is for Hierarchies in R/3 and you are confusing the same with fllat file.

    Once you set it to iDoc you will be ale to see the file structure in the transfer rule area..

    As for how to load - please search the forums for the same...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Arun Varadarajan

      I figured it out. In the InfoPackage External Data tab, for Number of Header Rows to be Ignored, I entered one and it worked fine. The reason for this is: in the flat file, the header row has a field 'InfoObject' and title was not recognized by the infopack. Thanks again. Assigned points.

  • Posted on May 22, 2009 at 03:12 PM

    Hi,

    I dont think thats the reason for your load failure... What error are you getting when you load the data??

    There is no manage option for Hierarchy... Not does it load into PSA.. If you chk in the InfoPackage, you will see ALE Inbox and InfoObject only.. THere is no option for PSA...

    Just go to InfoObjects tab and find your infoobject there, you will see the hierarchy under it...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.