Skip to Content
avatar image
ADNAN ZAFAR

Query transform lookup function on sap ecc tables

Feb 26, 2018 at 11:41 AM | 43 Views

hi guys

I want to do a lookup of a value in query tranform from table 1 to table 2 but both tables r in SAP ECC. Now when i open the lookup function wizard the first thing it asks is lookup table and it is not allowing me to pick the datastore for SAP ECC. is it not possible to do lookup on 2 tables in the same datastore?

SAP Data Services
lookup function
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Dirk Venken
    Feb 26, 2018 at 07:35 PM

    You can only perform lookup from database tables, not from application tables.

    You'll have to stage your ECC lookup table into a relational database.

    Or use a left outer join in an ABAP data flow.

    Add comment
    10|10000 characters needed characters exceeded