SER07 – Document Header for Serial Numbers in Physical Inventory SER06 – Document Header for Serial Numbers for Handling Unit-Content SER05 – Document Header for Serial Numbers for PP Order SER04 – Document Header for Serial Numbers for Inspection Lot SER03 – Document Header for Serial Numbers for Goods Movements SER02 – Document Header for Serial Nos for Maintenance Contract (SD Order) SER01 – Document Header for Serial Numbers for Delivery LIPS – SD document: Delivery: Item data.SER01 – Document Header for Serial Numbers for Delivery.LIKP – SD Document: Delivery Header Data.You can have SAP Query by using following Table to get the desired result.

Table-Field SER01-OBKNR = OBJK-OBKNR = Object List Then, use Table OBJK (Plant Maintenance Object List) Here, you will get list of Object list( Table-Field SER01-OBKNR) relevant for GI Deliveries from Table LIKP. Table-Field LIKP-VBELN = SER01-LIEF_NR = Delivery Now, use Table SER01 (Document Header for Serial Numbers for Delivery) Where we can provide GI dates Table-Field LIKP-WADAT_IST (Actual GI Date).as one of input parameter for getting relevant GI Delivery Documents.Īs result, you will get list GI delivery documents( Table-Field LIKP-VBELN). So, to get a desired result, we can use following logical sequence.įirst, use Table LIKP (SD Document: Delivery Header Data) Now, we need a report serial number or equipment master for a specific period Goods Issued (GI) Deliveries Document. The equipment master record contains several types of data like General data, Plant Maintenance data, location data, sales data, Serial number data, Configuration data & Partner data.

This you can use externally and internally.Īnd internally you can use Equipment.

which can provide an overview for material you have sold to which customers.

Serial numbers is used to identify a material uniquely. Let me start briefly, why serial number and equipment relevant for Sales.

Convert mac address to serial number