I_DFS_MaintOrderFuncnlLocStruc

Order Functional Location data | view: IORDERFLSTRUC | Extraction: Not supported | Component: Maintenance (S/4)
Tables used: /ISDFPS/LM_FLIAFIHAFKOJSTOJESTEQUIEQKTEQUZIFLOTIFLOTXILOAAUFKMARAMAKTT356T356_TCRTXTJ02TJ02TTJ30TJ30TCRHDT024I
Column Name Description
Equipment Equipment Number
MaintenanceOrder FK Order Number
Column Name Description
Column Name Description
Column Name Description
MaintOrdBasicEndDate Basic finish date
MaintOrdBasicEndTime Basic Finish (Time)
MaintOrdBasicStartDate Basic Start Date
MaintOrdBasicStartTime Basic Start (Time)
CreationDate Created On
Column Name Description
Column Name Description Domain name
FunctionalLocationName Description of functional location TEXT40
EquipmentName Description of technical object TEXT40
WorkCenterText Work Center Text TEXT40
MaintenanceOrderDesc Description TEXT40
CreatedByUser Entered By USNAM
DfsMaintOrderObjectNmbr Object number J_OBJNR
MainWorkCenter Main work center for maintenance tasks ARBPL
MainWorkCenterPlant Plant associated with main work center WERKS
DfsMaintOrdTechStsShortName Individual status of an object (short form) TEXT4
DfsMaintOrdTechStsLongName Object status TEXT30
DfsMaintOrderUserStsShortName null
DfsMaintOrderSystStsShortName null
DfsMaintOrdTechStatusProfile Status Profile J_STSMA
DfsMaintExplosionType null
DfsMaintEquipmentUtilizerID null
Material Material Number MATNR
MaterialName Material Description TEXT40
MaintenancePlannerGroupName Name of the Maintenance Planner Group TEXT18
MaintPriority Priority PRIOK
MaintPriorityDesc Priority Text TEXT20
DfsMaintTechStsIconURL null
TechObjectWithLeadingZeros null
Master Data Relations Join Conditions
Functional Location
  • Functional Location
  • Client
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.DFSMAINTFUNCTIONALLOCATION == IFLOT.TPLNR
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == IFLOT.MANDT
Maintenance Activity Type
  • Maintenance Activity Type
  • Client
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == T353I.MANDT
Order Number
  • Client
  • Order Number
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == AUFK.MANDT
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MAINTENANCEORDER == AUFK.AUFNR
Order Type
  • Client
  • Order Type
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == T003O.CLIENT
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MAINTENANCEORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == T001W.MANDT
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.PLANT == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • ?
  • Client
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.[column in domain "IWERK"] == T024I.IWERK
  • I_DFS_MAINTORDERFUNCNLLOCSTRUC.MANDT == T024I.MANDT