Skip to Content

Creation Delivery by VL01N using Mass Serial Number.

Nov 23, 2017 at 06:34 AM


avatar image

Dear All,

We would like to create delivery document by VL01N.

and we need to input mass serial number.

but, serial input screen shows about 20 lines...

Can we import serial from excel or clipboard in enhancement?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Veselina Peykova
Nov 24, 2017 at 02:59 AM

You have only 5 EA as delivery quantity, why do you want to paste 100 serial numbers?

The size of the popup depends on the delivery quantity, too.

This is how the popup looks for 30 EA in my system:

And if you want to paste many existing SNs the easiest way will be via the button that I marked in red.

When you press it that leads you to select serial numbers for material and a nice ALV grid which makes the selection easier.

You mention having the numbers in a spreadsheet - use a filter per serial number in the ALV to select the ones that you need, then select all from the ALV and confirm:

The result is:

All 30 SNs are in the delivery.

sn-popup.jpg (163.6 kB)
sn-select.jpg (333.9 kB)
sn-res.jpg (84.8 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your answer.

But we cannot decide serial number until delivery issue by our business.

then we would like to paste real serial number from clipboard or excel.


I do not understand your reply: first you said that you have a problem with a small popup when you add serial numbers in VL01N/VL02N.

I explained that your problem is not with SAP, but either with wrongly chosen test data (wrong delivery quantity) or there is some misconception how serial numbers work (expecting that you will assign multiple serial numbers to 1 EA).

Your reply does not help me figure out which of these is the problem and it makes it difficult to address your problem in a meaningful way.

Anyway, the second option that I explained (selecting existing serial numbers from a list) is basically pasting numbers from excel or clipboard when you think about it, you just have a few more steps on top of that.

If the approach is too cumbersome for the business, if they insist on using Excel files to populate serial numbers and you have some development budget left, you can request custom development that will look and behave exactly how the business expects.

You did not explain the exact reason why uploading hundreds of serial numbers from Excel in VL02N is considered as the best possible solution. In projects we used offline approach only as a contingency procedure (temporary network problems in the warehouse). Normally the business prefers this to be done via some mobile application and if possible - scanning a bigger package containing the EA, which would result in populating the SNs based on the box contents.

G Lakshmipathi
Nov 23, 2017 at 03:13 PM

You need to provide more details as your post is not clear. What do you mean by mass serial number?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your question. I'm writing more information as following. following picture, I can paste only 5 serial number from clipboard or excel.

i would like to pastes 100 serial number from clipboard or excel.

scr9-113458.jpg (44.9 kB)