I_InspPlanPRTOpTP

Inspection Plan Op Prod Res Tool TP View | view: IIPPRTTP | Extraction: Not supported | Component: Quality Planning
Tables used: DRAT, PLKO, PLPO, PLFH, PLAS, PLAS, CRVD_A, DRAW, EQUI, CRVE_A, EQKT, EQUZ, IFLOT, T002, CRVM_A, MAKT, IMPTT, CRVS_A, CRVP_A, IMPTT, TCF02, TCF03, CRFH, CRTX, T006, T006D, T006A, CRHD
Column Name Description
InspectionPlanGroup Key for Task List Group
InspectionPlan Group Counter
InspectionPlanInternalVersion Internal counter
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
BOOOperationPRTInternalID Item Counter for Production Resources/Tools
BillOfOperationsType Task List Type
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
BillOfOperationsSequence Sequence PLNFOLGE
OperationText Operation Short Text TEXT40
BillOfOperationsDesc Routing Description TEXT40
ProdnRsceToolCategoryName Language-dependent description of the PRT category TEXT40
ProductionResourceTool Production Resource/Tool Number FHMNR
ProductionResourceToolDesc Description of the Production Resource/Tool TEXT40
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_INSPPLANPRTOPTP.MANDT == AENR.MANDT
  • I_INSPPLANPRTOPTP.CHANGENUMBER == AENR.AENNR
Offset Unit for End of Production Resource/Tool Usage
  • Client
  • Offset Unit for End of Production Resource/Tool Usage
  • I_INSPPLANPRTOPTP.MANDT == T006.MANDT
  • I_INSPPLANPRTOPTP.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference date for end of production resource/tool usage I_INSPPLANPRTOPTP.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Control Profile for Management of Production Resources/Tools
  • Client
  • Control Profile for Management of Production Resources/Tools
  • I_INSPPLANPRTOPTP.MANDT == TCF10.MANDT
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF
Standard Text Key for Production Resources/Tools
  • Standard Text Key for Production Resources/Tools
  • Client
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH
  • I_INSPPLANPRTOPTP.MANDT == T435.MANDT
Unit for Quantity of Production Resources/Tools
  • Client
  • Unit for Quantity of Production Resources/Tools
  • I_INSPPLANPRTOPTP.MANDT == T006.MANDT
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI
Formula for Calculating the Total Quantity of PRT
  • Client
  • Formula for Calculating the Total Quantity of PRT
  • I_INSPPLANPRTOPTP.MANDT == TC25.MANDT
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT
Formula for Calculating the Total Usage Value of PRT
  • Client
  • Formula for Calculating the Total Usage Value of PRT
  • I_INSPPLANPRTOPTP.MANDT == TC25.MANDT
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT
Usage Value Unit of the Production Resource/Tool
  • Usage Value Unit of the Production Resource/Tool
  • Client
  • I_INSPPLANPRTOPTP.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI
  • I_INSPPLANPRTOPTP.MANDT == T006.MANDT
Object ID of the resource
  • Client
  • Object ID of the resource
  • Object types of the CIM resource
  • I_INSPPLANPRTOPTP.MANDT == CRID.MANDT
  • I_INSPPLANPRTOPTP.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID
  • I_INSPPLANPRTOPTP.PRODUCTIONRESOURCETYPE == CRID.OBJTY
Offset Unit for Start of Prodn Resource/Tool Usage
  • Client
  • Offset Unit for Start of Prodn Resource/Tool Usage
  • I_INSPPLANPRTOPTP.MANDT == T006.MANDT
  • I_INSPPLANPRTOPTP.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference Date for Start of Production Resource/Tool Usage I_INSPPLANPRTOPTP.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF