Hierarchy from Flatfile

[Former Member]

Hello Gurus,

I have a Custom Employee Hierarchy loading from a Flatfile.

Hierarchy file structure is as follows

nodeid,iobjname,nodename,blank,parentid

12680,0HIER_NODE,NAME1,,0

12451,0HIER_NODE,NAME2,,12680

12517,0HIER_NODE,NAME3,,12680

12579,0HIER_NODE,NAME4,,12680

12580,0HIER_NODE,NAME5,,12680

13176,ZEMPRECID,NAMNE6,,12680

13201,0HIER_NODE,NAME7,,12680

12459,0HIER_NODE,NAME8,,12451

12469,0HIER_NODE,NAME9,,12451

12568,ZEMPRECID,NAME10,,12579

I get errors at ZEMPRECID. Error is like

"Node ID 00012568 , char.value 0000 , exists several times under node ID 00012579 RH 211"

Could somebody help me out.

thanks

jose

[Former Member]

can you emil me the picture of the step about how to loaded individual values of the hierarchy using CSV file

thank you very much

my emil is <Removed>

or give me you msn

thank you very much

my emil is :<removed>

allen

[Former Member]

Hi,

What is the infoObject name the query is built on? Its not ZEMPRECID or is it? Is ZEMPRECID an external characteristic?

Or could you check if there are any external characteristics included?

Gova

[Former Member]

Hello Gova,

ZEMPRECID is the infoobject(basic characteristic) on which the hierarchy is built on. This is not included as an external characteristic. I tried to include this as an external characteristic but still the same error. This is just a time independent hierarchy. The data is coming from SQL tables to a .csv flat file.

I tried to test it by changing all the infoobject name to 0HIER_NODE. I am getting the child id and next id generated by the system. Master data attr and text are loaded just fine.

Thanks

jose

[Former Member]

Hi Jose,

Please refer the weblog on loading heirachy from flatfiles.

/people/prakash.bagali/blog/2006/02/07/hierarchy-upload-from-flat-files .

It may help you.

Regards,

Prakash B

[Former Member]

Jose

It seems in your hierarchy your are using node ID 12568 under other node ID 00012579 RH 211

Please follow this structure and hope this helps

http://help.sap.com/saphelp_nw04/helpdata/en/b0/ab8e3cb4340b14e10000000a114084/frameset.htm

Thnaks

Sat