Basic of AMDP script and implement a SAP BW transformation logic using AMDP script

[pallab_haldar]

Today, I am going to discuss the basic of AMDP script and implement a SAP BW transformation logic using AMDP script.

First question is what is AMDP script and why we will use AMDP instead of normal AMAP script for different types of routine like Start End and expert routine.

AMDP is ABAP managed Database Procedure which used to run in HANA runtime. All the database logic push to the database level for execution. In the other hand the ABAP procedure execute the logic in the ABAP layer inside ABAP runtime environment .

Business transformation logic implemented in AMDP is faster than ABAP transformation because it is executed in database layer. But always it is not useful.

If we use ODP extractor for Data extraction in BW then ABAP transformation is useful as  ODP extraction and  transformation both done in ABAP environment and runtime. it is not a good idea to use AMDP script until the logic is too complex.When the existing ABAP rule Type is not sufficient, then only you can define SQL script.

When you create a AMDP script transformation a SAPHANApocedure created that is implemented by a method in AMDP Class.This generated class generated by BW and only edited in the ABAP development tool.

Lets discuss about few AMDP routines -

1. Create a transformation and create a end routine using AMDP script -

 

2. We can see the AMDP class  method. Please check three variables for the  script development -

inTab -Internal table contain incoming data.
outTab -Internal table contain output data.
errorTab -Table containing erroneous records.

 

3. Edit the code and activate. Now below given a sample of ABAP code and equivalent AMDP code.

This can be customized as per requirement basis -

ABAP Code -

*********** Start Transformation**********************************



       SELECT MATERIAL PLANT NET_PRICE GROSS_PRICE /BIC/VALID_DATE

        FROM

      /BIC/APLB12

        INTO CORRESPONDING FIELDS OF TABLE LT_PLB FOR ALL ENTRIES IN

        RESULT_PACKAGE

        WHERE MATERIAL = RESULT_PACKAGE-/BIC/ZMATERIAL

              AND PLANT = RESULT_PACKAGE-PLANT.



LOOP at RESULT_PACKAGE ASSIGNING <result_fields>.





********* Start Polulate Data in Result ADSO************************



        READ TABLE LT_PLB INTO WA_PLB

              WITH KEY MATERIAL = <result_fields>-/BIC/ZMATERIAL

                       PLANT = <result_fields>-PLANT.



		  IF sy-subrc = 0.

			 <result_fields>-/BIC/TOTAL PRICE = WA_PLB-GROSS_PRICE + WA_PLB-NET_PRICE.

			 

		  ENDIF.	  



********* End Polulate Data in Result ADSO***************************

 

Equivalent AMDP code is -

********* Start AMDP Script *****************************************



OUTTAB = SELECT 

			"/BIC/POORDER",

			"/BIC/ORDER_LINE",

			"/BIC/SCHEDULE_LINE",

			"/BIC/CREATION_DATE",

			"/BIC/ZMATERIAL",

			"/BIC/0PLANT",

			"/BIC/TOTAL_PRICE",

			CURRENCY,

			SQL_PROCEDURE_SOURCE_RECORD

			FROM 

			(SELECT 

				P1."/BIC/POORDER",

				P1."/BIC/ORDER_LINE",

			    P1."/BIC/SCHEDULE_LINE",

			    P1."/BIC/CREATION_DATE",

			    P1."/BIC/ZMATERIAL",

				P1."/BIC/0PLANT",

			    (P2.GROSS_PRICE + P2.NET_PRICE) AS "/BIC/TOTAL_PRICE",

				CURRENCY,

				P1.SQL_PROCEDURE_SOURCE_RECORD

				FROM : TEMP_TABLE P1 LEFT OUTER JOIN "/BIC/APLB12" P2 ON P1."/BIC/ZMATERIAL" = P2.MATERIAL 

                       AND P1."/BIC/0PLANT" = P2.PLANT);

					   

********** END OF AMDP SCRIPT ***************************************

 

4. Activate the AMDP script method and then the transformation .

5. Go to the Target data preview . You can see the calculated key figure /BIC/TOTAL_PRICE calculated using AMDP script.