Skip to Content

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)

/wp-content/uploads/2014/10/0_558578.jpg

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

/wp-content/uploads/2014/10/1_558531.jpg

Select “Table lookup” step

/wp-content/uploads/2014/10/2_558532.jpg

Select table BP001

/wp-content/uploads/2014/10/3_558581.jpg

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 /wp-content/uploads/2014/10/4_558582.jpg

/wp-content/uploads/2014/10/5_558583.jpg

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

/wp-content/uploads/2014/10/6_558584.jpg

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)

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply