Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Transfer Routine !

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

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

0 Kudos

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

Thanks

Ravi.

0 Kudos

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

Jonathan