SAP Knowledge Base Article - Public

3034922 - Customer Contract Volume Report Shows Contract Start/End in Date+Time Format Instead of Just Date

Symptom

In your contract, you have maintained Contract Start and Contract End Date. For example, Contract Start Date=2020-11-03 and Contract End Date=2021-11-02.

In the Customer Contract Volume, the Contract Start shows 2020-11-02T16:00:00Z and Contract End shows 2021-11-02T16:00:00Z.

You want to know why the report shows different time format of the Contract Start and Contract End.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports work center view
  3. Search for the 'Customer Contract Volume' report 
  4. Open and run it
  5. Go to View > Add Fields to Row
  6. Add 'Contract Start' and 'Contract End' fields, 
  7. You can see some values (e.g. 2020-11-02T16:00:00Z)

Cause

In the Contract document, it shows the Contract Start Date and Contract End Date (in date format). However, the values are saved in date + time format in the backend. In the Customer Contract Volume report, it uses the date source CRMCCOIB, where the fields are determineding from backend data directly.

Resolution

This is currently the design in the standard data source CRMCCOIB, to show the complete value of contract start and contract end.

Keywords

TIME_POINT_PERIOD-START_TIME_POINT-DATE_TIME; TIME_POINT_PERIOD-END_TIME_POINT-DATE_TIME;CRMCCOIB; Time Format , KBA , AP-CCP-CC-ANA , Analytics , AP-CCP-CC , Customer Contract , Problem

Product

SAP Business ByDesign all versions