Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
pallab_haldar
Active Participant
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.

 

 

 

 
Labels in this area