How to Get WorkOrder details from Material and Plant

[Former Member]

Experts,

I need you inputs.

I need to pass MATNR and WERKS and get all the related (PM) work orders. I checked the tables AFPO, AUFM and MKAl.

All these tables were empty.

When I go in IW33 and select a Order number, I am able to see the Equipment Number (EQUNR). This equipment number is also available in MATNR.

Can any one tell me from where I can pick all the work order numbers related to a Material and Plant?

Thanks

Edi

[deepak_dhamat]

Hi ,

Please check tables

tables : equi, " Equipment master data

eqkt, " Equipment Short Texts

equz, " Equipment time segment

mpos, " Maintenance item

mhio, " Call Object from Maintenance Order

afko, " Order header data PP orders

qals, " Inspection lot record

qase, " Results table for the sample unit

qamr, " Characteristic results during inspection processing

qamv, " Characteristic specifications for inspection processing

qpct, " Code texts

plwp, " Allocation of maintenance packages to task list operations

mhis. " Maintenance plan history

data related to Equipment History .

regards

Deepak.

[Subhankar]

I think you will get it from AFPO.

Can you check in Quality and production system.

Thanks

Subhankar