SAP Knowledge Base Article - Preview

3528603 - View Showing NULL Values in a Calculated Column Does not satisfy the IS NULL Expression

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.