I_InspPlanOpPRT

Inspection Plan Production Res Tool View | view: IIPOPPRT | Extraction: Not supported | Component: Quality Planning
Tables used: DRAT, PLKO, PLPO, PLFH, 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
Column Name Description
InspectionPlanGroup Key for Task List Group
InspectionPlan Group Counter
InspectionPlanInternalVersion Internal counter
BOOOpInternalVersionCounter Internal counter
BOOOperationInternalID Number of the Task List Node
BOOOperationPRTInternalID 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
📏 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
BillOfOperationsType Task List Type PLNTY
ProdnRsceToolCategoryName Language-dependent description of the PRT category TEXT40
ProductionResourceTool Production Resource/Tool Number FHMNR
ProductionResourceToolDesc Description of the Production Resource/Tool TEXT40
Equipment Equipment Number EQUNR
EquipmentName Description of technical object TEXT40
ProdnRsceToolCategory Production Resources/Tools Category PRT_CATEGORY
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
DocumentPart Document Part DOKTL
DocumentVersion Document Version DOKVR
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • I_INSPPLANOPPRT.CHANGENUMBER == AENR.AENNR
  • I_INSPPLANOPPRT.MANDT == AENR.MANDT
Document number
  • Document Part
  • Document Type
  • Document number
  • Document Version
  • Client
  • I_INSPPLANOPPRT.DOCUMENTPART == DRAW.DOKTL
  • I_INSPPLANOPPRT.DOCUMENTTYPE == DRAW.DOKAR
  • I_INSPPLANOPPRT.DOCUMENTINFORECORD == DRAW.DOKNR
  • I_INSPPLANOPPRT.DOCUMENTVERSION == DRAW.DOKVR
  • I_INSPPLANOPPRT.MANDT == DRAW.MANDT
Document Type
  • Document Type
  • Client
  • I_INSPPLANOPPRT.DOCUMENTTYPE == TDWA.DOKAR
  • I_INSPPLANOPPRT.MANDT == TDWA.MANDT
Offset Unit for End of Production Resource/Tool Usage
  • Offset Unit for End of Production Resource/Tool Usage
  • Client
  • I_INSPPLANOPPRT.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_INSPPLANOPPRT.MANDT == T006.MANDT
Reference date for end of production resource/tool usage I_INSPPLANOPPRT.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Control Profile for Management of Production Resources/Tools
  • Control Profile for Management of Production Resources/Tools
  • Client
  • I_INSPPLANOPPRT.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF
  • I_INSPPLANOPPRT.MANDT == TCF10.MANDT
Standard Text Key for Production Resources/Tools
  • Standard Text Key for Production Resources/Tools
  • Client
  • I_INSPPLANOPPRT.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH
  • I_INSPPLANOPPRT.MANDT == T435.MANDT
Unit for Quantity of Production Resources/Tools
  • Client
  • Unit for Quantity of Production Resources/Tools
  • I_INSPPLANOPPRT.MANDT == T006.MANDT
  • I_INSPPLANOPPRT.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI
Formula for Calculating the Total Quantity of PRT
  • Formula for Calculating the Total Quantity of PRT
  • Client
  • I_INSPPLANOPPRT.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT
  • I_INSPPLANOPPRT.MANDT == TC25.MANDT
Formula for Calculating the Total Usage Value of PRT
  • Formula for Calculating the Total Usage Value of PRT
  • Client
  • I_INSPPLANOPPRT.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT
  • I_INSPPLANOPPRT.MANDT == TC25.MANDT
Usage Value Unit of the Production Resource/Tool
  • Usage Value Unit of the Production Resource/Tool
  • Client
  • I_INSPPLANOPPRT.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI
  • I_INSPPLANOPPRT.MANDT == T006.MANDT
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • I_INSPPLANOPPRT.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID
  • I_INSPPLANOPPRT.PRODUCTIONRESOURCETYPE == CRID.OBJTY
  • I_INSPPLANOPPRT.MANDT == CRID.MANDT
Offset Unit for Start of Prodn Resource/Tool Usage
  • Offset Unit for Start of Prodn Resource/Tool Usage
  • Client
  • I_INSPPLANOPPRT.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_INSPPLANOPPRT.MANDT == T006.MANDT
Reference Date for Start of Production Resource/Tool Usage I_INSPPLANOPPRT.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF