‎2009 Dec 22 4:32 PM
I need to find a serial number in the service order table using the order number. Can someone tell me what is the table that has those fields?
‎2009 Dec 22 5:10 PM
THe order number will be having a object number
Check in AUFK table for the order
Then try the order number passing it to the tables SER00,SER01,SER02,SER03....
I m not exactly sure which of these tables holds the serial no for service order.
‎2009 Dec 22 7:15 PM
Service Orders header in VBAK Item VBAP pick the equipment attached to it and hit EQUI table to get the serial number..
‎2015 Mar 18 10:12 AM
From Service order VBAK-AUFNR to table AFIH with field AUFNR gives you AFIH-EQUNR
and if you need the serial number, you find that in table EQUI, fields EQUNR giving SERNR.
Hope that helps.
regards Hagen