I_ProdnRsceToolByInternalKey

Production Resource Tool by Internal Key | view: IPPPRTIK | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: CRVD_A, DRAW, CRVE_A, CRVM_A, CRVS_A, CRVP_A, IMPTT, CRFH
Column Name Description
ProductionResourceType Production Resource Type Show values
ProductionResourceInternalID FK Internal ID of Production Resource/Tool
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ProductionResourceType Production Resource Type Show values
Column Name Description Domain name
ProductionResourceTool Production Resource/Tool Number FHMNR
MiscProductionResourceTool Miscellaneous Production Resources and Tools SFHNR
DocumentVersion Document Version DOKVR
DocumentPart Document Part DOKTL
MeasuringPoint Measuring Point IMRC_POINT
Master Data Relations Join Conditions
Document number
  • Document Version
  • Document number
  • Document Part
  • Document Type
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.DOCUMENTVERSION == DRAW.DOKVR
  • I_PRODNRSCETOOLBYINTERNALKEY.DOCUMENTINFORECORD == DRAW.DOKNR
  • I_PRODNRSCETOOLBYINTERNALKEY.DOCUMENTPART == DRAW.DOKTL
  • I_PRODNRSCETOOLBYINTERNALKEY.DOCUMENTTYPE == DRAW.DOKAR
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == DRAW.MANDT
Document Type
  • Document Type
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.DOCUMENTTYPE == TDWA.DOKAR
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == TDWA.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.EQUIPMENT == EQUI.EQUNR
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == EQUI.MANDT
Material Number
  • Material Number
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.MATERIAL == MARA.MATNR
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == MARA.MANDT
Plant
  • Plant
  • Material Number
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.PLANT == MARC.WERKS
  • I_PRODNRSCETOOLBYINTERNALKEY.MATERIAL == MARC.MATNR
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == MARC.MANDT
Production Resources/Tools Category
  • Production Resources/Tools Category
  • Production Resources/Tools Category
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODNRSCETOOLCATEGORY == TCF02.FHMAR
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODNRSCETOOLCATEGORY_2 == TCF02.FHMAR
Production Resources/Tools Category
  • Production Resources/Tools Category
  • Production Resources/Tools Category
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODNRSCETOOLCATEGORY == TCF02.FHMAR
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODNRSCETOOLCATEGORY_2 == TCF02.FHMAR
Internal ID of Production Resource/Tool
  • Production Resource Type
  • Internal ID of Production Resource/Tool
  • Client
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODUCTIONRESOURCETYPE == CRID.OBJTY
  • I_PRODNRSCETOOLBYINTERNALKEY.PRODUCTIONRESOURCEINTERNALID == CRID.OBJID
  • I_PRODNRSCETOOLBYINTERNALKEY.MANDT == CRID.MANDT