Defining Explicit Key Mapping 

Use

To ensure referential integrity between the nodes of a data object, the back-end keys of the nodes higher up in the node hierarchy of the data object must also be available as back-end fields in the child nodes. The corresponding fields must be mapped to each other. One option for mapping these keys is the explicit key mapping function in the data object Builder.

More information: Data Object-Internal Key Mapping

Prerequisites

●      You have created a data object and have added the required nodes.

●      The individual nodes contain back-end fields that hold the back-end keys of the nodes higher up in the node hierarchy of this data object.

●      You have saved the nodes.

Define explicit key mapping before activating the data object.

More information: Explicit Key Mapping

Procedure

...

       1.      Log on to the NetWeaver AS and start transaction SDOE_WB.

       2.      In the Data Orchestration Workbench, click the required child node with the secondary mouse button and choose Change.

       3.      Choose Explicit Key Mapping.

The parent node name(s) and parent node attribute(s) acting as the back-end key(s) are displayed in the Explicit Key Mapping tab page.

       4.      Choose  Display/Change.

       5.      In the Node Attribute column, select the child node attribute that you want to map to the parent node attribute.

       6.      Choose Save.

If you have used explicit key mapping after activation of the data object to change the system’s automatic mapping, you must choose  Generate to regenerate the tables created in the CDS.