3522131 - Requirement to create Sales Volume Flexible Analysis in CSTNO (i.e. UTC-6) for Mexico.

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.

SAP S/4HANA Cloud Public Edition

1. Access Sales Volume – Flexible Analysis app.
2. Fill filter related document and press Go button.
3. In the Navigation Panel chose Billing Date and Created on field to show in row.
4. Compare values showed in Sales Volume – Flexible Analysis app.

The current app shows the time in UTC time zone instead of local time.

• 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

   

  1. Run app Custom CDS view and create a new Analytical Cube
     
  2. In the tab Elements select fields in CDS I_BillingDocumentItemCube
     
  3. 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')
     
     
     
  4. Run app Custom Analytical Queries and create a new using custom CDS view created previously.
     
  5. Select fields and configurations necessary.
     
  
  Final UI
• 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.

    

• SAP Help Extending the eDocument Cockpit App with Custom Fields
• SAP KBA 3514300 - Time zone Explanation - SAP S/4HANA Cloud Public Edition
• SAP KBA 3523875 - Need to reflect Local Time in CSTNO (i.e. UTC-6) for Mexico in Manage Outbound Delivery – VL06O app

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

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions