Skip to Content
0
Former Member
Sep 07, 2007 at 06:58 AM

Update DSO from Multiple DSO's

52 Views

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.