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

Load of hierarchies from R/3 via flat file: how to generate that flat file?

Posted on Aug 24, 2004 at 06:38 PM 22 Views

Hello,

I need to build a custom extractor for a hierarchy. The hierarchy exists in R/3, but there's no standard datasource to extract it. I know I can upload it via flat file, but I have a question related to this.

Does anyone know if there's a program (standard or custom by SAP) or function module in R/3 which allows me to generate that flat file, with the required format by BW?

I would appreciate very much any help about this topic

Thanks in advance

Patricia

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2004 at 09:32 AM
    0

    Hi Patricia,

    if there is, I'd love to get hold of it.

    I have only ever managed this by extracting the relevant data into Excel and then doing a long series of VLOOKUPS to establish parent and child ids.

    I have a sample spreadsheet I can send you if you like.

    Regards,

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Feb 11, 2005 at 12:13 PM
    0

    Hi,

    1.Download the hierarchy from R/3 into a flat file and save it as a ".csv" file.

    2.The file should be of the same type as that of the transfer structure.

    3.The upload method would be thro' IDoc.

    4.The node name for root node and all the text node(for which there is no info-object) would be 0HIER_NODE.

    5.The structure would vary depending upon the hierarchy - time-dependent/sorted/with intervals,etc..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 11, 2005 at 01:19 PM

      Hi Patricia ,

      We have developed some programs in our project to create data in the format requested by BW.

      For this programs to work..The input format should be two columns . The first column is parent id and second column is child id..the entire hierarchy from old system was represented in this format...

      Let me know if you want info on this..

      Best Regards,

      Anil

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.