Skip to Content

Read Master Data + AMDP Routine

Hi,

i would like to read master data (0CUST_SALES) from Attr.. My model look like below.

can anyone write me AMDP-Expert Routine for this scenario?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 08 at 09:03 AM

    Hi Sacha,

    Please find a sample below. The order of the fields should be on the exact level of your data.
    You may edit the join conditions.

    outTab = select
    intab."CUSTOMER",
    intab."ZMERKMAL1",
    ...
    custsales."CUST_SALES",
    "RECORD"
    FROM :inTab as intab
    JOIN "/BI0/PCUST_SALES" as custsales
    ON intab."CUSTOMER" = custsales."CUSTOMER";
    
    
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Erdem,

      Thank you very much. Can i ask you one more scenario about my issue? i would like to merge 2 different aDSOs to 1 aDSO target with AMDP-Routine. If i am used two transformation to 1 target , i got report-1. But i wanna merge all of them to one like Report-2. it is important for us also Currency. Thanks alot for your help!

      Best Regards Sascha

  • Jan 19 at 11:40 AM

    Hi Sacha,

    Let's go this way: Please check the following samples and activate your HANA expert routine.
    Edit your outtab mapping according to your lookup. If it doesn't work, please paste here the code and let's check what's wrong about it.

    Instead of creating a code for you from scratch, this will be much more efficient.

    https://blogs.sap.com/2015/05/03/create-sql-script-based-transformations-in-bw-74-sp9-on-hana/

    https://blogs.sap.com/2016/05/24/hana-based-bw-transformation/

    https://archive.sap.com/discussions/thread/3624514

    Add comment
    10|10000 characters needed characters exceeded