Skip to Content
Author's profile photo Grigoriy Babitskiy

Derivation type: Table lookup

Derivation type “Table lookup” is working in the following way: A selection from Defined table is made with source field as condition. If select is successful then value of defined table field is assigned to target field.

Scenario: in Analyzer we use some characteristics. One of them is WYQ14S “Country”. We need it to set as “Country of Organization’s Registered Office” of Business partner while Automatic integration TRM and Analyzers.

IMG -> Financial Supply Chain Management -> Treasury and Risk Management -> Basic Analyzer Settings -> Automatic Integration of Financial Objects in Transaction Master Data -> Money Market -> Define Derivation Strategy (tr. AFO_FOI_DER_MONEY)


In general screen of derivation press “Create step” /wp-content/uploads/2014/10/9_558580.jpgbutton or F5.


Select “Table lookup” step


Select table BP001


From table BP001 system makes a select where BP001-PARTNER equal KONTRH “Business partner number”. If data is selected, then field WYQ14S reiceive value from BP001-CNTRY_COMP from BP001 select.

ABAP select looks like this:

   FROM BP001

On “Difinition” tab we can manipulate Field attributes by pressing Spyglass button /wp-content/uploads/2014/10/4_558582.jpg


Here we can set whether Initianl value is allowed and what part of field is used.


Here we can manipulate of overwritten parameters and field details.

The rest is the same – if we need we define conditions, other attributes.

Save derivation step.

Test is:Derivation: Test your derivation steps.

For other Derivation topics reffer to TRM Derivation (index)

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.