Hierarchy: Postable node (or not) in Flat file

[Former Member]

Hello Experts,

I have read several times, the links you provided on this subject and they were very helpful but I am still stuck here:

If I am loading a hierarchy through a flat file, how do I specify which of these nodes are postable and which are not?

I know the Leave notes are postable, but my issue is with the various interval nodes

For example, in this Customer profit center hierarchy ....

NodeID|InfoObject Name| Node Name----- |--Link-|-ParentID|Child-|----Next ID

0001----|0Hier_Node|--Customer--|

---

|---0

---

|2---|--0---

0002----|-0Country--

---

|-China

---

|

---

|

---

| -

---

|----

0003----|-???--

---

|50000

---

|

---

|

---

| -

---

|----

0004----|-oRegion--

---

|RegB

---

|

---

|

---

| -

---

|----

0005----|-???--

---

|60000

---

|

---

|

---

| -

---

|----

0005----|-???--

---

|70000

---

|

---

|

---

| -

---

|----

What I want to achieve in the flat file, is to place region and the profit center 5000 under country, and make the profit center 5000 postable but Region is not postable.

Also, under Region is RegB which is supposed to be NOT postable, but it has 2 profit centers under it, 6000 and 7000 which should be postable.

Root

-

---

Country---5000

-

---

Region

-

---

RegB---6000 / 7000

Any help on this flat file will be appreciated. Where I have ???, I only meant I have doubts but I think it should be 0ProfitCtr.

[Former Member · Accepted solution]

Hi,

I'm sorry, but I don't understand the concept "postable". Do you mean with "postable" that the node can be uploaded to the hierarchy?

If that is the case, and you are having problems with 0country, 0region or 0profitctr, you need to add them to the "External characteristics in Hierarchies" option on the InfoObject.

Go to the 0PROFITCTR infoobject, select Hierarchy tab and click on "External chars in Hierarchies". There, you should add 0country and 0region.

Hope it helps,

David.

[Former Member · Accepted solution]

Thanks but my concern is more to do with how you handle this if you are loading a hierarchy with a flat file.

Can any of you use the above example to explain it to me?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

I don't know if this is what you mean...

NodeID|InfoObject Name| Node Name----- |--Link-|-ParentID|Child-|----Next ID

0001----|0Hier_Node|--Customer--|

---

|---0

---

|2---|--0---

0002----|-0Country--

---

|-China

---

|

---

|---1

---

| -

---

|----

0003----|-???--

---

|50000

---

|

---

|-2

---

| -

---

|----

0004----|-oRegion--

---

|RegB

---

|

---

|--2

---

| -

---

|----

0005----|-???--

---

|60000

---

|

---

|

---

4--| -

---

|----

0005----|-???--

---

|70000

---

|

---

|--4

---

| -

---

|----

(hope it is readable)

In the hierarchy flat file you only need to specify the parent node of a row. That way your hierarchy will get linked. That is how we load our flat file hierarchies and it works perfectly.

Regards,

David.

Message was edited by: David Sirvent

[Former Member · Accepted solution]

Hello,

From this link:

http://help.sap.com/saphelp_nw04/helpdata/en/c1/493d3854129f68e10000009b38f8cf/content.htm

you will see that not all nodes are “postable” – postable has been defined on that that link.

The question is still

If I am loading a hierarchy through a flat file, how do I specify which of these nodes are postable and which are not?

For example, what do I do to make Region is not postable.

Also, since you’ve done this before, I still have not been successful in loading the file and my problem lies in the relationship between the “InfoObject Name” and “Node Name” column. Can you discuss them and see advice me (based on the initial post ), and what you think the InfoObject column should be?

Also, you seem to be suggesting that I can leave the NextID and ChidID blank, but my research shows that the hierarchy will be “sorted” if handled otherwise. We’ve been instructed to create it as a sorted hierarchy.

Thanks in advance.

[Former Member · Accepted solution]

Hello Amanda...

Please check this link this cud help you...

http://help.sap.com/saphelp_nw04/helpdata/en/fa/e92637c2cbf357e10000009b38f936/frameset.htm

also could you brief me more about ur prob so that i can try helping you......more clarifictaion on pasatbale nodes and non postable nodes..

[Former Member · Accepted solution]

Hi,

I believe now I understand better your question.

From the link you sent I see that postable nodes are nodes that will have a value from the characteristic of which you are defining your hierarchy (you see an example at the end of the page you sent).

Non postable nodes only group underlying nodes, but they won't have a value from the basic characteristic (in your case, 0PROFIT_CTR).

The column "InfoObject name" is defining what kind of value will have the "Node Name" column. So, on the first column you establish types, while on the second you establish values.

The infoobject column is ok, you only need to set 0PROFIT_CTR on the ???? marks.

Maybe you can also check the provided links...

Regards,

David.

[Former Member]

Hi,

Go through this link

Uploading Hierarchies from Flat Files :

http://help.sap.com/saphelp_nw04/helpdata/en/fa/e92637c2cbf357e10000009b38f936/content.htm

Regards

Siddhu