ESH_S_WORKCENTERS

Search view -WORKCENTERS | view: ESH_U_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
COSTCENTERNAME Cost Center Name
PLANTNAME Plant Name TEXT30
PRODUCTIONRESOURCETYPENAME Short Text for Fixed Values
WORKCENTER Work Center ARBPL
WORKCENTERCATEGORYNAME Name of the Work Center Category
WORKCENTERLOCATIONNAME Location Name
WORKCENTERRESPONSIBLENAME Work Center Responsible Name
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • ESH_S_WORKCENTERS.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_S_WORKCENTERS.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • End Date
  • Cost Center
  • Client
  • ESH_S_WORKCENTERS.CONTROLLINGAREA == CSKS.KOKRS
  • ESH_S_WORKCENTERS.VALIDITYENDDATE == CSKS.DATBI
  • ESH_S_WORKCENTERS.COSTCENTER == CSKS.KOSTL
  • ESH_S_WORKCENTERS.MANDT == CSKS.MANDT
Plant
  • Plant
  • Client
  • ESH_S_WORKCENTERS.PLANT == T001W.WERKS
  • ESH_S_WORKCENTERS.MANDT == T001W.MANDT
Work Center Category
  • Work Center Category
  • Client
  • ESH_S_WORKCENTERS.WORKCENTERCATEGORYCODE == TC30.VERWE
  • ESH_S_WORKCENTERS.MANDT == TC30.MANDT
Object ID of the resource
  • Object ID of the resource
  • Client
  • Object types of the CIM resource
  • ESH_S_WORKCENTERS.WORKCENTERINTERNALID == CRID.OBJID
  • ESH_S_WORKCENTERS.MANDT == CRID.MANDT
  • ESH_S_WORKCENTERS.WORKCENTERTYPECODE == CRID.OBJTY
Work center location
  • Work center location
  • Plant
  • Client
  • ESH_S_WORKCENTERS.WORKCENTERLOCATION == T499S.STAND
  • ESH_S_WORKCENTERS.PLANT == T499S.WERKS
  • ESH_S_WORKCENTERS.MANDT == T499S.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Plant
  • Client
  • ESH_S_WORKCENTERS.WORKCENTERRESPONSIBLE == TC24.VERAN
  • ESH_S_WORKCENTERS.PLANT == TC24.WERKS
  • ESH_S_WORKCENTERS.MANDT == TC24.MANDT