topic Re: Transfer Routine ! in Application Development and Automation Discussions

Transfer Routine !

Former Member — Sun, 28 Oct 2007 03:27:00 GMT

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.

Re: Transfer Routine !

Former Member — Sun, 28 Oct 2007 08:30:58 GMT

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

Re: Transfer Routine !

Former Member — Sun, 28 Oct 2007 14:28:21 GMT

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

Thanks

Ravi.

Re: Transfer Routine !

Former Member — Sun, 28 Oct 2007 22:29:51 GMT

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

Jonathan