handle null value in char infoobject -data type DATE(ora-01722 invalid num)

[Former Member]

Hi,

We have a DSO with a info object in the Data fields. The char info object has the data type DATE and most often it has the null value. but some times it has data in it.

When ever we were trying to run a report on the DSO it throws a error as ORA- 01722 INVALID NUMBER.

we tried editing PSA data and placing 00000000 for null values - and had a message invalid date.

suggestions pls

Regards.

[Former Member]

Hello,

Please check the note given below

https://service.sap.com/sap/support/notes/1327167.

If null value is the problem, change the query setting for not to show the null values. Just add a filter in ZDAT to exclude "NULL"

Thanks

Nidhi