09-19-2008 2:16 PM
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
09-19-2008 2:32 PM
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.
09-22-2008 5:06 AM
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.
10-22-2008 6:17 PM
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
10-22-2008 6:38 PM
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
09-22-2015 7:16 AM