Serial number

[Former Member]

Please use a more informative subject in future

Hi,

In equipment master one field is there called serail number (SERNR), I want to know the table and

field name related to this field linked to production order table. I have already checked in technical

information and as per that the data is getting stored in the view ITOB and the table behind it is EQUI. But i want to put a query to check the process order related to this serial number. i had checked IQ03 transaction as per that i found one field in AFPO table that is serial number profile not serial numbr

. i want to trace the process order number based on serial number and material combination maintained in the equipment master. Any help will be highly appreciated.

Thanks a lot in advance.

Edited by: Matt on Mar 12, 2009 7:32 AM

[Former Member]

Please use a more informative subject in future

Hi,

In equipment master one field is there called serail number (SERNR), I want to know the table and

field name related to this field linked to production order table. I have already checked in technical

information and as per that the data is getting stored in the view ITOB and the table behind it is EQUI. But i want to put a query to check the process order related to this serial number. i had checked IQ03 transaction as per that i found one field in AFPO table that is serial number profile not serial numbr

. i want to trace the process order number based on serial number and material combination maintained in the equipment master. Any help will be highly appreciated.

Thanks a lot in advance.

Edited by: Matt on Mar 12, 2009 7:32 AM

[GauthamV]

Check these tables.

AFIH,SER05.

[Former Member]

Hi;

This can be done via selecting the object list number from table SER01 for the delivery items. Then using this object list number the serial numbers can be found in table OBJK (there will be only one serial number per item).Also in table OBJK the equipment numbers(EQUNR) for these serial numbers are found.

Regards

Shashi

[Former Member]

Hi,

Thanks for your reply, but i want to know the table linked to production order (AUFNR) based on serail number maintained in the equipment master. I mean based on the serial number i want to find the corresponding process order number. How can i?

Thanks a lot in advance.

[Former Member]

plz check following tables

SER05 - Document Header for Serial Numbers for PP Order

OBJK -

Pass your serial number into OBJK-EQUNR and get OBKNR.

Then pass this OBKNR to SER05 to get pp order PPAUFNR and item number PPPOSNR.

[matt]

Please use a more informative subject in future

[Former Member]

Hi Ramesh.

check this tables,

OBJK and SER01, SER02 etc....

user ser* in se11........

Regards.

Sreenu

[SrihariNerella]

Hi Ramesh,

I have problem in uploading data to QP02 transction using bdc .I have seen your post .I think you have solution .How you solve your problem .I am also now facing same probelm .

Regards

Nandan.