cancel
Showing results for 
Search instead for 
Did you mean: 

Serial Number to Items

Former Member
0 Kudos

Hi All,

I am using serial numbers to finished goods items.

I sell one item as 1001 to a customer.

So all the documents related to sales (Sales order, Delivery, A/R Invoice) do not show the serial number of the particular product sold.

From the form settings if I select the Serial No. field, it adds the field in the rows but does not show the serial number of the item selected.

My client needs to view the serial numbers of the items sold.

Can anybody suggest.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member583013
Active Contributor
0 Kudos

Hello Ajit,

There are a few things to be considered when looking at the option of using a UDF at the row level.

Let us say, you have item A which has quantity 5. This mean you will have 5 serial number. Since this is a very good possibility in business you need to take this into consideration.

FMS(formatted search) will not be a good option or will be too difficult to implement. Couple of reason, you have to add the document first and then trigger the FMS manually by calling the document back.

You will have to Query the serial number tables OSRI and SRI1 (NOT OIBT and IBT1).

Therefore, if you are still holding on your thought to get the Serial numbers on the Screen. Then use the UDF option but create a row level UDF large enough to hold the maximum number of serial numbers you think can be delivered per item.

Then you need to write code in the SBO transaction notification stored procedure to create a looping construct to fetch all the serial numbers for a line item and ConCat it to one variable and Update the UDF with this Variable's value.

Suda

former_member583013
Active Contributor
0 Kudos

Ajit,

If you have an Item set to Manage Serial numbers and if your business process is

Sales Order > Delivery > Invoice..

During Delivery..SAP will Open a window asking to select the Serial Numbers for the Serialized Item in the Delivery. Once you have selected the Serial number and added the document. When you print the Delivery document SAP will print another sheet showing the Serial numbers.

SAP does not print the Serial number on all the 3 documents.

Go to on Administration > System Initialization > Print Preferences... Per document Tab... for Delivery.. make sure you have selected Document and Batch/Serial number option in the When Batch/Serial No. Exist, Print.

Only if this option is selected Serial number sheet will print along with Packing slip.

Suda

Former Member
0 Kudos

Hi Suda,

Your answer stands very much right from printing point of view.

But my question here is bit different.

I would like to view the serial numbers selected in the document itself rathr than printing.

The Delivery document is the where I select the serial numbers, so I would like to view the serial numbers there in the line itself.

Please suggest.

former_member186095
Active Contributor
0 Kudos

Hello,

I suggest you to use a UDF in the row line but the difficulty is to fill it with serial number. maybe you can develop query FMS to make sure it filled automatically.

Another means to make you able to write serial number is remarks field. But it is not on the row line and also need query FMS to do that.

The tables for serial and batch management is OIBT and IBT1.

Rgds,

former_member186095
Active Contributor
0 Kudos

Hi,

In addition to my previous reply, the table for serial no. is OSRI and SRI1. I forget to write it. Someone can't differentiate these words :" serial and batch management is OIBT and IBT1" with "serial and batch management are OSRI and SRI1 and OIBT and IBT1".

talking about FMS, I think you could try first rather than listening to someone. Maybe it seems illogical but from practice, there will be come a good idea.

Rgds,