on 01-07-2018 12:28 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";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sascha,
You don't need to create a "read-from" scenario for this case. You've same key field from both sources and non-key fields are not overlapping. Simply create two transformations from each of them to target ZR1ADSO. Once you load the data from these sources your data will be "merged" in the target.
Regards,
Erdem
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
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.