Show TOC

Example documentationDerivation of the Reconciliation Account After Selecting a Specific Company Code

 

This document describes 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_CUS_CC) you have to define the derivation DERIVE_BP_CUS_CC to access elements such as Reconciliation Account (CUS_AKONT).

Note Note

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

End of the note.

Activities

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

  1. In the Customizing for Master Data Governance, run the activity Define Validation and Derivation Rules under Start of the navigation path Master Data Governance Next navigation step General Settings Next navigation step Data Quality and Search Next navigation step Validations and Enrichments Next navigation step Define Validation and Derivation Rules End of the navigation path.

  2. Enter the Data model BP and choose Continue.

  3. On the Business Rule Framework plus screen, select the Catalog tab, expand the Trigger Function node, and select Derivation. In the context menu choose Start of the navigation path Create Object Node Next navigation step Create Function End of the navigation path.

  4. 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_CUS_CC

      Note Note

      The naming convention for the function is DERIVE_<name of the entity>.

      End of the note.

    • Short Text: DERIVE_BP_CUS_CC

    • Text: DERIVE_BP_CUS_CC

    • Application: FMDM_MODEL_BP

  5. On the Signature tab, choose Add Existing Data Object.

  6. 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_CUS_CC

  7. In the results list, mark BP_CUS_CC and choose OK.

  8. On the Assigned Rulesets tab, choose Create Ruleset.

  9. In the Create Ruleset dialog box, enter the data shown below, choose Create and Navigate to Object, and confirm the dialog box:

    • Name: BP_CUS_CC_RULESET

    • Short Text: BP_CUS_CC_RULESET

    • Text: BP_CUS_CC_RULESET

    • Application: FMDM_MODEL_BP

  10. In the Rules group box, choose Start of the navigation path Insert Rule Next navigation step Create End of the navigation path.

  11. In the Rule dialog box, choose Start of the navigation path Assign Condition Next navigation step Use Value Range From Next navigation step Select Context Parameter End of the navigation path.

  12. In the Context Query dialog box, expand the BP_CUS_CC node, mark CoCode, and choose OK.

  13. Select is equal to and enter 1000 using the input help.

    Note Note

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

    End of the note.

  14. Select Start of the navigation path Then Next navigation step Add Next navigation step Assign Value to Context Next navigation step Context Next navigation step More End of the navigation path.

  15. In the Context Query dialog box, expand the BP_CUS_CC node, mark Recon.acct, and choose OK.

  16. In the Rule: dialog box, enter 31000 using the input help into the Change value of BP_CUS_CC to field and choose OK.

    Note Note

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

    End of the note.

  17. Select Save, choose Activate, and on the Confirm Activation dialog box choose Activate.