topic Re: Serial number in Application Development and Automation Discussions

Serial number

Former Member — Thu, 12 Mar 2009 04:59:37 GMT

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

Re: Serial number

GauthamV — Thu, 12 Mar 2009 05:04:06 GMT

Check these tables.

AFIH,SER05.

Re: Serial number

Former Member — Thu, 12 Mar 2009 05:06:27 GMT

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

Re: Serial number

Former Member — Thu, 12 Mar 2009 05:22:07 GMT

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.

Re: Serial number

matt — Thu, 12 Mar 2009 06:33:13 GMT

Please use a more informative subject in future

Re: Serial number

Former Member — Thu, 12 Mar 2009 07:04:02 GMT

Hi Ramesh.

check this tables,

OBJK and SER01, SER02 etc....

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

Regards.

Sreenu

Re: Serial number

Former Member — Thu, 12 Mar 2009 09:19:22 GMT

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.

Re: Serial number

SrihariNerella — Mon, 20 Apr 2009 13:18:25 GMT

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.