Skip to Content
Technical Articles
Author's profile photo Vinita Kasliwal

Display Material Serial Number app Dump on Existing SerialNos List button

Introduction-S/4 Hana Display material Serial Number

The Serial number app contains information for serial number management. The serial number is given to an item of material in addition to the material number, in order to differentiate that individual item from all other pieces of this material. The combination of material and serial number is unique.

S/4 Hana Display material Serial Number has a bug where if the production has a lot of entries i.e if there are multiple numbers of Materials with a huge quantity the app shows a dump when trying to see the entire list. Refer to the article where the steps to replicate the issue and a workaround are mentioned

  1. Replicate in Production
  2. Works fine in Development
  3. Workaround to create a custom CDS view.

Steps to Replicate the dump in production

While using SAP Display Material Serial Number, it shows a dump in production. If the system has a lot of material and huge quantities of each material the issue is likely to occur as the system cannot process those many records to show as a list. Open the Display Material Serial Number Fiori app and click on Existing SerialNo List app as seen below

Table indicating a dump in production for S/4 Hana Display Material Serial Number

Below is what happens when clicked on the Existing Serial Number list button.

Table for Existing Serial Number list button for S/4 Hana Display Material Serial Number

Works fine in Development

Following the same steps in Development works fine as seen below it shows the list of all material, Serial numbers in the system. This is due to a Production issue related to the table having too many rows

S/4 Hana Display Material Serial Number working fine in Dev

Workaround

This note talks about the same issue 3169273 – App “Display Material Serial Number” dumps when using the button ‘Existing SerialNos List’.

https://launchpad.support.sap.com/#/notes/3169273

The issue occurs because too many records are being accessed and it is causing a memory shortage

The resolution, as stated on the note, says  “In the App Display Material Serial Number ( App ID IQ03 ) input a Material Number before using the button ‘Existing SerialNos List’ or use the other app Display Material Serial Number app ( App ID IQ09 ) which has many more filters that could be used to reduce the size of data set.

The Display Material Serial Number app ( App ID IQ09 ) does not have a parameter/field to specify the limit of records returned.”

However, this does not work as the whole purpose is to see the entire list and not just specific to a material.

So in order to meet the client’s requirement to show an entire list of all serial numbers and materials in the system, I created a CDS view using the  CDS View I_MfgOrderItemSerialNumber. This was then consumed in an analytical report and was able to get the entire list. Here is the link to the Released CDS view from SAP.

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/8308e6d301d54584a33cd04a9861bc52/f0640dd38c0f425bb97e6fcbf9993836.html?version=1909.latest&q=serial%20number%20cds

Note that this still has a limitation that the Status field is not included in this or any other CDS view in the system hence the list we published had all of the other fields shown in standard except status.

Conclusion-S/4 Hana Display Material Serial Number

Using the Display material serial number app it works fine when the Existing SerialNos List button is being used in Development but shows a dump when used in production as too many records are being accessed and causes a memory shortage issue. The article explains a workaround if the list is needed to be seen in production on the standard CDS view which can be used.

Create a custom analytical query that uses the CDS View or you could combine this standard View and other CDS view to create a custom CDS view and a similar view as seen in development can be created. This CDS view can then be used to create an analytical query.

To create a custom analytical query I posted another blog here https://blogs.sap.com/2022/06/18/create-custom-analytical-query-using-custom-cds-view-and-show-as-a-fiori-app/

 

The original article was posted here 

Thanks for reading let me know if this helped.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Satheesh Sambandamurthy
      Satheesh Sambandamurthy

      Hi Vinita,

      Thanks for the blog.

      • Can you please elaborate on what you did for the app(IQ03) to refer to your custom CDS view in place of existing standard logic. is there any enhancement done? Please share screenshots for the same.
      • I understand that the issue was due to memory shortage but the CDS view will also retrieve the same amount of data and how is the memory shortage rectified here.
      Author's profile photo Freya Scotts
      Freya Scotts

      Nice Post! Thanks for sharing such an amazing article, really informative, and it helps me a lot.