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

Flat File Hierarchy Datasources

We are creating several flat file hierarchy datasources. The datasources will be maintained in an external database.

I am familiar with the creation of flat file datasources for master and transactional data, but don't have good documentation for how the external flat file hierarchy is to be formatted.

We have reviewed the 2004 Netweaver Document "How to Download Hierarchies in BW" and have used the program referenced there, Z_SAP_HIERARCHY_DOWNLOAD, to download our hierarchies to then test the upload.

However, this has not worked.

Does anyone have the record layout that the flat file must be in to upload a simple 2-level hierarchy (for example groupings of 0vendor)?

Thanks, Doug

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 03:02 PM

    Hallo

    I can provide you this link for the load of hierarchy in flat file. I will look for an example but in the documentation is exapliane din a simple way and you follow it you got the result. DO you a mail address:

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I think the URL you mention is http://help.sap.com/saphelp_nw04/helpdata/en/fa/e92637c2cbf357e10000009b38f936/content.htm.

      This contains the record layout instructions as follows.

      5. Maintaining the hierarchy:

      Choose Hierarchy Maintenance, and specify a technical name and a description of the hierarchy.

      PSA Transfer Method: You have the option here to set the Remove Leaf Value and Node InfoObjects indicator. As a result, characteristic values are not transferred into the hierarchy fields NODENAME, LEAFFROM and LEAFTO as is normally the case, but in their own transfer structure fields. This option allows you to load characteristic values having a length greater than 32 characters.

      Characteristic values with a length > 32 can be loaded into the PSA, but they cannot be updated in characteristics that have a length >32.

      The node names for pure text nodes remain restricted to 32 characters in the hierarchy (0HIER_NODE characteristic).

      The system automatically generates a table with the following hierarchy format (for sorted hierarchies without removed leaf values and node InfoObjects):

      Description

      Field Name

      Length

      Type

      Node ID

      NODEID

      8

      NUMC

      InfoObject name

      INFOOBJECT

      30

      CHAR

      Node name

      NODENAME

      32

      CHAR

      Catalog ID

      LINK

      1

      CHAR

      Parent node

      PARENTID

      8

      NUMC

      First subnode

      CHILDID

      8

      NUMC

      Next adjacent node

      NEXTID

      8

      NUMC

      Language key

      LANGU

      1

      CHAR

      Description - short

      TXTSH

      20

      CHAR

      Description - medium

      TXTMD

      40

      CHAR

      Description- long

      TXTLG

      60

      CHAR

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 04:55 AM

    Hi Doug,

    could you please provide me with the code for Z_SAP_HIERARCHY_DOWNLOAD and also the link to your 2004 document.

    also, do you still need help with your file format.

    We have the load side mastered but not the BW extract.

    Thanks, Colin.

    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.