I_DFS_MaintEquipmentList

Interface view for Equipment List | view: IDFSEQUILIST | Extraction: Not supported | Component: Maintenance (S/4)
Tables used: JSTO, JEST, ILOA, /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
FunctionalLocation null
DfsMaintEquipTechStatusProfile Status Profile J_STSMA
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.MATERIAL == MCH1.MATNR
  • I_DFS_MAINTEQUIPMENTLIST.BATCH == MCH1.CHARG
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == MCH1.MANDT
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.DFSMAINTSUPERORDINATEEQUIPNMBR == EQUI.EQUNR
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == EQUI.MANDT
Equipment Number
  • Client
  • Equipment Number
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == EQUI.MANDT
  • I_DFS_MAINTEQUIPMENTLIST.EQUIPMENT == EQUI.EQUNR
Location and account assignment for technical object
  • Location and account assignment for technical object
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == ILOA.MANDT
Material Number
  • Material Number
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.MATERIAL == MARA.MATNR
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == MARA.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == T006.MANDT
  • I_DFS_MAINTEQUIPMENTLIST.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Material Group
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.MATERIALGROUP == T023.MATKL
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.PLANT == T001W.WERKS
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == T001W.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_DFS_MAINTEQUIPMENTLIST.PLANT == T001L.WERKS
  • I_DFS_MAINTEQUIPMENTLIST.STORAGELOCATION == T001L.LGORT
  • I_DFS_MAINTEQUIPMENTLIST.MANDT == T001L.MANDT