3306845 - Unexpected DateTime Format in the Response of Web Service QueryIdentifiedStocksIn

Query identified stock details through standard web service QueryIdentifiedStocksIn. In the response, ProductionDateTime and ExpirationDateTime are displayed in format UTC. However, the date and time are displayed in UTC+8 from UI.

SAP Business ByDesign

1. Query identified stock ABC (ABC represents identified stock ID) details through standard web service QueryIdentifiedStocksIn. In the response, ProductionDateTime is 2021-03-15T16:00:00Z, ExpirationDateTime is 2026-02-28T16:00:00Z, which are in UTC format.
2. Logon system, go to work center Warehousing and Logistics Master Data.
3. Access view Identified Stock.
4. Find identified stock ABC, click Edit, you find Production Date is 2021-03-16 12:00AM UTC+8, Expiration Date is 2026-03-01 12:00AM UTC+8.

The date and time in the backend is always stored in UTC. What you see on the front UI is the date and time converted to the user’s time zone. If you change the user’s time zone setting from UI, you will see the value of the date and time also changed.

The standard web service QueryIdentifiedStocksIn will retrieve the data stored at backend, which is in UTC. The web service will not (and isn’t expected) to do the time zone conversion.

This is system standard behavior.

QueryIdentifiedStocksIn, Web Service, TimeZone, UTC , KBA , AP-PRD-IS , Identified Stock , Problem