on 02-26-2018 11:41 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.