SAP Knowledge Base Article - Preview

3554032 - datatype TIMESTAMP field with NULL value in the HANA database table are converted to 000101010000000000000

Symptom

There is a datasource which extracts data from a HANA database table, source system type is HANA_LOCAL, after extracted data to BW/4HANA 2023, the datatype TIMESTAMP field with NULL value in the HANA database table are converted to 000101010000000000000 in the corresponding BW/4HANA 2023 datasource field.


Read more...

Environment

  • SAP BW/4HANA 2023 and later

Product

SAP BW/4HANA 2023

Keywords

TO_NVARCHAR( COALESCE, TO_TIMESTAMP, SAP HANA Object DDL Definition, remote access table, initial value, SAP HANA Local Database Schema, formula , KBA , BW4-DM-SRC-HANA , HANA Source System , 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.