cancel
Showing results for 
Search instead for 
Did you mean: 

Table containing serial number of a material

former_member583200
Participant

Hi Friends,

I have activated serial number for materials. When I do GR, i give serial number for the material. I just want to know in which Table does these serial numbers specific to one material is stored. Information for the serial number for each specific materials is required for a developed report. Can anybody please let me know the table name where I can find the serial number for a specific material?

Thanks & Regards

Satya

Accepted Solutions (1)

Accepted Solutions (1)

former_member184655
Active Contributor
0 Kudos

Dear Sahoo,

Check these tables,

SER00 General Header Table for Serial Number Management

SER01 Document Header for Serial Numbers for Delivery

SER02 Document Header for Serial Nos for Maint.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

Regards

Mangalraj.S

Answers (3)

Answers (3)

former_member583200
Participant
0 Kudos

Thanks

Former Member
0 Kudos

You can find equipment nbr, material number and serial number in table V_EQUI.

Serial number is field V_EQUI-SERNR.

JL23
Active Contributor
0 Kudos

serial number tables are starting with SER

SERI has the serial number by material

former_member583200
Participant
0 Kudos

Hi,

When I execute to see the entries for serial numbers for a material in SERI table in se11 or se16n, system gives the message "No table entries found for specified key". Whereas serial number exists for that material which I can see from the GR i had posted for the material.

Please suggest.

Thanks & Regards

Satya