ESH_N_MAINTENANCETASKLIST

Anchor view -MAINTENANCETASKLIST | view: ESH_L_MAINTTASKL | Extraction: Not supported | Component: Plant Maintenance
Tables used: ESH_SR_LTXT, PLKO, T412, T412T, TCA01, TCA02, T411, T411T, EQUI, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, T351, T351T, PLKO_TEXT, EAPL, TAPL, CRHD, ITOBCUST, IFLOUSR, T024A
Column Name Description
TaskListType FK Task List Type
TaskListGroup Key for Task List Group
TaskListGroupCounter Group Counter
TaskListVersionCounter Internal counter
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
Column Name Description
Column Name Description Domain name
WorkCenter Work Center ARBPL
TaskListDesc Routing Description TEXT40
MaintenancePlanningPlant Maintenance Planning Plant WERKS
ResponsiblePlannerGroupName Responsible Planner Group Description TEXT30
EquipmentName Description of technical object TEXT40
FunctionalLocationName Description of functional location TEXT40
FuncnlLocPrimaryLabelName Functional Location Label ILOM_STRNO
BillOfOperationsStatusDesc Description of the Status TEXT40
MaintenanceStrategyDesc Description of maintenance strategy TXT30
BillOfOperationsUsageDesc Description TEXT20
BillOfOperationsTypeName Description of the Task List Type TEXT30
PlainLongText Long Text
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • ESH_N_MAINTENANCETASKLIST.ASSEMBLY == MARA.MATNR
  • ESH_N_MAINTENANCETASKLIST.MANDT == MARA.MANDT
Controlling Area
  • Controlling Area
  • Client
  • ESH_N_MAINTENANCETASKLIST.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_N_MAINTENANCETASKLIST.MANDT == TKA01.MANDT
Equipment Number
  • Equipment Number
  • Client
  • ESH_N_MAINTENANCETASKLIST.EQUIPMENT == EQUI.EQUNR
  • ESH_N_MAINTENANCETASKLIST.MANDT == EQUI.MANDT
Name of the functional location for group counter
  • Client
  • Functional Location
  • ESH_N_MAINTENANCETASKLIST.MANDT == IFLOT.MANDT
  • ESH_N_MAINTENANCETASKLIST.FUNCTIONALLOCATION == IFLOT.TPLNR
Maintenance Strategy
  • Client
  • Maintenance Strategy
  • ESH_N_MAINTENANCETASKLIST.MANDT == T351.MANDT
  • ESH_N_MAINTENANCETASKLIST.MAINTENANCESTRATEGY == T351.STRAT
System Condition
  • System Condition
  • Client
  • ESH_N_MAINTENANCETASKLIST.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • ESH_N_MAINTENANCETASKLIST.MANDT == T357M.MANDT
Status
  • Client
  • Status
  • ESH_N_MAINTENANCETASKLIST.MANDT == T412.MANDT
  • ESH_N_MAINTENANCETASKLIST.TASKLISTSTATUS == T412.PLNST
Task List Type
  • Client
  • Task List Type
  • ESH_N_MAINTENANCETASKLIST.MANDT == TCA01.MANDT
  • ESH_N_MAINTENANCETASKLIST.TASKLISTTYPE == TCA01.PLNTY
Task List Usage
  • Task List Usage
  • Client
  • ESH_N_MAINTENANCETASKLIST.TASKLISTUSAGE == T411.VERWE
  • ESH_N_MAINTENANCETASKLIST.MANDT == T411.MANDT
Plant
  • Client
  • Plant
  • ESH_N_MAINTENANCETASKLIST.MANDT == T001W.MANDT
  • ESH_N_MAINTENANCETASKLIST.WORKCENTERPLANT == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Client
  • Responsible Planner Group or Department
  • Plant
  • ESH_N_MAINTENANCETASKLIST.MANDT == T024A.MANDT
  • ESH_N_MAINTENANCETASKLIST.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • ESH_N_MAINTENANCETASKLIST.WORKCENTERPLANT == T024A.WERKS