Loading Heirarchies from Flat Files

[Former Member]

Hi Guys,

I have a really simple question. I want to load a heirarchy from a flat file and I have 2 questions.

Before the questions this is the structure of the hierarchy.

Node1 Node2 Node3 (level 1)

Node1A Node2A Node3A (Level 2)

Leaf1 leaf4 leaf7

Leaf2 leaf5 leaf8 (level 3)

leaf3 leaf6 leaf9

Level 1 & 2 are just Texts e.g.,Nothern Region

Level 3 are the actual values e.g, Ontario

level 3 values should be able to be sumarised in Level 1 and 2.

Now my question is.

What selections should I make when creating the Object?

What will be structure of the flat file?

There is no time dependency!

[Former Member]

Hi Anil,

I have looked at that before. It does not tell me what I want know. Probably because I don't know, I am not interpreting it correctly.

Based on the example I have above. The leaves for my hierarchy are up to 8000 values. How do I structure the nodes and the leaves in a flat file.

Can someone give me an example pls.

[Ashwin]

Hi!

you use the 0HIER_NODE -for infoobject of Text nodes that is level 1& 2 nodes

any infoobject (ex.0region) for the leaf nodes.

your flatfile might look like this if i asume your leaf nodes as 0region.

Node ID;InfoObject name;Node name;Catalog ID;Parent node;First subnode;Next adjacent node;Language key;Description - short;Description - medium;Description- long;0Region
1;0HIER_NODE;Node1;;0;4;2;en;Node1;;;
2;0HIER_NODE;Node2;;0;5;3;;Node2;;;
3;0HIER_NODE;Node3;;0;6;;;Node3;;;
4;0HIER_NODE;Node1A;;1;7;;;Node1A;;;
5;0HIER_NODE;Node2A;;2;10;;;Node2A;;;
6;0HIER_NODE;Node3A;;3;12;;;Node3A;;;
7;0region;;;4;;;;;;;Leaf 1
8;0region;;;4;;;;;;;Leaf 2
9;0region;;;4;;;;;;;Leaf 3
10;0region;;;5;;;;;;;Leaf 4
11;0region;;;5;;;;;;;Leaf 5
12;0region;;;5;;;;;;;Leaf 6
13;0region;;;6;;;;;;;Leaf 7
14;0region;;;6;;;;;;;Leaf 8
15;0region;;;6;;;;;;;Leaf 9

it might be a bit different for your compleate data model but i just gave a sample...

hope it helps.

with regards

ashwin

[Former Member]

Hi,

In the foolowing link,the structure of flat file is clearly mentioned .

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

With rgds,

Anil Kumar Sharma .P