Hierarchy -Child and parent Relationship

[former_member219689]

Hi Friends,

We are creating flat file to  upload hierarchies from flat file source systems. The source file is like below.

Child	Node 1	Node 2	Node 3	Node 4	Node 5	Node 6	Node 7
311000	311220NET-HAW	NTWK-HAWA-REV	TTL-NWHW-REV	TTL-REVENUE	PRE-OH-MARGIN	PBA	PBIT
311000	311220NET-HAW	NTWK-HAWA-REV	TTL-NWHW-REV	TTL-REVENUE	PRE-OH-MARGIN	PBA	PBT

Node 7 is the highest node.

Here for GL account we have same parents and highest  level we have different parents values. If we see node 6—we have PBA value; for this we have two parent values PBT and PBIT.

I have created flat file in the below format.

Node ID	InfoObject	Node Name	Link	Parent ID	Language	Short Description	Medium Text	Long Text
1	0HIER_NODE	TEST_TWO_PARENTS			EN
2	ZCSEVENTH	PBIT		1	EN
3	ZCSEVENTH	PBT		1	EN
4	ZCSIXTHLE	PBA		3	EN
5	ZCNINTHLE	PBA		2	EN
6	ZCFIFTHLE	PRE-OH-MARGIN		5	EN
7	ZCFOURTHN	TTL-REVENUE		6	EN
8	ZCTHIRDLE	TTL-NWHW-REV		7	EN
9	ZCSECONDN	NTWK-HAWA-REV		8	EN
10	ZCTOPNODE	311220NET-HAW		9	EN
11	YCOGNOSGL	311000		10	EN

And the output came as  like below attched file.

We are expecting same GL account to be assigned with another node as well.

Please guide me how we can configure hierarchy file to get the same GL account values to be assigned to two nodes.

[former_member223480]

Hi Anand

Have you checked the following document?

https://websmp208.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000277675&_SCENARIO=011000358700000001...

Maybe you can find what you want with a reverse action, create the hierarchy in the way you want, download it and check how is constructed with the program.

Then use the same logic to build your file and upload it in the system.

Thank you

Yiannis