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

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Have You seen the "how to" document that describes the use of program Z_SAP_HIERARCHY_DOWNLOAD

[Former Member]

No, but sounds interesting.

Can't see anything like it on the BW Info Index or on OSS.

Can you provide a pointer?

Thanks,

Mike

[Former Member]

Hi... I am now looking at this problem -- i.e. how to create the bw hierarchy format.

Mike -- do you have the spreadsheet you mention (or does anyone else) that has the VLOOKUPS coded as an example?

Thanks,

Flip.