Link between stock & serial number table

[former_member193587]

hi

I havinfng 3 quantity of material in stock having 3 serial number,on todays

date ,So how to fetch this 3 serial number in Z report ,I user SER03 but not

Successful.Please provide link between stock table & serial number table.

[Former Member]

This message was moderated.

[former_member193587]

hi

Can you provide link between object counter & equipment number & material for OBJK table So that i can fetch data for report

[former_member193587]

hi

When I am see stock in mb5b ,6 quantity on 10 august 2012 so in which table i will get the stock quantity 06 with 06 serial number on 10 august 2012 ? please help to solve.

thanks in advance.

[Former Member]

Hi,

The table SERI gives the details of Material Number+Serial Number+Material Document number, was that not helpful?

/Manoj

[former_member193587]

hi

when i put material code as input in seri table do not accept it, it accept material documents,So any other solution please?

[Former Member]

Hi,

Check the following tables:

EQSE

RISA0

/Manoj

[JL23]

Material serial nummers are represented technically by an equipment master record (created internally) in table EQUI.

from:

http://help.sap.com/saphelp_45b/helpdata/en/85/603275e24bd111950d0060b03c6b76/content.htm

[ajitkumar]

put the material code + movement type in mseg for material document. filter that in MKPF for date. pass this material documents

[sjeevan]

Jürgen L wrote:
Material serial nummers are represented technically by an equipment master record (created internally) in table EQUI.
from:
http://help.sap.com/saphelp_45b/helpdata/en/85/603275e24bd111950d0060b03c6b76/content.htm

Equipment master record is created automatically only when the serialization procedure (e.g. MMSL) in serial number profile is set to 02. In that case you can see the equipment record in IE03. If it is set to 01, you need to activate it manually  in IQ02. A record in EQUI exist in either case  but not in EQUZ and EQKT in the second case, though.

hi
Can you provide link between material class & equipment number for OBJK table So that i can fetch data for report

Use the following joining logic:

JOIN SER03 AND OBJK
 ON  OBKNR = OBKNR
 AND MATNR = MATNR

[former_member193587]

hi

i agree with ur logic

JOIN SER03 AND OBJK
ON  OBKNR = OBKNR
AND MATNR = MATNR

But I having 1 material code having 10 quantity so it generate 10 serial number .suppose I have to select 5 qty with serial number for consumption then i have to give validation on object counter in OBJK table so please provide this link between object counter & material & serial nmber so that I perfectly fetch data.

[tejyadav]

Below are the tables for Serial numbers, Check which is useful to you, Also check RIPW0, SERI & EQSE 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
SER08	Document Header for Purchase Order Item Serial Numbers
SER09	Doc. Header for Serial Numbers for Purchase Requisition Item

[Former Member]

HI,

Refer the table SERI, it stores the material number with the serial number.

/Manoj