I have to load data in full mode with a filter on period on DTP between DSO and Infocube.
I am comfortable with it , but there is a type of data that I have to manage to avoid me big changes on my flow.
To simplify, let’s say data is coming from DSO as following:
And In stvarv, I will create 2 variables as following:
First Date of current period (FDCP): 01/03/2013
Last Date of current period (LDCP): 31/03/2013
So what I have to do, is to control that approvdate is between FDCP and LDCP, and also superior to workdate.
If the 3 conditions are respected, I have to set the value of Approvaldate in Wordate, so my record will be:
So I tought about creating a Start routine in my cube transfo level and do something as following:
LOOP AT SOURCE PACKAGE into structure
If APROVDAT between FDCP and LDCP
And WORKDATE LT APPROVDAT
WORKDAT = APPROVDAT
What do you think about it? What could you advice me?