Symptom
There is a String field with date value replicated from a source system with values "0000-00-00" and this field is converted to Date datatype using TO_DATE function and it shows up as NULL value in Data Preview. Further down in the view when you try to check for IS NULL the expression does not produce the desired result.
Read more...
Environment
SAP Datasphere
Product
SAP Datasphere 1.0
Keywords
NULL, datetime, date, IS NULL, String, datasphere , KBA , DS-DI-VIW , View Persistency and Runtime , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview