Skip to Content
0
Former Member
Nov 03, 2005 at 07:22 PM

How to delete wrong values from the table

68 Views

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