C_OperationActyPRTAssignment

Shop Floor Item At Operation Activity | view: CMPEOAPRTA | Extraction: Not supported | Component: Shop Floor Execution
Tables used: DRAT, MPE_OAI_EQUI_REG, MPE_PRT_OAI, AFFH, CRVD_A, DRAW, EQUI, CRVE_A, EQKT, EQUZ, MARA, CRVM_A, MAKT, CRVS_A, TCF02, TCF03, CRFH, CRTX
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 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
ProductionResourceTool Production Resource/Tool Number FHMNR
MfgOrderOpProdnRsceToolText Description of the Production Resource/Tool TEXT40
ProdnRsceToolCategoryExtCode Production Resources/Tools Category MPE_FHMAR
ProdnRsceToolCategoryName Language-dependent description of the PRT category TEXT40
MiscProductionResourceTool Miscellaneous Production Resources and Tools SFHNR
ProdnRsceToolRegnIsAllowed Specifies that the PRT can be Registered in Execution
Material Material Number MATNR
MaterialName Material Description TEXT40
SerialNumber Serial Number GERNR
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
DocumentVersion Document Version DOKVR
DocumentPart Document Part DOKTL
PRTRegistrationCriticality null
NumberOfActvEquipRegistrations Registration Counter for Equipment
ManufacturingOrderType Order Type AUFART
ProductionPlant Plant WERKS
ProdnRsceToolItemNumber Item Number for Production Resource/Tool PSNFH
Master Data Relations Join Conditions
Document number
  • Document number
  • Document Part
  • Client
  • Document Type
  • Document Version
  • C_OPERATIONACTYPRTASSIGNMENT.DOCUMENTINFORECORD == DRAW.DOKNR
  • C_OPERATIONACTYPRTASSIGNMENT.DOCUMENTPART == DRAW.DOKTL
  • C_OPERATIONACTYPRTASSIGNMENT.MANDT == DRAW.MANDT
  • C_OPERATIONACTYPRTASSIGNMENT.DOCUMENTTYPE == DRAW.DOKAR
  • C_OPERATIONACTYPRTASSIGNMENT.DOCUMENTVERSION == DRAW.DOKVR
Document Type
  • Client
  • Document Type
  • C_OPERATIONACTYPRTASSIGNMENT.MANDT == TDWA.MANDT
  • C_OPERATIONACTYPRTASSIGNMENT.DOCUMENTTYPE == TDWA.DOKAR
Equipment Number
  • Client
  • Equipment Number
  • C_OPERATIONACTYPRTASSIGNMENT.MANDT == EQUI.MANDT
  • C_OPERATIONACTYPRTASSIGNMENT.EQUIPMENT == EQUI.EQUNR
Unit for Total Planned Quantity of Production Resource/Tool
  • Client
  • Unit for Total Planned Quantity of Production Resource/Tool
  • C_OPERATIONACTYPRTASSIGNMENT.MANDT == T006.MANDT
  • C_OPERATIONACTYPRTASSIGNMENT.PLANNEDPRODNRSCETOOLQTYUNIT == T006.MSEHI
Production Resources/Tools Category C_OPERATIONACTYPRTASSIGNMENT.PRODNRSCETOOLCATEGORY == TCF02.FHMAR