I_RoutingPRTSearchModel

BOO Operation Production Resource/Tool | view: IRTGPRTSRCHMOD | Extraction: Not supported | Component: Routing
Tables used: PLFH
Column Name Description
BillOfOperationsType Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BillOfOperationsSequence Sequence
BOOOperationInternalID Number of the Task List Node
BOOOperationPRTInternalID Item Counter for Production Resources/Tools
BOOOperationPRTIntVersCounter Internal counter
Column Name Description
Column Name Description
📏 Unit for Quantity of Production Resources/Tools (ProdnRsceToolStdWorkQtyUnit):
ProdnRsceToolStandardWorkQty Standard Value for Quantity of Production Resources/Tools
📏 Usage Value Unit of the Production Resource/Tool (ProdnRsceToolUsageQuantityUnit):
ProdnRsceToolUsageQuantity Standard Usage Value for Production Resources/Tools
📏 Offset Unit for Start of Prodn Resource/Tool Usage (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to start of production resource/tool usage
📏 Offset Unit for End of Production Resource/Tool Usage (EndDateOffsetDurationUnit):
EndDateOffsetDuration Offset to finish of production resource/tool usage
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
CreationDate Date Record Created On
LastChangeDate Last Changed On
Column Name Description
ProductionResourceType Object types of the CIM resource Show values
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
Column Name Description Domain name
ProdnRsceToolItemNumber Item Number for Production Resource/Tool PSNFH
ProdnRsceToolText First Line of Text for Production Resources/Tools TEXT40
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
BillOfOperationsVersion Routing Version PLNVERSN
Master Data Relations Join Conditions
Change Number
  • Client
  • Change Number
  • I_ROUTINGPRTSEARCHMODEL.MANDT == AENR.MANDT
  • I_ROUTINGPRTSEARCHMODEL.CHANGENUMBER == AENR.AENNR
Offset Unit for End of Production Resource/Tool Usage
  • Offset Unit for End of Production Resource/Tool Usage
  • Client
  • I_ROUTINGPRTSEARCHMODEL.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_ROUTINGPRTSEARCHMODEL.MANDT == T006.MANDT
Reference date for end of production resource/tool usage I_ROUTINGPRTSEARCHMODEL.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Control Profile for Management of Production Resources/Tools
  • Control Profile for Management of Production Resources/Tools
  • Client
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF
  • I_ROUTINGPRTSEARCHMODEL.MANDT == TCF10.MANDT
Standard Text Key for Production Resources/Tools
  • Client
  • Standard Text Key for Production Resources/Tools
  • I_ROUTINGPRTSEARCHMODEL.MANDT == T435.MANDT
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH
Unit for Quantity of Production Resources/Tools
  • Unit for Quantity of Production Resources/Tools
  • Client
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI
  • I_ROUTINGPRTSEARCHMODEL.MANDT == T006.MANDT
Formula for Calculating the Total Quantity of PRT
  • Client
  • Formula for Calculating the Total Quantity of PRT
  • I_ROUTINGPRTSEARCHMODEL.MANDT == TC25.MANDT
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT
Formula for Calculating the Total Usage Value of PRT
  • Client
  • Formula for Calculating the Total Usage Value of PRT
  • I_ROUTINGPRTSEARCHMODEL.MANDT == TC25.MANDT
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT
Usage Value Unit of the Production Resource/Tool
  • Usage Value Unit of the Production Resource/Tool
  • Client
  • I_ROUTINGPRTSEARCHMODEL.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI
  • I_ROUTINGPRTSEARCHMODEL.MANDT == T006.MANDT
Object ID of the resource
  • Object types of the CIM resource
  • Client
  • Object ID of the resource
  • I_ROUTINGPRTSEARCHMODEL.PRODUCTIONRESOURCETYPE == CRID.OBJTY
  • I_ROUTINGPRTSEARCHMODEL.MANDT == CRID.MANDT
  • I_ROUTINGPRTSEARCHMODEL.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID
Offset Unit for Start of Prodn Resource/Tool Usage
  • Offset Unit for Start of Prodn Resource/Tool Usage
  • Client
  • I_ROUTINGPRTSEARCHMODEL.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_ROUTINGPRTSEARCHMODEL.MANDT == T006.MANDT
Reference Date for Start of Production Resource/Tool Usage I_ROUTINGPRTSEARCHMODEL.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF