Skip to Content
avatar image
Former Member

Based on movement type(101 & 601) i have to get Last GI DATE and LAST GR DATE from lookup DSO.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers