Tables which stores PRT details of a Maintenance Order

[Former Member]

Hello All,

I would like to know the tables which store the details of the Production Resource Tool (PRT) which are assigned to an activity in a maintenance order in PM and how these tables are linked to the Maintenace Order table ?

Thanks in Advance,

With Warm Regards,

Rajeeve.

<REMOVED BY MODERATOR - REQUEST OR OFFER POINTS ARE FORBIDDEN>

Edited by: Alvaro Tejada Galindo on Sep 19, 2008 5:09 PM

[Former Member]

Hi Rajeeve,

Have a look on the following tables:

AFFH - PRT assignment data for the work order

AFIH - Maintenance order header

Hope this will help.

Regards,

Nitin.

[Former Member]

Hi,

Thanks for the info. But table AFFH does not give the equiment number (PRT assigned to the activity in a maintainance order). Of course, it gives the PRT allocation details. From which table can we get the equipment number i.e the PRT euipmenty assigned to the activity in the maintainance order.

[former_member207405]

Hey:

Can you tell me from what table I can get the equipment number for a Maintenance Order.? Looks like you were looking for the same. Any help is appreciated. Thanks.

Edited by: Gautam Ankam on Oct 22, 2008 7:19 PM

[arjun_thakur]

hi,

try these tables:

AFFH PRT assignment data for the work order

CRVD_A Link of PRT to Document

CRVD_B Link of Document to PRT

CRVE_A Assignment PRT data - equipment

CRVE_B Assignment equipment - PRT data

CRVM_A Link of PRT data to a material

CRVS_A Relationship of PRT internal number to PRT external number

CRVS_B Relationship of PRT external number to PRT internal number

Customizing tables:

TCF02 PRT categories

TCF03 Texts for the production resources/tools category

TCF04 Status of the PRT master

TCF05 Language-dependent text table for PRT status

TCF06 Field groups in the PRT master for reference

TCF07 Language-dependent texts for field groups in PRT master

TCF08 Assignment of PRT master fields to field groups

TCF10 PRT control key

TCF11 Language-dependent text table for PRT control keys

TCF12 PRT group key

TCF13 Language-dependent text table for PRT group keys

I hope it helps

arjun

[Former Member]

This message was moderated.