ESH_N_MAINTENANCEITEM

DDL: ESH_N_MAINTENANCEITEM SQL: ESH_L_MAINTITEM Type: view
40 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_MaintenanceItemSearch P_MaintenanceItemSearch from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (9)

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.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MAINTITEM view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem MaintItem
FunctionalLocation _LocationAccountAssignment FunctionalLocation Object ID
EquipmentName
OperationSystemConditionText
WorkCenter _MainWorkCenter WorkCenter Work Center
MainWorkCenterPlant _MainWorkCenter Plant Valuation Area
FuncnlLocPrimaryLabelName
FunctionalLocationName
TaskListGroupCounter TaskListGroupCounter Group Counter
TaskListGroup TaskListGroup Group
TaskListType TaskListType Task List Type
MaintObjectCategory MaintObjectCategory Object Type
OperationSystemCondition OperationSystemCondition SystemCondition
Material Material Vehicle Model
MaintenanceActivityType MaintenanceActivityType MaintActivType
MaintenanceOrder MaintenanceOrder Order
MaintPriority MaintPriority Priority
MaintenanceNotification MaintenanceNotification Notification
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenanceItemDescription MaintenanceItemDescription MaintItem text
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
MaintenancePlanCategory MaintenancePlanCategory
MaintenanceActivityTypeName
NotificationText _MaintenanceNotification NotificationText Description
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
MaintenanceStrategyDesc
TaskListDesc _MaintenanceTaskList TaskListDesc
AUTHORIZATIONGROUPEQ _Equipment AuthorizationGroup AuthorizGroup
AUTHORIZATIONGROUPFL
ControllingArea _LocationAccountAssignment ControllingArea Controlling Area
CostCenter _LocationAccountAssignment CostCenter Cost Center
MaintenancePlant _LocationAccountAssignment MaintenancePlant Plant
MaintenancePlanCallObject MaintenancePlanCallObject
PlainLongText

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_N_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_L_MAINTITEM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_MAINTENANCEITEM AS
SELECT
  MaintenanceItem,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _Equipment._EquipmentText[1: Language = $parameters.P_Language ].EquipmentName AS EquipmentName,
  _MaintOperationSystCondition._Text[1: Language = $parameters.P_Language ].OperationSystemConditionText AS OperationSystemConditionText,
  _MainWorkCenter.WorkCenter AS WorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  _LocationAccountAssignment._FunctionalLocation._FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName,
  _LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[1: Language = $parameters.P_Language ].FunctionalLocationName AS FunctionalLocationName,
  TaskListGroupCounter,
  TaskListGroup,
  TaskListType,
  MaintObjectCategory,
  OperationSystemCondition,
  Material,
  MaintenanceActivityType,
  MaintenanceOrder,
  MaintPriority,
  MaintenanceNotification,
  MaintenancePlan,
  MaintenanceItemDescription,
  LastChangedByUser,
  CreatedByUser,
  Assembly,
  Equipment,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  _MaintenanceActivityType._Text[1: Language = $parameters.P_Language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  _MaintenanceNotification.NotificationText AS NotificationText,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _MaintenanceStrategy._MaintenanceStrategyText[1: Language = $parameters.P_Language ].MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
  _MaintenanceTaskList.TaskListDesc AS TaskListDesc,
  _Equipment.AuthorizationGroup AS AUTHORIZATIONGROUPEQ,
  _LocationAccountAssignment._FunctionalLocation.AuthorizationGroup AS AUTHORIZATIONGROUPFL,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  MaintenancePlanCallObject
FROM P_MaintenanceItemSearch
;

Learn More