on 06-15-2009 2:04 PM
Hi experts,
I have requirement to load hierarchies using flat file.
I have to create hier on Person Responsible, sub nodes are Sales Office, Project Definition, Project Type and Project Definition Description. I have file, i need to load into BW.
I dont know much about hier loading, can you tell me what are the Attributes to be inserted and how to prepare the hier loading file which contains HIENM, VERSION, HCLASS, DATEFROM and DATETO.
I dont know these fields are enough to load my hier.
I have created one hier, when i try to activate it's giving error like ' no data exists'.
Can anyone tell me how to prepare file to load into hierarchy?
Thanks in advance,
Venky
Hi,
Please refer to this blog:-
/people/prakash.bagali/blog/2006/02/07/hierarchy-upload-from-flat-files
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can see the format in this help page
loading hierarchies from flat file.
http://help.sap.com/saphelp_nw04/helpdata/en/fa/e92637c2cbf357e10000009b38f936/frameset.htm
flat file structure if you use IDOc
http://help.sap.com/saphelp_nw04/helpdata/en/de/113037530b7774e10000009b38f839/content.htm
when you use PSA
http://help.sap.com/saphelp_nw04/helpdata/en/b0/ab8e3cb4340b14e10000000a114084/content.htm
Regards,
Kams
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Venkatesh,
U can go loading Hierarchies through Flat File by maintaining the Flat File Structure as
1. Node ID
2. InfoObject
3. InfoObject Name
4. Link
5. Parent ID
6. Language
7. Short Description
8. Medium Description
9. Long Description
Thanks & Regards
Ramakrishna Kamurthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Venkatesh,
U can go loading Hierarchies through Flat File by maintaining the Flat File Structure as
1. Node ID
2. InfoObject
3. InfoObject Name
4. Link
5. Parent ID
6. Short Description
7. Medium Description
8. Long Description
Thanks & Regards
Ramakrishna Kamurthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkatesh,
There are several formats to load a hierarchy via file. The following two are the commonly used formats.
1) Default
Node ID NODEID
InfoObject Name INFOOBJECT
Node Name NODENAME
Link Name LINK
HghrLvlNode PARENTID
Language Key LANGU
Description - Short TXTSH
Description - Medium TXTMD
Description - Long TXTLG
2) Sorted
Node ID NODEID
InfoObject Name INFOOBJECT
Node Name NODENAME
Link Name LINK
HghrLvlNode PARENTID
First Subnode CHILDID
Next Node Along NEXTID
Language Key LANGU
Description - Short TXTSH
Description - Medium TXTMD
Description - Long TXTLG
If Default format is used, the sequence of node IDs appeared in the flat file determines the structure of the hierarchy. Whereas the sorted hierarchy format defines the structure via PARENTID, CHILDID, NEXTID relationship.
You make the selection in DataSource/Tran.Structure tab of InfoSource Page by clicking on the "Hier. Structure button.
Good luck!
Bill
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.