Looking up a table while doing data load is a common scenario in SAP BW.
Here the look up table can be active table of some other DSO.
You can note a point here that cube cannot be used for look up. This is because, a cube has a fact table which is based on star schema. Hence the primary keys in a fact table will be dimension ids instead of the primary key values.
Now coming to our scenario, suppose data is loaded from DSO1 to CUBE1. Continue reading “How to write ABAP routine to look up a DSO Active table”