Query to extract serial number form SD delivery item

[Former Member]

Hi experts,

do you know how can I build a query to extract serial number form SD delivery item;

Dynpro filed: RIPW0-SERNR

Structure: RIPW0

Field: SERNR

Data element: GERNR

I'm not able to find a table to be used into a query based on SD Delivery.

Thank you very much.

Kind Regards

Andrea

[former_member197616 · Accepted solution]

at VL02N/VL03N goto EXTRAS--Seriial numebrs will lead to the numbers report. please check.

[Former Member · Accepted solution]

Thank you for this information but I need a report where i can select, material, customer, delivery date.....and check serial numbers.

[Former Member · Accepted solution]

Hi, There is a Report RIOBJK00 which displays the list of serial numbers based on the Delivery Number and Item Number.

You can make use of this program to ge the desired output.

Thnks

Srini

[Former Member]

Hi,

thank you very much, this report is really useful.

But do you know tables that I can use to build my own query? To have additional fields as selection for example.

Thank you very much

Kind Regards

Andrea

[Former Member]

I found these tables being used in the program: ser01, ser02, ser03, ser04, ser05, ser06, objk. Objk table contains the delivery, and ser01, serxx contain the object number. If you link them up, you can query the serial number using delivery number.