Skip to Content
0
Former Member
Feb 26, 2007 at 04:59 PM

Code to find if system date is within 01 /2007 to 12/2007 and 01/08 to12/08

14 Views

Hi , I have a simple requirement at BMW Orders to Cash Area to split up the data loads for "Orders Cube" on yearly basis. like "Orders Cube 2007" and "Orders Cube 2008" and previous year Cube "Orders Cube 2006 . I want to know the abap Code that i write in abap process type or if you can let me know how can i check using IF else functionality in Process chain.

I want to do the following

Check if LOad Date (SYSDATE) lies between TOO9B - BDATJ (20007) & TOO9B - POPER (01 TO 12)

Then use DTP to load the the "2007 order cube"

Else

Check if LOad Date (SYSDATE) lies between TOO9B - BDATJ (20008) & TOO9B - POPER (01 TO 12)

Then use DTP to load the the "2008 order cube"

Please help me with logic or any standard functionaility that can resolve the above

Then use DTP to load the the "2007 order cube"

I just come up with the below code but if you can correct it to put in the format of process chain abap code it will be helpful.

Thanks

soniya

RANGES: IT_TCODE FOR TOO9B - BDATJ

IT_TCODE-SIGN = 'I'

IT_TCODE-OPTION = 'EQ'

IT_TCODE-LOW = ''2007"

APPEND IT_TCODE.

IT_TCODE-SIGN = 'I'

IT_TCODE-OPTION = 'EQ'

IT_TCODE-LOW = '01'

APPEND IT_TCODE.

IT_TCODE-SIGN = 'I'

IT_TCODE-OPTION = 'EQ'

IT_TCODE-LOW = '12

APPEND IT_TCODE.