Hi Experts,
I'm sorry to put this question here.. but I need help from the ABAP experts in solving the issue which I have. So please help me in this regard.
I need help in writing a start routine from ODS1 to ODS2.
ODS1 is having the information from R/3 which which contains data like this.
Key Fields :
1] 0DOC_NUMBER - sales Document
2] ZPARVW1 - Partner Function info object
Data Fields:
1] 0Customer
2] 0Vendor
3] 0Employee
4] changedon
5] created on.
6] overall status of document
here ZPARVW1 will be having all partner functions ID which are coming from R/3. Like SP, BP, PY, PE, ZR.
these refers to Ship to party, Bill to Party, Payer, Sales employee, Forwarder..
in this partner functions SP,BP,PY refers to Customer
and PE refers to 0Employee
and ZR refers to 0Vendor.
here one sales document will be having multiple partner funtions at the same time.
In my lower level ODS I have the values as separate entries like
ODS1:
Doc_num: ZPARVW1: 0Customer: 0Vendor: 0Employee
546788 : SP: 567890
546788 ; BP:786899
546788 ; PY: 768980
546788 ; PE ; ; ; 467589
546788 ; ZR; ; 56789 respectively.
as for a particular document number I have multiple entries in the lower level ODS1
Now I have to write a code in the update rules of ODS2 like
for a particular Document number I need all the partner functions to be available as a single record. like
0Doc_Number : 0Ship_To; 0Billtoprty; 0Payer; 0sales employee; 0forwarder
546788 : 567890 ; 567890 ; 567890 ; 467589 ; 56789
in ODS2 I have partner funtions as Info objects replacing the partner functions ID's.
Please advice me in writing the code for the same.
Points will be awarded.
thanks
Vishnu
Bluesky
