ESH_N_WORKCENTERS

Anchor view -WORKCENTERS | view: ESH_L_WORKCENTER | Extraction: Not supported | Component: Production Orders
Tables used: TKA01CSKSCSKTT499ST001WCRTXT000CRHDTC30TC30TCRCOTC24
Column Name Description
WORKCENTERINTERNALID FK Object ID of the resource
WORKCENTERTYPECODE Object types of the CIM resource Show values
Column Name Description
Column Name Description
Column Name Description
VALIDITYENDDATE End Date
VALIDITYSTARTDATE Start Date
Column Name Description
WORKCENTERTYPECODE Object types of the CIM resource Show values
WORKCENTERISTOBEDELETED Deletion flag for work center Show values
Column Name Description Domain name
CONTROLLINGAREANAME Controlling Area Name TEXT25
COSTCENTERNAME Cost Center Name TEXT20
PLANTNAME Plant Name TEXT30
PRODUCTIONRESOURCETYPENAME Short Text for Fixed Values DDTEXT
WORKCENTER Work Center ARBPL
WORKCENTERCATEGORYNAME Name of the Work Center Category TEXT20
WORKCENTERLOCATIONNAME Location Name TEXT40
WORKCENTERRESPONSIBLENAME Work Center Responsible Name TEXT40
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • ESH_N_WORKCENTERS.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_N_WORKCENTERS.MANDT == TKA01.MANDT
Cost Center
  • End Date
  • Controlling Area
  • Cost Center
  • Client
  • ESH_N_WORKCENTERS.VALIDITYENDDATE == CSKS.DATBI
  • ESH_N_WORKCENTERS.CONTROLLINGAREA == CSKS.KOKRS
  • ESH_N_WORKCENTERS.COSTCENTER == CSKS.KOSTL
  • ESH_N_WORKCENTERS.MANDT == CSKS.MANDT
Plant
  • Plant
  • Client
  • ESH_N_WORKCENTERS.PLANT == T001W.WERKS
  • ESH_N_WORKCENTERS.MANDT == T001W.MANDT
Work Center Category
  • Work Center Category
  • Client
  • ESH_N_WORKCENTERS.WORKCENTERCATEGORYCODE == TC30.VERWE
  • ESH_N_WORKCENTERS.MANDT == TC30.MANDT
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • ESH_N_WORKCENTERS.WORKCENTERINTERNALID == CRID.OBJID
  • ESH_N_WORKCENTERS.WORKCENTERTYPECODE == CRID.OBJTY
  • ESH_N_WORKCENTERS.MANDT == CRID.MANDT
Work center location
  • Plant
  • Work center location
  • Client
  • ESH_N_WORKCENTERS.PLANT == T499S.WERKS
  • ESH_N_WORKCENTERS.WORKCENTERLOCATION == T499S.STAND
  • ESH_N_WORKCENTERS.MANDT == T499S.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Plant
  • Person Responsible for the Work Center
  • Client
  • ESH_N_WORKCENTERS.PLANT == TC24.WERKS
  • ESH_N_WORKCENTERS.WORKCENTERRESPONSIBLE == TC24.VERAN
  • ESH_N_WORKCENTERS.MANDT == TC24.MANDT