Skip to Content
0
Jul 18, 2014 at 05:50 AM

ADD DATA TO DSO FOR EVERY 0CALDAY

20 Views

Hi Experts,

I have 0EC_PCA_3 datasource and a DSO with key field(0calday, 0plant, 0material). In PSA we have data for some days but not every day. Our customer wants to see an amount for every day for each (material, plant). If no data for a day, we must use amount for the day after. Where do we write the code in transformation, start routine or end routine. For the delta record, we also change the target as follows. Is it possible?

SOURCE (PSA)0plant 0material 0calday zamount 1001 1X1 01.01.2014 10 1001 1X1 04.01.2014 20 TARGET (DSO) 0plant 0material 0calday zamount zactiv 1001 1X1 01.01.2014 10 1 1001 1X1 02.01.2014 20 0 1001 1X1 03.01.2014 20 0 1001 1X1 04.01.2014 20 1 DELTA 0plant 0material 0calday zamount 1001 1X1 02.01.2014 30 1001 1X1 04.01.2014 30 TARGET(DSO) 0plant 0material 0calday zamount zactiv 1001 1X1 01.01.2014 10 1 1001 1X1 02.01.2014 30 1 1001 1X1 03.01.2014 20 0 1001 1X1 04.01.2014 50 1