ESH_N_EQUIPMENT

Anchor view -EQUIPMENT | view: ESH_L_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
Equipment Equipment Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PRODWORKCENTER Work Center ARBPL
PlanningPlantName Name TEXT30
TechnicalObjectTypeDesc Text for Object Type TEXT20
EquipmentCategoryDesc Equipment category description TEXT30
EquipmentName Description of technical object TEXT40
AssetManufacturerName Manufacturer of Asset TEXT30
MaintObjectFreeDefinedAttrib Sort Field CHAR30
CostCenterName Cost Center Name TEXT20
MaintPlantName Plant Name TEXT30
FuncnlLocPrimaryLabelName Functional Location Label ILOM_STRNO
WorkCenterText Work Center Text TEXT40
MaintWorkCenter Work Center ARBPL
PlainLongText Long Text
LongTextIntNote Long Text
SuperiorEquiName Description of technical object TEXT40
SuperiorFLocName Description of functional location TEXT40
SerialNumber Equipment Number EQUNR
CharcValue Characteristic Value ATWRT
CharcValueDescription Characteristic value description ATWRT
CharcFromNumericValue Internal floating point from FLTP
CharcToNumericValue Internal floating point value to FLTP
Characteristic Characteristic Name ATNAM
CharcDescription Characteristic Description TEXT30
Class Class number KLASSE
ClassInternalID Internal Class Number CLINT
ClassDescription Class Description TEXT40
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • Client
  • ABC Indicator for Technical Object
  • ESH_N_EQUIPMENT.MANDT == T370C.MANDT
  • ESH_N_EQUIPMENT.ABCINDICATOR == T370C.ABCKZ
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • ESH_N_EQUIPMENT.AUTHORIZATIONGROUP == T370B.BEGRU
  • ESH_N_EQUIPMENT.MANDT == T370B.MANDT
Class Type
  • Client
  • Class Type
  • ESH_N_EQUIPMENT.MANDT == TCLA.MANDT
  • ESH_N_EQUIPMENT.CLASSTYPE == TCLA.KLART
Construction type material of the object
  • Client
  • Construction type material of the object
  • ESH_N_EQUIPMENT.MANDT == MARA.MANDT
  • ESH_N_EQUIPMENT.CONSTRUCTIONMATERIAL == MARA.MATNR
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • ESH_N_EQUIPMENT.MANDT == CSKS.MANDT
  • ESH_N_EQUIPMENT.[column in domain "KOKRS"] == CSKS.KOKRS
  • ESH_N_EQUIPMENT.[column in domain "DATBI"] == CSKS.DATBI
  • ESH_N_EQUIPMENT.COSTCENTER == CSKS.KOSTL
Equipment category
  • Client
  • Equipment category
  • ESH_N_EQUIPMENT.MANDT == T370T.MANDT
  • ESH_N_EQUIPMENT.EQUIPMENTCATEGORY == T370T.EQTYP
Functional Location
  • Client
  • Functional Location
  • ESH_N_EQUIPMENT.MANDT == IFLOT.MANDT
  • ESH_N_EQUIPMENT.FUNCTIONALLOCATION == IFLOT.TPLNR
Location of maintenance object
  • Client
  • Location of maintenance object
  • Maintenance Plant
  • ESH_N_EQUIPMENT.MANDT == T499S.MANDT
  • ESH_N_EQUIPMENT.MAINTENANCEOBJECTLOCATION == T499S.STAND
  • ESH_N_EQUIPMENT.MAINTENANCEPLANT == T499S.WERKS
Maintenance Plant
  • Client
  • Maintenance Plant
  • ESH_N_EQUIPMENT.MANDT == T001W.MANDT
  • ESH_N_EQUIPMENT.MAINTENANCEPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • ESH_N_EQUIPMENT.MANDT == MARA.MANDT
  • ESH_N_EQUIPMENT.MATERIAL == MARA.MATNR
Superior functional location
  • Client
  • Superior functional location
  • ESH_N_EQUIPMENT.MANDT == IFLOT.MANDT
  • ESH_N_EQUIPMENT.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
Superordinate Equipment
  • Client
  • Superordinate Equipment
  • ESH_N_EQUIPMENT.MANDT == EQUI.MANDT
  • ESH_N_EQUIPMENT.SUPERORDINATEEQUIPMENT == EQUI.EQUNR
Type of Technical Object
  • Client
  • Type of Technical Object
  • ESH_N_EQUIPMENT.MANDT == T370K.MANDT
  • ESH_N_EQUIPMENT.TECHNICALOBJECTTYPE == T370K.EQART
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • Planner Group for Customer Service and Plant Maintenance
  • ESH_N_EQUIPMENT.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • ESH_N_EQUIPMENT.MANDT == T024I.MANDT
  • ESH_N_EQUIPMENT.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance planning plant
  • Maintenance Planning Plant
  • Client
  • ESH_N_EQUIPMENT.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • ESH_N_EQUIPMENT.MANDT == T399I.MANDT