Serial number management [rev]


  • Configuration
    • Serial number
    • Procedure
    • Serial number profile
    • Equipment 
  • Uses 
    • Serial Numbers in Inventory Management
    • Serial Numbers in Physical Inventory
    • Serial Numbers in Production Orders
    • Serial Numbers in Quality Management
    • Serial Numbers in Sales and Distribution
    • Serial Numbers in Handling Units
    • Serial Numbers in Purchasing
  • Functions
    • Get list of serial numbers from a document via FM
  • Additional information
    • 2524104 - Different materials may have the same serial number in the system
    • What are some of the problems with managing Equipment Serial Numbers?
    • 2670492 - Same serial number can be used in another purchase order again
    • 523498 - Reset last serial number for a material
    • 119713 - How to activate Serial Number functionality
    • 1795864 - Serial number in sales order processing using BAPIs (22.09.21)
  • Data model

It is possible to assign serial numbers in sales orders, inquiries and quotations, as well as for deliveries and returns deliveries, purchase requisition, purchase orders, process orders, entering the physical inventory count. This makes it possible to track individual objects when goods movements take place (for example, the sale of goods to a customer).

Configuration

Serial number





Procedure

  1. Create a serial number profile in Customizing for Plant Maintenance.
  2. Create a material master record and enter a serial number profile.
  3. Create serial number master records in advance, if we want to have a pool of serial numbers.
    • From a technical perspective, an "incomplete" equipment master record is created for this.
  4. Create configuration data for serial number master records.
  5. Assign serial numbers to the material when business procedures take place.
  6. Add to the data of a master record to make it a "complete" equipment master record if it involves a piece of equipment.
We can create serial number master records even if no serial number profile is entered in the material master. 

You can no longer delete the serial number profile in the material master record. Instead of this, you create a serial number profile without serialization procedures in Customizing and enter this in the material master record.


Serial number profile

The serial number profile in the master record at plant level for the material whose individual pieces are to be managed using material numbers
  • SDAU: This procedure makes possible the use of serial numbers in sales orders, inquiries and quotations.
  • SDLS: This procedure makes possible the assignment of serial numbers for deliveries.
    • Procedure SDLS defines that the serial number should be created on delivery. The serial number usage for it should be 02 = can . 
  • SDCC: This procedure makes possible the assignment of serial numbers when performing completeness checks for deliveries.
    • Procedure SDCC checks the serial number on goods issue. The serial number usage for it should be 03 = must . 
  • SDRE: This operation makes possible the assignment of serial numbers for returns deliveries.
  • SDCR: This procedure makes possible the assignment of serial numbers when performing completeness checks for returns deliveries.

Equipment 

What is Equipment in SAP terminology?

It is like an individual physical object that can be installed or to be a part of a system, and can be maintained or installed independently.

What type of data does the Equipment object include?

  • General data;
  • Plant Maintenance data, location data and sales data;
  • Serial number data.

How to create Equipment? 

Logistics>Plant maintenance>Technical objects> Equipment 





Uses 

Serial Numbers in Inventory Management

If backflushing is defined for the material in the master record, you cannot enter a serial number profile that has serial number requirement for goods movement.

Serial Numbers in Physical Inventory

  • Entering the physical inventory count (MI04)
  • Entering the physical inventory count without reference to a document (MI09)
  • Entering the count and posting differences in one step (MI08)
  • Creating a physical inventory document, entering the count, and posting differences in one step (MI10)
  • Changing the physical inventory count (MI05)

Serial Numbers in Production Orders

When printing shop papers you can also print a label with barcode for each serial number.

If a production order is created with reference to a sales order item within the framework of make-to-order production, the system proposes all serial numbers assigned to this item in the production order.

Serial Numbers in Quality Management

If an inspection lot is created on goods receipt or when a production order is released, the system copies existing serial numbers into the object list of the inspection lot.

Serial Numbers in Sales and Distribution

It is possible to assign serial numbers in sales orders, inquiries and quotations, as well as for deliveries and returns deliveries. 

Serial Numbers in Handling Units

Assign materials with serial numbers in the items of handling units (HUs). If these handling units are used in deliveries or material documents, the serial numbers are copied automatically into the items of the subsequent documents.
  1. Creating and Changing Handling Units
  2. Goods Issue of a Handling Unit
  3. Goods Receipt of a Handling Unit
  4. Repacking
  5. Stock transfer

Serial Numbers in Purchasing

This function is used principally for stock transport orders, recursive subcontracting orders and return orders, when serial numbers already exist at the point when the order is created.


Functions

Get the list of serial numbers from a document via FM

Function Module GET_SERNOS_OF_DOCUMENT ( or LE_SHP_DLVOUTP_SERNR_SELECT) can be used to retrieve serial numbers corresponding to any of the following documents.
  • Delivery/Sales order/Material document/Inspection lot/production order/Internal Handling unit/Physical Inventory document
Function Module WS_DELIVERY_UPDATE_2 using the table SERNR_TAB.

Additional information

2524104 - Different materials may have the same serial number in the system

If the indicator "SerLevel" is 1, the serial number and equipment number are kept synchronous; that is, when master records are created, the system always sets the equipment number the same as the serial number. In this way, you can make the serial numbers unique on a client-wide scale. A prerequisite for this is that all material master records have the indicator set to 1.
This indicator is plant-wide, that is, the setting applies to all the plants of the corresponding material master record.



The indicator "SerLevel" = 1 means when master records are created, the system always sets the equipment number the same as the serial number. So you need to check the number range setting of equipment, to make sure it has a suitable external number range set. Normally, you need to check the followings:
In t-code OIS2, make sure that an equipment category is assigned to the corresponding serial number profile.
In t-code SNRO, object EQUIP_NR, make sure that this equipment category is assigned to an interval, which has an external number range assigned. Also, this external number range covers all the serial numbers you would like to be created. 

What are some of the problems with managing Equipment Serial Numbers?

Each serial number has its own life-cycle. Most benefit greatly from knowing about their serial numbers:
  • With Serialized Equipment, we know where each piece of equipment is located At the warehouse /  En-route during shipping/ At a customer site / In repair )
  • S/N service history
  • What the warranty status is


In SAP, the serial number record is expanded to an equipment record. That is where a lot of the additional serial specific data lives. The equipment record has a system-wide unique ID, the Equipment Number, tied to the material and serial number.

The equipment number is that one ID that immediately finds the record. 100% match. Folks take advantage of that, by printing the equipment number on the equipment tag.

2670492 - Same serial number can be used in another purchase order again

You may use a user status to restrict using the same Serial Number in the second PO
Under this profile, create a user status, which is set at business transaction 'Assign to order items', and once set, forbids the business transaction 'Assign to order items'.

523498 - Reset last serial number for a material

The serial number can be adjusted through transactions IQ02 or IE02. This will not change the highest number but the utility program RIMASE01 can then be run to set the current highest number. Proceed as follows:
  1. Edit the material/serial number in transaction IQ02
  2. Select the menu option: Edit - Special serial number functions - Change serial number
  3. Change the serial number
  4. Save the revised serial number
  5. From transaction SE38, execute the report RIMASE01 for the material

119713 - How to activate Serial Number functionality

Activate Business Function: LOG_MM_SERNO

1795864 - Serial number in sales order processing using BAPIs

Serial number functionality cannot be used together with BAPIs belonging to sales order processing. It is a missing functionality in standard SAP systems.

A possible workaround could be the use of the function module SERNR_ADD_TO_AU. This function module could be used to add serial number to existing sales order items. However, this function module is not released for customers, therefore restrictions of SAP note 109533 apply:

Data model

Linkage
  • 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 dat

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 Inventor
  • SER08 – Document Header for Purchase Order Item Serial Numbers
  • SER09 – Doc. Header for Serial Numbers for Purchase Requisition Item 

Comments