Query transform lookup function on sap ecc tables

[Former Member]

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?

[former_member187605 · Accepted solution]

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.