ESH_S_RESOURCES

Search view -RESOURCES | view: ESH_U_RESOURCES | Extraction: Not supported | Component: Process Order
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
WORKCENTERCATEGORYNAME Name of the Work Center Category
WORKCENTERLOCATIONNAME Location Name
WORKCENTERRESPONSIBLENAME Work Center Responsible Name
WORKCENTERTEXT Work Center Text
Master Data Relations Join Conditions
Controlling Area
  • Controlling Area
  • Client
  • ESH_S_RESOURCES.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_S_RESOURCES.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • End Date
  • Client
  • ESH_S_RESOURCES.CONTROLLINGAREA == CSKS.KOKRS
  • ESH_S_RESOURCES.COSTCENTER == CSKS.KOSTL
  • ESH_S_RESOURCES.VALIDITYENDDATE == CSKS.DATBI
  • ESH_S_RESOURCES.MANDT == CSKS.MANDT
Plant
  • Plant
  • Client
  • ESH_S_RESOURCES.PLANT == T001W.WERKS
  • ESH_S_RESOURCES.MANDT == T001W.MANDT
Work Center Category
  • Client
  • Work Center Category
  • ESH_S_RESOURCES.MANDT == TC30.MANDT
  • ESH_S_RESOURCES.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • ESH_S_RESOURCES.WORKCENTERINTERNALID == CRID.OBJID
  • ESH_S_RESOURCES.WORKCENTERTYPECODE == CRID.OBJTY
  • ESH_S_RESOURCES.MANDT == CRID.MANDT
Work center location
  • Plant
  • Client
  • Work center location
  • ESH_S_RESOURCES.PLANT == T499S.WERKS
  • ESH_S_RESOURCES.MANDT == T499S.MANDT
  • ESH_S_RESOURCES.WORKCENTERLOCATION == T499S.STAND
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Plant
  • Client
  • ESH_S_RESOURCES.WORKCENTERRESPONSIBLE == TC24.VERAN
  • ESH_S_RESOURCES.PLANT == TC24.WERKS
  • ESH_S_RESOURCES.MANDT == TC24.MANDT