Derivation of Fields in the Business Partner Data Model

This document describes an example of how to derivate the value of a field if you enter a specific value into another field: In the example entering the company code 1000 leads to the derivation of reconciliation account with the value 31000.

To access an entity type 4 that has a cardinality 1:1 (for example BP_CENTRL), you have to define the derivation DERIVE_BP_CENTRL to access elements such as Search Term 1 (BU_SORT1).

To access an entity type 4 that has a cardinality 1:N (for example BP_COMPNY) you have to define the derivation DERIVE_BP_COMPNY to access elements such as Reconciliation Account (REF_BPCMP).

Note Note

The values mentioned above refer to the supplier data model. For the corresponding values referring to the customer data model see the table below:

Supplier data model	Customer data model
BP_COMPNY	BP_CUS_CC
DERIVE_BP_COMPNY	DERIVE_BP_CUS_CC
REF_BPCMP	CUS_AKONT

End of the note.

Note Note

For more information about derivation, see Definition of Validations and Derivations.

End of the note.

Activities

To access the entity BP_COMPNY you must define the DERIVE_ BP_COMPNY function as described below.

In the Customizing for Master Data Governance, Central Governance, run the activity Define Validation and Derivation Rules under Master Data Governance, Central Governance General Settings Data Quality and Search Validations and Enrichments Define Validation and Derivation Rules .
Enter the Data model BP and choose Continue.
On the Business Rule Framework plus screen, select the Catalog tab, expand the Trigger Function node, and select Derivation. In the context menu choose Create Object Node Create Function .
In the Create Function dialog box, enter the data shown below, choose Create and Navigate to Object, and confirm the dialog box:
- Name: DERIVE_BP_COMPNY
  
  Note
  The naming convention for the function is DERIVE_<name of the entity>.
  
  End of the note.
- Short Text: DERIVE_BP_COMPNY
- Text: DERIVE_BP_COMPNY
- Application: FMDM_MODEL_BP
On the Signature tab, choose Add Existing Data Object.
In the Object Query dialog box, enter the search criteria shown below and choose Search.
- Application: FMDM_MODEL_BP
- Data Object Type: Any
- Name: BP_COMPNY
In the results list, mark BP_COMPNY and choose OK.
On the Assigned Rulesets tab, choose Create Ruleset.
In the Create Ruleset dialog box, enter the data shown below, choose Create and Navigate to Object, and confirm the dialog box:
- Name: BP_COMPNY_RULESET
- Short Text: BP_COMPNY_RULESET
- Text: BP_COMPNY_RULESET
- Application: FMDM_MODEL_BP
In the Rules group box, choose Insert Rule Create .
In the Rule dialog box, choose Assign Condition Use Value Range From Select Context Parameter .
In the Context Query dialog box, expand the BP_COMPNY node, mark CoCode, and choose OK.
Select is equal to and enter 1000 using the input help.

Note
Entering the value without the input help may cause inconsistencies due to the wrong data format.

End of the note.
Select Then Add Assign Value to Context Context More .
In the Context Query dialog box, expand the BP_COMPNY node, mark Recon.acct, and choose OK.
In the Rule: dialog box, enter 31000 using the input help into the Change value of BP_COMPNY to field and choose OK.

Note
Entering the value without the input help may cause inconsistencies due to the wrong data format.

End of the note.
Select Save, choose Activate, and on the Confirm Activation dialog box choose Activate.