I_ProdnRsceToolMasterData

Production Resource Tool Master Data | view: IPPPRTMD | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: CRFH
Column Name Description
ProductionResourceType Production Resource Type Show values
ProductionResourceInternalID FK Internal ID of Production Resource/Tool
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
CreationDate Date Record Created On
LastChangeDate Last Changed On
Column Name Description
ProductionResourceType Production Resource Type Show values
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
CreatedByUser Created By User XUBNAME
LastChangedByUser Name of Person Who Changed Object USNAM
ShopFloorRtgPRTIsRegistrable Specifies that the PRT can be Registered in Execution
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • I_PRODNRSCETOOLMASTERDATA.CHANGENUMBER == AENR.AENNR
  • I_PRODNRSCETOOLMASTERDATA.MANDT == AENR.MANDT
Offset Unit for End of Production Resource/Tool Usage
  • Offset Unit for End of Production Resource/Tool Usage
  • Client
  • I_PRODNRSCETOOLMASTERDATA.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_PRODNRSCETOOLMASTERDATA.MANDT == T006.MANDT
Reference Date for End of PRT Usage I_PRODNRSCETOOLMASTERDATA.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Authorization Group
  • Authorization Group
  • Client
  • ?
  • I_PRODNRSCETOOLMASTERDATA.MISCPRTAUTHORIZATIONGROUP == TBRG.BRGRU
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TBRG.MANDT
  • I_PRODNRSCETOOLMASTERDATA.[column in domain "BROBJ"] == TBRG.BROBJ
Base Unit of Measure for Production Resources/Tools
  • Base Unit of Measure for Production Resources/Tools
  • Client
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLBASEUNIT == T006.MSEHI
  • I_PRODNRSCETOOLMASTERDATA.MANDT == T006.MANDT
Production Resources/Tools Category
  • Production Resources/Tools Category
  • Production Resources/Tools Category
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLCATEGORY == TCF02.FHMAR
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLCATEGORY_2 == TCF02.FHMAR
Production Resources/Tools Category
  • Production Resources/Tools Category
  • Production Resources/Tools Category
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLCATEGORY == TCF02.FHMAR
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLCATEGORY_2 == TCF02.FHMAR
Control Profile for Management of Production Resources/Tools
  • Control Profile for Management of Production Resources/Tools
  • Client
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLCONTROLPROFILE == TCF10.STEUF
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TCF10.MANDT
Standard Text Key for Production Resources/Tools
  • Standard Text Key for Production Resources/Tools
  • Client
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLSTANDARDTEXTCODE == T435.VLSCH
  • I_PRODNRSCETOOLMASTERDATA.MANDT == T435.MANDT
Formula for Calculating the Total Quantity of PRT
  • Client
  • Formula for Calculating the Total Quantity of PRT
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TC25.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLTOTQTYCALCFORMULA == TC25.IDENT
Formula for Calculating the Total Usage Value of PRT
  • Client
  • Formula for Calculating the Total Usage Value of PRT
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TC25.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODNRSCETOOLUSAGEQTYCALCFMLA == TC25.IDENT
Internal ID of Production Resource/Tool
  • Internal ID of Production Resource/Tool
  • Client
  • Production Resource Type
  • I_PRODNRSCETOOLMASTERDATA.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID
  • I_PRODNRSCETOOLMASTERDATA.MANDT == CRID.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODUCTIONRESOURCETYPE == CRID.OBJTY
Grouping Key 1 for Production Resources/Tools
  • Client
  • Grouping Key 1 for Production Resources/Tools
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TCF12.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODUCTIONRESOURCETOOLGROUP1 == TCF12.FGRUA
Grouping Key 2 for Production Resources/Tools
  • Client
  • Grouping Key 2 for Production Resources/Tools
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TCF12.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODUCTIONRESOURCETOOLGROUP2 == TCF12.FGRUA
Production Resource/Tool Usage
  • Client
  • Production Resource/Tool Usage
  • I_PRODNRSCETOOLMASTERDATA.MANDT == TC23.MANDT
  • I_PRODNRSCETOOLMASTERDATA.PRODUCTIONRESOURCEUSAGE == TC23.PLANV
Offset Unit for Start of Prodn Resource/Tool Usage
  • Offset Unit for Start of Prodn Resource/Tool Usage
  • Client
  • I_PRODNRSCETOOLMASTERDATA.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_PRODNRSCETOOLMASTERDATA.MANDT == T006.MANDT
Reference Date for Start of PRT Usage I_PRODNRSCETOOLMASTERDATA.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF