Skip to Content

Can any BW transformation ABAP routine be converted to AMDP SQLscript?

Jun 23, 2017 at 06:05 PM


avatar image


We're implementing BW 7.5 on HANA and I'm looking to convert business content classic DSOs into ADSOs and also recreate the inbound transformations to use HANA pushdown functions.

For simple routines I'm using the BW formula builder but for more complex I'm trying to use SQLscript in an AMDP. I've created some simple AMDP routines but the online help seems pretty limited to simple examples and my old school procedural ABAP knowledge struggles with the switch to the SQLscript world. Should I theoretically be able to recreate any ABAP routine in SQLscript?

My example requirement is the derivation of the partner objects in the transformation between DataSource 0CO_OM_CCA_9 and InfoSource 0CO_OM_CCA_9 where the partner is derived using function module CO001_BIW_PARTNER_DECODE. How would I convert this to SQLscript?


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

1 Answer

Best Answer
Frédéric Cincet Jun 27, 2017 at 04:02 PM

Yes. But, in your example, you will have to convert the standard MF into a SQL script (you can't call it from the SQL). And I'm not sure this is a good idea:

- It can be complex (as you said, ABAP logic and SQL logic are different and the translation is not so easy),

- you will have to maintain the script for the time being (whereas the standard MF is maintained by SAP).



10 |10000 characters needed characters left characters exceeded