How do we create and manage custom relationships between fields?

There are two data import tasks for relation entries: Import Relations and Import Relation Entries.

First, use the Import Relations data import task to establish a relationship between two fields using RelationType.csv.

For example, to establish a relationship between the Supplier and Company Code fields, import the file as below:

UTF8
UniqueName,Name,LeftClass,RightClass
SupplierCompanyMap,Supplier to Company Validation,ariba.core.Supplier,ariba.core.CompanyCode

Next, use the Import Relation Entries (RelationEntry.csv) data import task to map the values in one field to the values in another field (both of which must already be included in RelationType.csv).

For example, to satisfy the the following business requirement:

• Supplier SUP_0523 should be mapped to company codes Company112, Company113, and Company114
• Supplier SUP_0536 should be mapped to company codes Company120, Company121, and Company122

You can use the following file:

UTF8
RelationType.UniqueName,LeftId,RightId,LeftKey1,LeftKey2,LeftKey3,RightKey1,RightKey2,RightKey3
SupplierCompanyMap,SUP_0523,Company112,SUP_0523,,,Company112,,
SupplierCompanyMap,SUP_0523,Company113,SUP_0523,,,Company113,,
SupplierCompanyMap,SUP_0523,Company114,SUP_0523,,,Company114,,
SupplierCompanyMap,SUP_0536,Company120,SUP_0536,,,Company120,,
SupplierCompanyMap,SUP_0536,Company121,SUP_0536,,,Company121,,
SupplierCompanyMap,SUP_0536,Company122,SUP_0536,,,Company122,,

The combination of values in the LeftId and RightId columns establishes each relation entry as unique.
You can make up these values or use existing field values.
In the example above, the LeftKey1 and RightKey1 values are used for LeftId and RightId.

For more information on custom relationships between fields, see the Common data import and administration guide.

Procurement Application Services > Application Framework > Customizations (Service)