SAP Knowledge Base Article - Public

2573555 - Data Types for Date/Time Fields - BW Integration with C4C


You have integrated C4C with BW (Business Warehouse). The ODP request retrieves the wrong data type for date time fields. The type in ODP is CHAR, even though it should be DEC(21,7) according to the C4C data source documentation.


SAP Hybris Cloud for Customer

Reproducing the Issue

As an example, let us take the data source CODCQTHB and the field Created On (Date Time)

  1. Go to the work center Business Analytics, view Design Data Sources.
  2. Search for CODCQTHB.
  3. Open the documentation by clicking on the magnifying glass.
  4. Search for Created On (Date Time)

You can see that the field DOC_CREATED_DTM has the type Date/Time Data Type DEC(21,7).

In your BW system however, this field will have the type CHAR.


DEC is a data type specific to key figures, however currently, date/time fields cannot be supported as key figures. This is why these fields are taken as characteristics with the data type being CHAR.


If you intend to pass restrictions on a date/time range from BW side, this will still work and provide the correct results.

Alternatively, you can use Date fields to pass restrictions if your use case is not date/time specific.


KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions