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

[Former Member]

Hi,

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?

Thanks

[aluri_hemanth]

Hello Kilgour - Can I ask you how did you handled this ?. Did you taken care with Scripting or SAP has provided you any FM to be used in AMDP ?

[FCI · Accepted solution]

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).

Regards,

Frederic