on 09-25-2009 10:59 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can find equipment nbr, material number and serial number in table V_EQUI.
Serial number is field V_EQUI-SERNR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
serial number tables are starting with SER
SERI has the serial number by material
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
97 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.