Transfer Routine !

[Former Member]

Hi Experts,

I have a created on date field coming from R/3 to BW. some times this field comes Null value. when ever this null value comes i usually edit future date in PSA and push it to cube as a full load. Now my requirement is i want to handle this for ever

in transfer routine.

Check the created on date for each record, if NULL assign it to 12/31/9999.

need help in ABAP coding.

Thanks in advance.

[Former Member]

Is it truly "null" or just not set?.... the usual way to test for an empty date would be:

if l_date is initial.   "not set
  l_date = '99991231'.  "set default in CCYYMMDD format
endif.

Jonathan

[Former Member]

Its not set. I also want to check the created on date for each record.

Thanks

Ravi.

[Former Member]

Then the code above should suffice - just substitute your table / field for "l_date " in the example.

Jonathan