Hi,
We are new to BI7.0 with very limited knowledge to ABAp coding.
We have the data in DSO1 containing - 0Bill_Num,0plant,0material,0batch, 0NETVAL_INV, 0cost (along with other IO's).
In DSO2 we have 0plant,0material,0batch,ZLOAD (which is CURR - KF).
We also have a DSO3 which have all fields of above - 0Bill_Num,0plant,0material,0batch, 0NETVAL_INV, 0cost,Zload.
Our requirement is that we want to populate the key figure Zload along with other IO's into the consolidated DSO3 matching 0plant,0material,0batch from the DSO2 with the corresponding IO's in DSO1. Its better explained in the example below
Eg.
Records in DSO1
0Bill_Num,0plant,0material,0batch, 0NETVAL_INV, 0cost
1,3000,100001,xpt1,3000,2000
2,3010,100002,xpt1,3200,2100
Records in DSO2
0plant,0material,0batch,ZLOAD
3000,100001,xpt1,300
3010,100002,xpt1,330
Records in DSO3 to reflect
0Bill_Num,0plant,0material,0batch, 0NETVAL_INV, 0cost,Zload
1,3000,100001,xpt1,3000,2000,300
2,3010,100002,xpt1,3200,2100,330
We understand that we require to write a routine to get this in place. We require help on the coding the routine.
We tried APD, but this does not suite requirements as there are problems updating delta.
Please Help.