SAP Knowledge Base Article - Preview

3389579 - Unexpected data type for time characteristics in External SAP HANA views and XSA calculation views


DATS (and TIMS) datatypes of time characteristics appear as VARCHAR/NVARCHAR in External SAP HANA views and in XSA CVs. The text column for Date is displayed in the format DD-Mon-YYYY (e.g. the text for the date 20180313 will be displayed as 13-Mar-2018).

This is unexpected and require a way to alter this behaviour.



  • SAP NetWeaver 7.5x
  • SAP BW4/HANA 1.0
  • SAP BW4/HANA 2.0
  • SAP BW4/HANA 2021
  • SAP BW4/HANA 2023


SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP NetWeaver 7.5


"DATS" "TIMS" "VARCHAR" "NVARCHAR" "External SAP HANA view" "XSA" , KBA , BW4-ME-HMOD , HANA Model Generation , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , BW-WHM-MTD-HMOD , HANA Model Generation in BW , 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.