How to delete wrong values from the table

[Former Member]

Hi,

I have a field of type SY-DATUM and I am loading data from an external system into BW. The field should be of the format YYYYMMDD (Ex: 20051025). But I have some corrupt data where the field is not in the specified format. Sometimes the date is in othe formats, for example 05/02/054, 20/04/04 and some other formats.

Well, When the field is not in the correct format, I would like to set the field to NULL. Any ideas appreciated.

Thanks

GOva

[Former Member]

Hi,

I have a field of type SY-DATUM and I am loading data from an external system into BW. The field should be of the format YYYYMMDD (Ex: 20051025). But I have some corrupt data where the field is not in the specified format. Sometimes the date is in othe formats, for example 05/02/054, 20/04/04 and some other formats.

Well, When the field is not in the correct format, I would like to set the field to NULL. Any ideas appreciated.

Thanks

GOva

[RichHeilman]

Sure, you can check the plausibility of the date.

If the data coming in is not of the correct format for SAP, then you set to initial..

Check out this sample program.

report zrich_0001 .


data: p_date type sy-datum value '65/1/2545'.


call function 'DATE_CHECK_PLAUSIBILITY'
     exporting
          date                      = p_date
     exceptions
          plausibility_check_failed = 1
          others                    = 2.

if sy-subrc = 1.
  write:/ 'This date is not a real date'.
else.
  write:/ 'Looks ok to me'.
endif.


p_Date = sy-datum.


call function 'DATE_CHECK_PLAUSIBILITY'
     exporting
          date                      = p_date
     exceptions
          plausibility_check_failed = 1
          others                    = 2.

if sy-subrc = 1.
  write:/ 'This date is not a real date'.
else.
  write:/ 'Looks ok to me'.
endif.

Regards,

RIch HEilman

[RichHeilman]

Please make sure to mark you post as solved if you question has been answered completely. THanks.

Regards,

RIch Heilman

[Former Member]

Rich,

just finished my testing. Works fine. Thanks

[RichHeilman]

Cool, glad to help.

Regard,

Rich Heilman