ESH_S_EQUIPMENT

Search view - Equipment | view: ESH_U_EQUIPMENT | Extraction: Not supported | Component: Plant Maintenance
Tables used: ESH_SR_LTXT, CABN, CABNT, CAWN, CAWNT, KLAH, SWOR, AUSP, KSSK, CSKS, CSKT, T370U, EQUI, T370T, EQKT, EQUZ, IFLOS, IFLOT, IFLOTX, ILOA, T001W, T001W, CRTX, T370K, T370K_T, CRHD, CLF_HDR, ITOBCUST, IFLOUSR, T399I
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Equipment Equipment Number EQUNR
PRODWORKCENTER Work Center
PlanningPlantName Name
TechnicalObjectTypeDesc Text for Object Type
EquipmentCategoryDesc Equipment category description
EquipmentName Description of technical object
AssetManufacturerName Manufacturer of Asset
MaintObjectFreeDefinedAttrib Sort Field CHAR30
CostCenterName Cost Center Name TEXT20
MaintPlantName Plant Name
FuncnlLocPrimaryLabelName Functional Location Label
FuncLocLabel null
WorkCenterText Work Center Text
MaintWorkCenter Work Center
PlainLongText Long Text
LongTextIntNote Long Text
SuperiorEquiName Description of technical object
SuperiorFLocName Description of functional location
SerialNumber Equipment Number
CharcValue Characteristic Value
CharcFromNumericValue Internal floating point from
CharcToNumericValue Internal floating point value to
Class Class number
Characteristic Characteristic Name
ClassDescription Class Description
CharcDescription Characteristic Description
CharcValueDescription Characteristic value description
TechnicalObjectLabel Technical Object
TechObjIsEquipOrFuncnlLoc Technical Object Type
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • ESH_S_EQUIPMENT.ABCINDICATOR == T370C.ABCKZ
  • ESH_S_EQUIPMENT.MANDT == T370C.MANDT
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_S_EQUIPMENT.AUTHORIZATIONGROUP == T370B.BEGRU
  • ESH_S_EQUIPMENT.MANDT == T370B.MANDT
Class Type
  • Class Type
  • Client
  • ESH_S_EQUIPMENT.CLASSTYPE == TCLA.KLART
  • ESH_S_EQUIPMENT.MANDT == TCLA.MANDT
Construction type material of the object
  • Client
  • Construction type material of the object
  • ESH_S_EQUIPMENT.MANDT == MARA.MANDT
  • ESH_S_EQUIPMENT.CONSTRUCTIONMATERIAL == MARA.MATNR
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • ESH_S_EQUIPMENT.COSTCENTER == CSKS.KOSTL
  • ESH_S_EQUIPMENT.[column in domain "DATBI"] == CSKS.DATBI
  • ESH_S_EQUIPMENT.[column in domain "KOKRS"] == CSKS.KOKRS
  • ESH_S_EQUIPMENT.MANDT == CSKS.MANDT
Equipment category
  • Equipment category
  • Client
  • ESH_S_EQUIPMENT.EQUIPMENTCATEGORY == T370T.EQTYP
  • ESH_S_EQUIPMENT.MANDT == T370T.MANDT
Functional Location
  • Client
  • Functional Location
  • ESH_S_EQUIPMENT.MANDT == IFLOT.MANDT
  • ESH_S_EQUIPMENT.FUNCTIONALLOCATION == IFLOT.TPLNR
Location of maintenance object
  • Maintenance Plant
  • Location of maintenance object
  • Client
  • ESH_S_EQUIPMENT.MAINTENANCEPLANT == T499S.WERKS
  • ESH_S_EQUIPMENT.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • ESH_S_EQUIPMENT.MANDT == T499S.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • ESH_S_EQUIPMENT.MAINTENANCEPLANT == T001W.WERKS
  • ESH_S_EQUIPMENT.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • ESH_S_EQUIPMENT.MATERIAL == MARA.MATNR
  • ESH_S_EQUIPMENT.MANDT == MARA.MANDT
Superior functional location
  • Superior functional location
  • Client
  • ESH_S_EQUIPMENT.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
  • ESH_S_EQUIPMENT.MANDT == IFLOT.MANDT
Superordinate Equipment
  • Superordinate Equipment
  • Client
  • ESH_S_EQUIPMENT.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
  • ESH_S_EQUIPMENT.MANDT == EQUI.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • ESH_S_EQUIPMENT.TECHNICALOBJECTTYPE == T370K.EQART
  • ESH_S_EQUIPMENT.MANDT == T370K.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • Client
  • ESH_S_EQUIPMENT.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • ESH_S_EQUIPMENT.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • ESH_S_EQUIPMENT.MANDT == T024I.MANDT
Maintenance planning plant
  • Maintenance Planning Plant
  • Client
  • ESH_S_EQUIPMENT.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • ESH_S_EQUIPMENT.MANDT == T399I.MANDT