Symptom
System shows dates in UTC instead of in CSTNO (i.e. UTC-6) for Mexico in Sales Volume – Flexible Analysis app.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Access Sales Volume – Flexible Analysis app.
- Fill filter related document and press Go button.
- In the Navigation Panel chose Billing Date and Created on field to show in row.
- Compare values showed in Sales Volume – Flexible Analysis app.
Cause
The current app shows the time in UTC time zone instead of local time.
Resolution
- Use in-app extensibility to apply a workaround that will allow to reflect the local time.
- The workaround requires implementation effort, and it is the customers responsibility to test and check for potential impacts in their system according to their business requirements.
- The approach taken here is to create a custom CDS view and Custom Analytical Queries using key user extensibility and to show it based on Sales Volume – Flexible Analysis according to Language and Region settings.
- The Custom Analytical Queries using CDS I_BillingDocumentItemCube
- Run app Custom CDS view and create a new Analytical Cube
- In the tab Elements select fields in CDS I_BillingDocumentItemCube
- Create a calculation element and insert example code below.
TSTMP_TO_DATS(cast( I_BillingDocumentItemCube._BillingDocument.LastChangeDateTime as ABAP.DEC( 15, 0 ) ),abap_user_timezone($session.user,$session.client,'NULL'),$session.client,'NULL') - Run app Custom Analytical Queries and create a new using custom CDS view created previously.
- Select fields and configurations necessary.
Final UI - Run app Custom CDS view and create a new Analytical Cube
- When you execute a custom analytical queries you can select user date field to show date according to user settings
We recommend use the “Manage KPI and Reports” app to create an analytical report which would consume the analytical query built. This way you will get a report similar to the Sales Volume report.
This workaround was implemented to a customer only doing business in and out of Mexico without any other country that requires Sales Volume – Flexible Analysis in the landscape.
See Also
Keywords
Sales Volume – Flexible Analysis, Fecha de facturación, fecha creacion, fecha, Mexico, date, time, UTC, time zone. , KBA , SD-FIO-HBA-2CL , Analytical Apps (Public Cloud) , Problem
Product
Attachments
Image1.png |
image 2.png |
image3.1.png |
image3.2.png |
image4.png |
image5.png |
image6.png |