C_InspPlanPRT

Consumption View for PRT | view: CIPPRT | Extraction: Not supported | Component: Inspection 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, USR21, CRHD

🔑 Keys (7)
💰 Amounts
∑ Quantities (4)
📅 Dates (4)
☰ Categorical (3)
Other (11)
🔗 Relations (12)

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
BillOfOperationsDesc	Routing Description	TEXT40
OperationText	Operation Short Text	TEXT40
ProdnRsceToolItemNumber	Item Number for Production Resource/Tool
ProdnRsceToolCategoryName	Language-dependent description of the PRT category	TEXT40
ProductionResourceTool	Production Resource/Tool Number	FHMNR
ProductionResourceToolDesc	Description of the Production Resource/Tool	TEXT40
ProdnRsceToolText	First Line of Text for Production Resources/Tools
CreatedByUser	Created By User	XUBNAME
LastChangedByUser	Last Changed By User	XUBNAME
BillOfOperationsVersion	Routing Version	PLNVERSN

Master Data Relations	Join Conditions
Change Number Change Number Client	`C_INSPPLANPRT.CHANGENUMBER == AENR.AENNR` `C_INSPPLANPRT.MANDT == AENR.MANDT`
Offset Unit for End of Production Resource/Tool Usage Client Offset Unit for End of Production Resource/Tool Usage	`C_INSPPLANPRT.MANDT == T006.MANDT` `C_INSPPLANPRT.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI`
Reference date for end of production resource/tool usage	`C_INSPPLANPRT.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF`
Control Profile for Management of Production Resources/Tools Client Control Profile for Management of Production Resources/Tools	`C_INSPPLANPRT.MANDT == TCF10.MANDT` `C_INSPPLANPRT.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF`
Standard Text Key for Production Resources/Tools Standard Text Key for Production Resources/Tools Client	`C_INSPPLANPRT.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH` `C_INSPPLANPRT.MANDT == T435.MANDT`
Unit for Quantity of Production Resources/Tools Client Unit for Quantity of Production Resources/Tools	`C_INSPPLANPRT.MANDT == T006.MANDT` `C_INSPPLANPRT.PRODNRSCETOOLSTDWORKQTYUNIT == T006.MSEHI`
Formula for Calculating the Total Quantity of PRT Client Formula for Calculating the Total Quantity of PRT	`C_INSPPLANPRT.MANDT == TC25.MANDT` `C_INSPPLANPRT.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT`
Formula for Calculating the Total Usage Value of PRT Client Formula for Calculating the Total Usage Value of PRT	`C_INSPPLANPRT.MANDT == TC25.MANDT` `C_INSPPLANPRT.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT`
Usage Value Unit of the Production Resource/Tool Usage Value Unit of the Production Resource/Tool Client	`C_INSPPLANPRT.PRODNRSCETOOLUSAGEQUANTITYUNIT == T006.MSEHI` `C_INSPPLANPRT.MANDT == T006.MANDT`
Object ID of the resource Client Object ID of the resource Object types of the CIM resource	`C_INSPPLANPRT.MANDT == CRID.MANDT` `C_INSPPLANPRT.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID` `C_INSPPLANPRT.PRODUCTIONRESOURCETYPE == CRID.OBJTY`
Offset Unit for Start of Prodn Resource/Tool Usage Client Offset Unit for Start of Prodn Resource/Tool Usage	`C_INSPPLANPRT.MANDT == T006.MANDT` `C_INSPPLANPRT.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI`
Reference Date for Start of Production Resource/Tool Usage	`C_INSPPLANPRT.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF`