P_OperationActyPRTAssignment

Shop Floor Item At Operation Activity | view: PMPEOAPRTA | Extraction: Not supported | Component: Shop Floor Execution
Tables used: MPE_PRT_OAIAFFHCRVD_ADRAWEQUICRVE_AEQUZCRVM_ACRVS_ACRFH
Column Name Description
OpActyNtwkInstance Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
OrderInternalID Routing number of operations in the order
MfgOrderOpProdnRsceToolIntID Item Counter for Production Resources/Tools
Column Name Description
Column Name Description
📏 Unit for Quantity of Production Resources/Tools (ProdnRsceToolStdWorkQtyUnit):
ProdnRsceToolStandardWorkQty Standard Value for Quantity of Production Resources/Tools
📏 Unit for Total Planned Quantity of Production Resource/Tool (PlannedProdnRsceToolQtyUnit):
PlannedTotalProdnRsceToolQty Total Planned Quantity of Production Resource/Tool
Column Name Description
Column Name Description
ProductionResourceType Production Resource Type Show values
ManufacturingOrderCategory Order Category Show values
Column Name Description Domain name
Material Material Number MATNR
DocumentVersion Document Version DOKVR
DocumentPart Document Part DOKTL
MiscProductionResourceTool Miscellaneous Production Resources and Tools SFHNR
OrderProdnRsceToolText First Line of Text for Production Resources/Tools TEXT40
ProdnRsceToolRegnIsAllowed Specifies that the PRT can be Registered in Execution
ManufacturingOrderType Order Type AUFART
ProductionPlant Plant WERKS
ProdnRsceToolItemNumber Item Number for Production Resource/Tool PSNFH
Master Data Relations Join Conditions
Document number
  • Document Type
  • Document Part
  • Client
  • Document number
  • Document Version
  • P_OPERATIONACTYPRTASSIGNMENT.DOCUMENTTYPE == DRAW.DOKAR
  • P_OPERATIONACTYPRTASSIGNMENT.DOCUMENTPART == DRAW.DOKTL
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == DRAW.MANDT
  • P_OPERATIONACTYPRTASSIGNMENT.DOCUMENTINFORECORD == DRAW.DOKNR
  • P_OPERATIONACTYPRTASSIGNMENT.DOCUMENTVERSION == DRAW.DOKVR
Document Type
  • Document Type
  • Client
  • P_OPERATIONACTYPRTASSIGNMENT.DOCUMENTTYPE == TDWA.DOKAR
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == TDWA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • P_OPERATIONACTYPRTASSIGNMENT.EQUIPMENT == EQUI.EQUNR
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == EQUI.MANDT
Unit for Total Planned Quantity of Production Resource/Tool
  • Client
  • Unit for Total Planned Quantity of Production Resource/Tool
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == T006.MANDT
  • P_OPERATIONACTYPRTASSIGNMENT.PLANNEDPRODNRSCETOOLQTYUNIT == T006.MSEHI
Production Resources/Tools Category P_OPERATIONACTYPRTASSIGNMENT.PRODNRSCETOOLCATEGORY == TCF02.FHMAR
Unit for Quantity of Production Resources/Tools
  • Client
  • Unit for Quantity of Production Resources/Tools
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == T006.MANDT
  • P_OPERATIONACTYPRTASSIGNMENT.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI
Internal ID of Production Resource/Tool
  • Production Resource Type
  • Client
  • Internal ID of Production Resource/Tool
  • P_OPERATIONACTYPRTASSIGNMENT.PRODUCTIONRESOURCETYPE == CRID.OBJTY
  • P_OPERATIONACTYPRTASSIGNMENT.MANDT == CRID.MANDT
  • P_OPERATIONACTYPRTASSIGNMENT.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID