Skip to Content
Sep 07, 2018 at 12:54 AM

Lookup from DSO to Cube not working


Hi BW experts,

I need urgent help and will appreciate your answer.

I created a data model in SAP BW and need to bring in Version ID. The version ID is not available in the data source being used, but we have a separate DSO in which I have that version ID field therefore I have added a field called version Id in my cube and created a field routine in the transformation to look it up so it can look for version ID from that DSO.

The fields in the DSO (key fields) are in the screenshot below.

I have written the following logic in the field routine

but unfortunately this logic is not populating the version ID from DSO into my infocube as the field "version id" is coming blank even after reloading the data. Note that version ID is being populating in the DSO perfectly fine but not coming to cube due to the wrong syntax.

Can anyone tell me what is wrong with the ABAP logic/syntax and will appreciate if you advise the correct one.



capture.jpg (26.9 kB)
capture.jpg (27.9 kB)