ESH_S_MAINTENANCEITEM

DDL: ESH_S_MAINTENANCEITEM SQL: ESH_U_MAINTITEM Type: view
41 Fields 1 Data Sources

ESH_S_MAINTENANCEITEM is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_MAINTENANCEITEM) and exposes 41 fields with key field MaintenanceItem.

Data Sources (1)

SourceAliasJoin Type
ESH_N_MAINTENANCEITEM ESH_N_MAINTENANCEITEM from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
ObjectModel.sapObjectNodeType.name MaintenanceItem view
UI.headerInfo.typeName Maintenance Item view
UI.headerInfo.typeNamePlural Maintenance Items view
Consumption.semanticObject MaintenanceItem view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value MAINTENANCEITEM view
AbapCatalog.sqlViewName ESH_U_MAINTITEM view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem Maintenance Item
FunctionalLocation FunctionalLocation Functional Location Internal ID
EquipmentName EquipmentName Equipment Description
OperationSystemConditionText OperationSystemConditionText Operating Condition Text
WorkCenter WorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Work Center Plant
FuncnlLocPrimaryLabelName FuncnlLocPrimaryLabelName Functional Location - primary label
FuncLocLabel Functional Location
FunctionalLocationName FunctionalLocationName Functional Location Description
TaskListGroupCounter TaskListGroupCounter Group Counter
TaskListGroup TaskListGroup Group
TaskListType TaskListType Task List Type
MaintObjectCategory MaintObjectCategory Maintenance Item Category
OperationSystemCondition OperationSystemCondition SystemCondition
Material Material Vehicle Model
MaintenanceActivityType MaintenanceActivityType Maintenance Activity Type
MaintenanceOrder MaintenanceOrder Last Order
MaintPriority MaintPriority Priority
MaintenanceNotification MaintenanceNotification Notification
MaintenancePlan MaintenancePlan Maintenance Plan
MaintenanceItemDescription MaintenanceItemDescription Maintenance Item Description
LastChangedByUser LastChangedByUser User Name
CreatedByUser CreatedByUser User Name
Assembly Assembly Pegged Reqmt
Equipment Equipment Equipment check
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenanceStrategy MaintenanceStrategy Strategy
MaintenancePlanCategory MaintenancePlanCategory Maintenance Plan Category
MaintenanceActivityTypeName MaintenanceActivityTypeName Activity Type Description
NotificationText NotificationText Description
MaintenancePlannerGroupName MaintenancePlannerGroupName Planner Group Name
MaintenanceStrategyDesc MaintenanceStrategyDesc Strategy Description
TaskListDesc TaskListDesc Task List Description
AUTHORIZATIONGROUPEQ AUTHORIZATIONGROUPEQ Authorization Group Equipment
AUTHORIZATIONGROUPFL AUTHORIZATIONGROUPFL Authorization Group Functional Location
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
MaintenancePlant MaintenancePlant Plant
MaintenancePlanCallObject MaintenancePlanCallObject
PlainLongText PlainLongText Long Texts

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view ESH_S_MAINTENANCEITEM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ESH_U_MAINTITEM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_MAINTENANCEITEM AS
SELECT
  MaintenanceItem,
  FunctionalLocation,
  EquipmentName,
  OperationSystemConditionText,
  WorkCenter,
  MainWorkCenterPlant,
  FuncnlLocPrimaryLabelName,
  coalesce( FuncnlLocPrimaryLabelName, FunctionalLocation ) AS FuncLocLabel,
  FunctionalLocationName,
  TaskListGroupCounter,
  TaskListGroup,
  TaskListType,
  MaintObjectCategory,
  OperationSystemCondition,
  Material,
  MaintenanceActivityType,
  MaintenanceOrder,
  MaintPriority,
  MaintenanceNotification,
  MaintenancePlan,
  MaintenanceItemDescription,
  LastChangedByUser,
  CreatedByUser,
  Assembly,
  Equipment,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  MaintenanceActivityTypeName,
  NotificationText,
  MaintenancePlannerGroupName,
  MaintenanceStrategyDesc,
  TaskListDesc,
  AUTHORIZATIONGROUPEQ,
  AUTHORIZATIONGROUPFL,
  ControllingArea,
  CostCenter,
  MaintenancePlant,
  MaintenancePlanCallObject,
  PlainLongText
FROM ESH_N_MAINTENANCEITEM
;

Learn More