Skip to Content

BW - Infoobject Hierarchy from ODS / File

Hi All,

I have FIle / ODS - which has data like -

Gl Account ( ZGL_ACCOUNT ) --- Name of Infoobject ( tech Name )

Gl Account ( ZGL_ACCOUNT ) || Micro Package ( ZMPAKG) || Sub Package(ZSPAKG) || Package( ZPAKG) || Organization ( ZFORG)

Now I want to make ZGL_ACCOUNT as hierarchy enable ( Time Independent , language Independent ) and load it via AL11 files generated by ABAP , reading the ODS which has data as above mention columns .

Is there a sample programs or steps alogo where hierarchy was created from above fields.


Sample Data :

GL1 | MP1 | SP1 | P1 | ORG1

GL2 | MP2 | SP2 | P2 | ORG1

GL3 | MP3 | SP1 | P1 | ORG1

GL4 | MP4 | SP2 | P2 | ORG1

GL5 | MP3 | SP1 | P1 | ORG1

GL6 | MP4 | SP2 | P2 | ORG1

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 05, 2019 at 02:45 PM

    An quick Google search leads us to

    https://blogs.sap.com/2012/03/15/loading-hierarchies-from-flat-file-using-the-new-datasource-and-transformation-technology/

    Hierarchies can be difficult to load and can cause performance issues during query execution.

    Consider storing the data as mater data attributes and using a structure to display the attributes in a predefined structure. This will give the users a standard display, as well as "slice and dice" capabilities.

    John Hawk

    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.