SAP Knowledge Base Article - Public

3613971 - How the time zone and date time elements are determined in OData service

Symptom

You find the exported time stamp from OData service is different from UI.

Environment

SAP Business ByDesign

Cause

System determines project time zone based on time zone in the basic settings of the user that creates the project, which can be maintained in UI with 'My Settings', Time zone.

How are the time stamps (e.g. PlannedStartDateTime) calculated?

When a user enters e.g. 01.03.2021 as start date (A1S layer), the system converts this into a time stamp (01/03/2021 00:00:00.0000000), and converts this from the project's time zone into UTC. If the project's time zone e.g. CET, this results in 28.02.2021 23:00:00.0000000 (AP layer).

Odata Service exports time stamps as they are, this means in UTC. This is different than the UI, which shows dates in project time zone.

Resolution

In order to interpret the result from Odata service to get the same result as on the UI one has to take both elements PlannedStartDateTime and PlannedStartDateTime TimeZoneCode into account.

Keywords

OData service, PlannedStartDateTime, Project, Time zone, UI , KBA , SRD-PRO-PMN , Project Management , Problem

Product

SAP Business ByDesign all versions