Skip to Content
0

Query transform lookup function on sap ecc tables

Feb 26 at 11:41 AM

32

avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Feb 26 at 07:35 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded