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” button 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:

SELECT SINGLE CNTRY_COMP
   FROM BP001
   INTO WYQ14S
   WHERE PARTNER = KONTRH.

On “Difinition” tab we can manipulate Field attributes by pressing Spyglass button

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)