topic How to delete wrong values from the table in Application Development and Automation Discussions

How to delete wrong values from the table

Former Member — Thu, 03 Nov 2005 19:22:46 GMT

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

Re: How to delete wrong values from the table

RichHeilman — Thu, 03 Nov 2005 19:33:50 GMT

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

Re: How to delete wrong values from the table

RichHeilman — Thu, 03 Nov 2005 20:36:55 GMT

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

Regards,

RIch Heilman

Re: How to delete wrong values from the table

Former Member — Thu, 03 Nov 2005 20:40:18 GMT

Rich,

just finished my testing. Works fine. Thanks

Re: How to delete wrong values from the table

RichHeilman — Thu, 03 Nov 2005 20:45:07 GMT

Cool, glad to help.

Regard,

Rich Heilman