04-23-2018 11:12 AM
Hello Experts,
If Movement type is 601 , i should consider Last GI date/ If movement type is 101, I should consider Last GR Date from lookup DSO.
DSO 1: Material, Plant, Batch, SLED.
DSO 2: ( Look Up DSO): Material, Plant, Batch ,Posting Date(GI Date/GR date), Movement Type (101 - GR date, 601 - GI Date).
DSO 1 ---->DSO 3: I have to calculate aging -
Difference Between Current Date – GI Date. (IF (GI is available, consider last GI Date or else consider Last GR Date) .
Here I have to calculate "Aging" by lookup into DSO 2 to get Last GI/GR date (Posting Date) through Material, Plant, Batch.
Logic:
If Movement type is 601 , i should consider Last GI date/ If movement type is 101, I should consider Last GR Date from lookup DSO.
Experts please send me a piece of code to achieve this in the transformation routines.