2645496 - You See Different Values in The Cloud Application Studio Query Results for Date/Time Than In The UI

You are querying a business object in the Cloud Application Studio and observe the values for Start-/End Date/-Time is different than what you see in the document in the UI.

SAP Cloud Application Studio

For this example, you notice a different date shown for a Contract Item Start Date. This field is located on the Items tab inside a Contract.

1. Log into the SDK.
2. Open a solution.
3. Click the View button on the Toolbar and display the Repository Explorer.
4. Search for the Business Object XYZ (XYZ represents BO name). Example: CustomerContract.
5. Right-Click on the QueryByElements query and click execute.
6. Enter the Document ID 123 (123 represents a sample document ID).
7. Highlight the row and click the option to navigate.
8. Navigate to the node where the date value is stored. Example: Item - ItemPeriodTerms node for Contract.
9. Check the Date fields.
10. Open the UI and navigate to the work centre and view where the issue is observed.
11. Navigate to the document 123 (123 represents the document ID).
12. Go to the tab where the issue is observed. Example: Items tab.
13. The Contract Item Start Date is different than what was returned in the SDK query.

This is standard behaviour. Documents that have been created in a different time zone will show date/time in the UI of that time zone. However, querying a BO will return the data that is stored in the backend database. This is stored in UTC.

This is expected system behaviour.

In the UI, the date/ time will be shown in the time zone of the logged in user.

In the SDK, the date/ time will be shown in the time zone of the user the object was created in.

BO, Query, Time, Zone, SDK, Cloud , KBA , query , bo , node , amount , repository explorer , AP-RC-BDS-QRY , ByDesign Studio BO Queries , How To