SAP Display Material Serial Number app Dump issues & Custom CDS View

SAP Display Material serial Number Fiori App

In S/4 Hana Display material Serial Number app is useful when you want to track each item individually for S/4 Hana Rows and Columns Limit. 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. If you have a huge list of inventory items then it may be you have a lot of serial numbers in the system and this app causes a dump in production. This blogs talks about the issue and a possible workaround to fix that issue

The steps include as below.

1.  Finding all serial number using Existing SerialNos List option

2.  Creating a similar report using custom CDS View.

Replicating the issue

While using SAP Display Material Serial Number for S/4 Hana Rows and Columns Limit, it shows a dump in production. However, it works fine in the dev environment. To replicate click on the button Existing SerialNos List as shown 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 in prodution

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

However, as seen below this works fine in Dev as the number of data is limited in Dev, 

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

Issue happens due to a Production issue related to the table having too many records which this app is unable to handle. 

Workaround to create custom CDS view for S/4 Hana Rows and Columns Limit

So as a workaround you could create your CDS view using the  CDS View I_MfgOrderItemSerialNumber.  Here is the link to the CDS view and shows its attribute which you can use to create a similar report as you see above to create similar reports. 

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

Read this to learn more https://peritossolutions.com/services/sap/

However the only limitation of the report created is that the status field which could be an important fields for the customer is missing in this view and they would not be able to filter or view that from this custom report we create using this CDS view and There was no similar other CDS view which was in released status that could be used. 

If you are looking for steps on how to create custom CDS view check here 

https://peritossolutions.com/sap/s-4-hana/sap-how-to-create-custom-cds-view/

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

Conclusion-S/4 Hana Rows and Columns Limit

This article talks about the dump issue in production due to the serial number list not being opened up and how you could replicate the issue in production but not dev since the data is limited in dev. Also as a workaround the to get a similar report create a Custom Report using the CDS view as mentioned in the above section

Get In Touch If You Have A Business Query

Related Posts