I_DFS_MaintCritlEquipStructure

Critical Equipment Structure | view: IDFSCEQSTRUC | Extraction: Not supported | Component: Maintenance (S/4)
Tables used: DFS_ASSGMT, JSTO, JEST, /ISDFPS/LMAREA, /ISDFPS/LMSITE, /ISDFPS/LMEQEXT, /ISDFPS/CLMMDID, /ISDFPS/CLMMDIDT, /ISDFPS/LM_EINR, /ISDFPS/LM_EINRT, /ISDFPS/CLMSMIDT, EQUI, EQBS, EQKT, EQUZ, DFS_FMPO_HEAD, DFS_FMPO_HEAD_T, /ISDFPS/RIC_CATL, DFS_FMPO_VARNT_T, DFS_FMPO_VARNT, DFS_FMPO_MODEL, T777S, T778S, USR02, DFS_FE_STRUCAUTH, IFLOT, IFLOTX, ILOA, MARA, MAKT, CRTX, TJ20, TJ20T, TJ02, TJ02T, USR01, TJ30, TJ30T, CRHD, /ISDFPS/FORCE, HRP1950, HRP1000, /ISDFPS/CLMSTIC, T77UA
Column Name Description
Equipment Equipment Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DfsMaintTechStsAggrgnIsStppd Stop Technical Status Aggregation Here Show values
Column Name Description Domain name
DfsMaintFunctionalLocation null
DfsMaintEquipTechStatusProfile Status Profile J_STSMA
DfsMaintSuperordinateEquipNmbr Superordinate Equipment EQUNR
DfsMaintEquipmentType null
FunctionalLocationName Description of functional location TEXT40
EquipmentName Description of technical object TEXT40
SuperordinateEquipment null
DfsMaintSuperordinateEquipName Description of technical object TEXT40
DfsMaintTailNumber Tail Number/Identifier /ISDFPS/DO_LM_DEVICE_ID
DfsMaintRemarkText Remark /ISDFPS/DO_LM_TEXT60
DfsMaintActualConfiguration Actual Configuration /ISDFPS/DO_LM_SETUP
DfsMaintForeignEquipIdfgText null
DfsMaintUsagePrefPriority Usage Preference Priority /ISDFPS/DO_LM_PRIO
DfsMaintEquipOplObjNmbr Object number J_OBJNR
DfsMaintMasterEquipTechObjNmbr Object number J_OBJNR
DfsMaintModelIdentification Model ID/Weapon System /ISDFPS/DO_LM_MODEL_ID
DfsMaintSiteID Site /ISDFPS/DO_LM_SITE_ID
DfsMaintSiteDescription Language-Independent Description of Site or Area /ISDFPS/DO_LM_TEXT60
DfsMaintEquipOplStsShrtName null
DfsMaintEquipOplStatusProfile Status Profile J_STSMA
DfsMaintEquipTechStsShrtName null
DfsMaintEquipTechStsLongName null
DfsMaintModelDescription Model Description /ISDFPS/DO_LM_TEXT50
DfsMaintMaterialSerialNumber null
MaintObjectInternalID Object number J_OBJNR
DfsMaintOperationalRole Operational Role /ISDFPS/DO_LM_SETUP_POOL
DfsMaintOperationalRoleDesc Description TEXT60
FlxMtPlObjRIC Reportable Item Code /ISDFPS/RICODE
FlxMtPlObjRICDescription RIC Description /ISDFPS/RIC_DESCRIPTION
FlxblMatlPlngObjectID Flexible Material Planning Object DFS_FMPOID
FlxblMatlPlngObjDescription Flexible Material Planning Object Description TEXT60
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
DfsMaintEquipmentUtilizerID null
DfsMaintEquipmentUtilizerName Object Name TEXT40
DfsMaintCriticalityText null
DfsMaintNumberOfNotifications null
DfsMaintNumberOfWorkOrders null
DfsMaintExplosionType null
DfsMaintFrcElmntOrgRoleText null
DfsMaintOplStsIconURL null
DfsMaintTechStsIconURL null
DfsMaintEquipUserStsShortName null
DfsMaintEquipSystStsShortName null
DfsMaintTechStsAggrgnExecText null
TechObjectWithLeadingZeros null
Master Data Relations Join Conditions
Icon I_DFS_MAINTCRITLEQUIPSTRUCTURE.DFSMAINTEQUIPSTATUSICON == ICON.ID
Storage location
  • ?
  • Storage location
  • Client
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.[column in domain "WERKS_D"] == T001L.WERKS
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.DFSMAINTEQUIPSTORAGELOCATION == T001L.LGORT
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MANDT == T001L.MANDT
MRP Stock Area
  • MRP Stock Area
  • Client
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.FRCELMNTORGMRPSTOCKAREA == MDLV.BERID
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MANDT == MDLV.MANDT
Provisions MRP Area
  • Client
  • Provisions MRP Area
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MANDT == MDLV.MANDT
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.FRCELMNTORGPRVSNMRPAREA == MDLV.BERID
Material Number
  • Client
  • Material Number
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MANDT == MARA.MANDT
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.MANDT == T001W.MANDT
  • I_DFS_MAINTCRITLEQUIPSTRUCTURE.PLANT == T001W.WERKS