Hi Experts
we have a data flow coming from 2 data sources...DS1 is 2lis_11_v_itm... & DS2 is 2lis_11_vakon
My data flow is like this:
DS1 -> IS->UR- > DSO1 -> TRANSFORMATION1 -> DSO2 -> TRANSFORMATION2 -> CUBE1
DS2->IS->UR->CUBE1. (we have a start routine in this UR to filter by cond type ZZ1)
now my requirement is to bring a field (created by)in to the cube from this two data sources for each sales order. In my DS2 I have ERDAT field available and mapped with 0CREATEDBY.But in my DS1, I dont have ERDAT field ...so can any one tell me how to get this value from DS2...DS2 has all the sales orders and DS1 has open orders only...so I think by writing a start routine in Transformation2 I can get this value...my PSA table name is /bic/b00013000...
Please send me the start routine code to get the ERDAT value in to cube /any other way of doing it.
Regards