Skip to Content
Product Information
Author's profile photo Vishnu Vardhan Tanguturu

Extended Statistics in ‘Data Migration Status’ app

The “Data Migration Status” app , is well received by customers and partners so far after it’s first release in 1805 CE. Since then, SAP released several useful features until 1905 Cloud Edition. To name a few:

  • Get an overview of your migration objects and projects in real time.
  • See running jobs at a glance and get notifications on completed jobs.
  • Mapping of source ID to SAP S/4HANA Target ID (Objects with internal numbers)
  • Navigate to the standard SAP Fiori app directly from each imported record.
  • Audit imported using the built-in audit function.
  • Grouping of similar error messages and effected source records
  • Export Migration log with source ID and respective error/warning messages

All features in Data Migration Status app are developed in consideration of every role in data migration project, to automate time critical manual activities with simple UX.

Having a strong use case, several user interviews and with empathy towards the Data migration experts, SAP has released a built-in feature “Extended Statistics” part of Data Migration Status app in 1911 Cloud Edition.

Let’s see the use case, with an example object ‘Product’.

As a business user/Migration consultant, I would like to know:

  • Number of products migrated, and the number of records in several other sheets of migration template.
  • Different plants in migration scope and number of products extended to each plant
  • Structure Fields along with respective translation values

In simple words, i would like to have Data Brousing (SE16) Like Functionality in SAP S/4HANA Cloud.

    Exited to know more about Extended statistics? Let’s continue.

    A new column ‘Extended Statistics’ is included in list page of Data Migration Status app.

    1.jpg

    Did you predict what this column brings you? Yes! As the name suggests, the link ‘Statistics’ will display the record counts of all structures in migrated object. The basic layout of ‘Statistics’ popover contains the selectable & significant predefined fields (aka, Active Categories) of a structure, grouped by a structure name with number of records in it.

    2.jpg

    Upon selecting the active category, user will be redirected to the view to know more about the field, with respect to the given source & confirmed target data mapping and number of products associated with the active category field.

    3.jpg

    Further selection over the Active Category field value will lead to the view of related products.

    4.jpg

    To include more interesting fields into the list of active categories, choose ‘Select Categories’ in ‘Statistics’ pop over in list page. Search for a field of your choice or scroll through the list of fields grouped by structure name and save the selected field list.


    5.jpg

    For some reason, to stop the Extended statistics data being logged – you may configure the logging preference using the global action ‘Set Extended Statistics’ in the Data Migration Status app.

    6.jpg

    User must be aware the fact that “Switching off “Log Extended Statistics” not only stops new data from being logged, it also deletes previously logged extended statistics data, if any”. Of course,This configuration is controlled by a confirmation.

    7.jpg

    So, user can expect three different values in ‘Extended statistics’ column of Migration Objects table in list page.

    1.Statistics: A link to explore extended statistics.

    2.No Data: Currently, Extended statistics are not available. Data will be available after the next migration run.

    3.Switched off: User preferred to switch off ‘Extended statistics’ feature.

    Thank you!

    Assigned Tags

        8 Comments
        You must be Logged on to comment or reply to a post.
        Author's profile photo Sandeep Kumar
        Sandeep Kumar

        Vishnu Vardhan Tanguturu This is very useful feature and for sure an asset for LoB specific reconciliation tasks.

        Author's profile photo Frank Finkbohner
        Frank Finkbohner

        Excellent Blog. very useful. 🙂

        Author's profile photo Ryan Muller
        Ryan Muller

        Very useful, thanks.

        Author's profile photo Kelly Hannel
        Kelly Hannel

        Great blog! Thanks for sharing this useful tips 🙂

        Author's profile photo Sai Giridhar Kasturi
        Sai Giridhar Kasturi

        very useful, thanks for sharing

        Author's profile photo Priyank Kumar Jain
        Priyank Kumar Jain

        Pretty useful, thank you for putting this together.

        Author's profile photo Eric Yu
        Eric Yu

        Thanks for the useful tips shared 🙂

        Author's profile photo Parag Parikh
        Parag Parikh

        Such a useful app available since 1909 but surprisingly not yet released for S4 HANA Private Cloud or on-premise edition? 🙁 does SAP expect customers to run SE16N in production to do data reconciliation or do they expect customers to spend time and effort in building custom solution for the same? If custom solution needs to be developed, data migration solution for on-premise version looks half-baked.

        Any direction or POV on solving above issues would really help.