Load Cube from 3 DSO , with lookup routine

[former_member612414]

Hi All ,

I loaded 3 dso with 3 datasources 2LIS_02_ITM, 2LIS_06_INV & FI_AP_4 . Then I have to load them into a cube to be able to extract my KPIs and prepare my report.
For this, I have to do a transformation from the largest DSO (02_ITM in my case) and in transformations I have to lookup through ABAP routines to fill in the fields that are necessary from invoice verification and FIAP.
Can you help me? I don't know much about ABAP.
Where to start and how?
Thank you…

[cornelia_lezoch]

please tag it as BW Data Warehousing, but not as planning, since it has nothing to do with planning

[matt]

As I've explained quite recently, the only proper solution is to get a programmer who knows how to do this on board. The other solution is to do some abap training.

Bad programmers can (and I've seen it happen) screw up BW systems. Get someone who knows what they are doing.

[raymond_giuseppi]

There are too many options available in Abap for your transformation rules to get a small/clear/complete answer.

Did you already try to

• Install and analyze some standard rules and routines provided by SAP in the Business Content (RSA5) - or already implemented by colleagues (RSA1)
• Use some other rule types ('Read Master Data' or 'Formula' for example)