SAP Knowledge Base Article - Public

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

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

  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.

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

     

    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.

      

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

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

Attachments

Image1.png
image 2.png
image3.1.png
image3.2.png
image4.png
image5.png
image6.png