Parent/Child Master Data Type

[Former Member]

I recently created a new master data type in my model, which included one attribute with the 'parent' check box checked - to signify that it was to be used as the parent.

Upon activating the master data type - the system auto generated several other attributes within the master data type.  My question is, what is the purpose of these additional attributes and how are they to be used?

Before Activation:

Attribute	Description	Notes
ID	ID	<< marked as key and as required
DESCR	Description	<< no special check boxes checked
PID	Parent ID	<< marked with parent check box

After activation:

Attribute	Description	Notes
ID	ID	<< marked as key and as required
DESCR	Description	<< no special check boxes checked
PID	Parent ID	<< marked with parent check box
IDA	Ancestor: ID	<< auto added after activation
IDL	Level: ID	<< auto added after activation
IDLA	Ancestor: Level: ID	<< auto added after activation
IDPTH	Path: ID	<< auto added after activation
IDPTHA	Ancestor: Path: ID	<< auto added after activation
DEACRA	Ancestor: Description	<< auto added after activation
PIDA	Ancestor: Parent ID	<< auto added after activation

[former_member620712 · Accepted solution]

https://share.sap.com/a:r2l29c/MyAttachments/38b00c31-a7f4-404c-8247-1a99ef4b0509/

Hey JJ,

The purpose of these attributes is for parent-child hierachy relationship.

In addition to above mentioned attributes, you should also notice (via HANA studio), that another Planning object gets generated automatically.  The new planning object should be the name of your parent-child object plus "_ANC" prefix at the end.

If you take a look at this planning object, you will notice that the object contains all the generated attributes (your attriubute plus "A" prefix at the end) in the definition.

Once you load data into your parent-child hiearchy object the "_ANC" object will automatically get populated with parent-child node relationship.

"A-prefix" attriubutes essentially represents the attributes of ancestor in this case.

In addition, in order to do Ancestor rolllup in your calculation you will also need to create an ancestor planning level which contains all the attriubutes of your base planning level as well as these "A-Prefix" attributes.

Please take a look at the document we created for "How to configure Parent-Child Hiearchy" from the share link

It has more detailed information.

Thanks.

Daniel.

[aldo_silva2 · Accepted solution]

Hi,

I am trying to open the link and get a no authorization message

Thanks

Aldo

[Former Member · Accepted solution]

Hi,

File "How to configure Parent-Child Hierarchy" is located on a server with restricted access. Is it supposed to be available? If so, could you please indicate how it can be retrieved?

Thanks,

Bernard

[former_member620712 · Accepted solution]

Hi,

Please try this link:

SAP Mobile Documents

[former_member620712 · Accepted solution]

HI please try this link:

SAP Mobile Documents

[Former Member · Accepted solution]

Thanks Daniel

[Former Member · Accepted solution]

Hi Daniel,

Can you please share that file again? The original link has expired.

Thanks,

Anna

[Former Member · Accepted solution]

Hi Daniel,

Can u please share that file again as provided link is expired.

Thanks

Ashish