Sap Sale Module: RE:[sap-log-sd] How to find serial number of material for invoice?

Posted by maggiealler (Businesss Analyst )
on Aug 29 at 1:30 PM

Hi Adriano,

The serial number can be found like this:

select obknr from table ser01 where lief_nr = delivery number and posnr = delivery item. It has to be the delivery number because that's where the serial numbers are stored, not in the billing document.

select all the records from objk where obknr = the obknr from ser01. This table has the actual serial numbers in field sernr. I don't know if you have multiple serial numbers attached to 1 item so you may need to apply some loops around the table.

Hope this helps.

Maggie

---------------Original Message---------------
From: Adriano Lopez
Sent: Wednesday, August 24, 2011 8:27 PM
Subject: How to find serial number of material for invoice?

Hello experts,

We need serial number or batch number to be printed in the invoices. How can we pull the information for the smart forms about such information? Logic regarding the tables and fields will be a great help.

Thank you in advance.

__.____._