Skip to Content

How to get details of serial number or equipment master for GI Deliveries?

Let me start briefly, why serial number and equipment relevant for Sales.

Serial numbers is used to identify a material uniquely. which can provide an overview for material you have sold to which customers. This you can use externally and internally.

And internally you can use Equipment. 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.

Now, we need a report serial number or equipment master for a specific period Goods Issued (GI) Deliveries Document.

So, to get a desired result, we can use following logical sequence.

First, use Table LIKP (SD Document: Delivery Header Data)

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.

As result, you will get list GI delivery documents(Table-Field LIKP-VBELN).

Now, use Table SER01 (Document Header for Serial Numbers for Delivery)

There you need to provide,

Table-Field LIKP-VBELN = SER01-LIEF_NR = Delivery

Here, you will get list of Object list(Table-Field SER01-OBKNR) relevant for GI Deliveries from Table LIKP.

Then, use Table OBJK (Plant Maintenance Object List)

There you need to provide,

Table-Field SER01-OBKNR = OBJK-OBKNR = Object List

Finally, as result you will get:

  • Material (OBJK-MATNR)
  • Equipment (OBJK-EQUNR)
  • Serial Number (OBJK-SERNR)
  • Notification (OBJK-IHNUM)

You can have SAP Query by using following Table to get the desired result.

  • LIKP – SD Document: Delivery Header Data
  • SER01 – Document Header for Serial Numbers for Delivery
  • OBJK – Plant Maintenance Object List
  • LIPS – SD document: Delivery: Item data

Other Serial Number relevant tables:

SER01 – Document Header for Serial Numbers for Delivery

SER02 – Document Header for Serial Nos for Maintenance Contract (SD Order)

SER03 – Document Header for Serial Numbers for Goods Movements

SER04 – Document Header for Serial Numbers for Inspection Lot

SER05 – Document Header for Serial Numbers for PP Order

SER06 – Document Header for Serial Numbers for Handling Unit-Content

SER07 – Document Header for Serial Numbers in Physical Inventory

SER08 – Document Header for Purchase Order Item Serial Numbers

SER09 – Doc. Header for Serial Numbers for Purchase Requisition Item

13 Comments
You must be Logged on to comment or reply to a post.