I_DFS_MaintEquipmentRelshp

Interface view for Equip Relationship | view: IDFSEQUIPREL | Extraction: Not supported | Component: Maintenance (S/4)
Tables used: /ISDFPS/LMEQEXT, EQUI, EQBS, EQUZ, MARA
Column Name Description
Equipment FK Equipment Number
DfsMaintSuperordinateEquipNmbr FK Superordinate Equipment
DfsMaintEquipUsagePerdSqncNmbr Consecutive numbering of EquipUsagePeriods on same day
Column Name Description
Column Name Description
Column Name Description
DfsMaintEquipValidityEndDate Valid To Date
Column Name Description
DfsMaintTechStsAggrgnIsStppd Stop Technical Status Aggregation Here Show values
HasEquipmentData Equipment data exists Show values
Column Name Description Domain name
DfsMaintMasterEquipTechObjNmbr Object number J_OBJNR
DfsMaintEquipmentType null
SerialNumber Serial Number GERNR
UniqueItemIdentifier Unique Item Identifier UII_CHAR72
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • I_DFS_MAINTEQUIPMENTRELSHP.BATCH == MCH1.CHARG
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == MCH1.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.MATERIAL == MCH1.MATNR
Superordinate Equipment
  • Client
  • Superordinate Equipment
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == EQUI.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.DFSMAINTSUPERORDINATEEQUIPNMBR == EQUI.EQUNR
Equipment Number
  • Client
  • Equipment Number
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == EQUI.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.EQUIPMENT == EQUI.EQUNR
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == ILOA.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Material Number
  • Client
  • Material Number
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == MARA.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.MATERIAL == MARA.MATNR
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == T006.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == T023.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == T001W.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.PLANT == T001W.WERKS
Storage location
  • Client
  • Storage location
  • Plant
  • I_DFS_MAINTEQUIPMENTRELSHP.MANDT == T001L.MANDT
  • I_DFS_MAINTEQUIPMENTRELSHP.STORAGELOCATION == T001L.LGORT
  • I_DFS_MAINTEQUIPMENTRELSHP.PLANT == T001L.WERKS