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

SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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.

Cause

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.

Resolution

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.

Keywords

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

Product

SAP Hybris Cloud for Customer all versions