I_ProductPRTByInternalKeyTP

BO Node : Product Resource Tool | view: IPRDPRTTP | Extraction: Not supported | Component: Material Master

Tables used: CRVM_A, CRFH

🔑 Keys (2)
💰 Amounts
∑ Quantities (2)
📅 Dates
☰ Categorical (8)
Other (1)
🔗 Relations (14)

Column Name	Description
Product FK	Product Number
Plant FK	Plant

Column Name	Description

Column Name	Description
📏 Offset Unit for Start of Prodn Resource/Tool Usage (StartDateOffsetDurationUnit):
StartDateOffsetDuration	Offset to Start of PRT Usage
📏 Offset Unit for End of Production Resource/Tool Usage (EndDateOffsetDurationUnit):
EndDateOffsetDuration	Offset to End of PRT Usage

Column Name	Description

Column Name	Description
EndDateOffsetDurnIsReferenced	Offset to End of PRT Usage is Referenced	Show values
StartDateOffstDurnIsReferenced	Offset to Start of PRT Usage is Referenced	Show values
EndDteOffstRefCodeIsReferenced	Reference Date for End of PRT Usage is Referenced	Show values
StartDateOffsetRefCodeIsRefcd	Reference Date for Start of PRT Usage is Referenced	Show values
PRTTotQtyCalcFmlaIsReferenced	Formula for Calculating the Total PRT Quantity is Referenced	Show values
PRTUsgeQtyCalcFmlaIsReferenced	Formula for Calculating Total PRT Usage Value is Referenced	Show values
PRTControlProfileIsReferenced	Control Profile for Management of PRT is Referenced	Show values
PRTStdTextCodeIsReferenced	Standard Text Key for PRT is Referenced	Show values

Column Name	Description	Domain name
ShopFloorRtgPRTIsRegistrable	Specifies that the PRT can be Registered in Execution

Master Data Relations	Join Conditions
Offset Unit for End of Production Resource/Tool Usage Offset Unit for End of Production Resource/Tool Usage Client	`I_PRODUCTPRTBYINTERNALKEYTP.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == T006.MANDT`
Reference Date for End of PRT Usage	`I_PRODUCTPRTBYINTERNALKEYTP.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF`
Plant Product Number Plant Plant Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODUCT == MARC.MATNR` `I_PRODUCTPRTBYINTERNALKEYTP.PLANT == MARC.WERKS` `I_PRODUCTPRTBYINTERNALKEYTP.PLANTFOREDIT == MARC.WERKS` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == MARC.MANDT`
Plant Product Number Plant Plant Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODUCT == MARC.MATNR` `I_PRODUCTPRTBYINTERNALKEYTP.PLANT == MARC.WERKS` `I_PRODUCTPRTBYINTERNALKEYTP.PLANTFOREDIT == MARC.WERKS` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == MARC.MANDT`
Control Profile for Management of Production Resources/Tools Control Profile for Management of Production Resources/Tools Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TCF10.MANDT`
Standard Text Key for Production Resources/Tools Standard Text Key for Production Resources/Tools Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == T435.MANDT`
Formula for Calculating the Total Quantity of PRT Formula for Calculating the Total Quantity of PRT Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TC25.MANDT`
Formula for Calculating the Total Usage Value of PRT Formula for Calculating the Total Usage Value of PRT Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TC25.MANDT`
Product Number Product Number Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODUCT == MARA.MATNR` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == MARA.MANDT`
Grouping Key 1 for Production Resources/Tools Grouping Key 1 for Production Resources/Tools Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODUCTIONRESOURCETOOLGROUP1 == TCF12.FGRUA` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TCF12.MANDT`
Grouping Key 2 for Production Resources/Tools Grouping Key 2 for Production Resources/Tools Client	`I_PRODUCTPRTBYINTERNALKEYTP.PRODUCTIONRESOURCETOOLGROUP2 == TCF12.FGRUA` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TCF12.MANDT`
Production Resource/Tool Usage Client Production Resource/Tool Usage	`I_PRODUCTPRTBYINTERNALKEYTP.MANDT == TC23.MANDT` `I_PRODUCTPRTBYINTERNALKEYTP.PRODUCTIONRESOURCEUSAGE == TC23.PLANV`
Offset Unit for Start of Prodn Resource/Tool Usage Offset Unit for Start of Prodn Resource/Tool Usage Client	`I_PRODUCTPRTBYINTERNALKEYTP.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI` `I_PRODUCTPRTBYINTERNALKEYTP.MANDT == T006.MANDT`
Reference Date for Start of PRT Usage	`I_PRODUCTPRTBYINTERNALKEYTP.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF`