ESH_N_MAINTENANCEPLAN

DDL: ESH_N_MAINTENANCEPLAN SQL: ESH_L_MAINTPLAN Type: view
53 Fields 1 Data Sources 1 Associations

ESH_N_MAINTENANCEPLAN is a CDS View in SAP S/4HANA. It reads from 1 data source (P_MaintenancePlanSearch) and exposes 53 fields with key field MaintenancePlan. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_MaintenancePlanSearch P_MaintenancePlanSearch from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..1] N_MaintPlanSchedulingIndicator _MaintPlanSchedulingIndicator $projection.MaintPlanSchedgIndicator = _MaintPlanSchedulingIndicator.MaintPlanSchedgIndicator

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_MAINTPLAN view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
PlainLongText
NumberOfMaintenanceItems NumberOfMaintenanceItems
FunctionalLocation FunctionalLocation Object ID
MaintenancePlannerGroup _MaintenanceItem MaintenancePlannerGroup Planner Group
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays
SchedulingEndDate SchedulingEndDate
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue
SchedulingStartDate SchedulingStartDate
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue
EarlyCompletionTolerancePct EarlyCompletionTolerancePct
LateCompletionTolerancePercent LateCompletionTolerancePercent
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent
LateCompletionShiftInPercent LateCompletionShiftInPercent
SchedulingDurationUnit SchedulingDurationUnit
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib
BasicStartDate BasicStartDate
MaintenancePlanDesc MaintenancePlanDesc
CallHorizonInDays CallHorizonInDays
CallHorizonPercent CallHorizonPercent
MaintPlanSchedgIndicator P_MaintenancePlanSearch MaintPlanSchedgIndicator
MaintPlanSchedgIndDesc
CycleModificationRatio CycleModificationRatio
Equipment Equipment Equipment check
MaintenanceStrategy MaintenanceStrategy
LastChangedByUser LastChangedByUser User Name
CreatedByUser CreatedByUser User Name
MaintenancePlanCategory MaintenancePlanCategory
MaintenanceStrategyDesc
MaintenancePlanCategoryDesc
MaintenancePlanCallObject _MaintenancePlanCatParam MaintenancePlanCallObject
MaintenanceItemDescription _MaintenanceItem MaintenanceItemDescription MaintItem text
MaintPlanCycleDesc _MaintenancePlanCycle MaintPlanCycleDesc
FuncnlLocPrimaryLabelName _FunctionalLocationLabel FuncnlLocPrimaryLabelName
FactoryCalendarName
EquipmentName
MaintenancePlanningPlant _MaintenanceItem MaintenancePlanningPlant Planning Plant
AuthorizationGroup AuthorizationGroup AuthorizGroup
ControllingArea
CostCenter
MaintenancePlant
MaintenanceOrder _MaintenanceCall MaintenanceOrder Order
MaintenanceCall MaintenanceCall Call Number
CharcValue
CharcValueDescription
CharcFromNumericValue
CharcToNumericValue
ClassType
Class
ClassInternalID
ClassDescription
Characteristic
CharcDescription

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_MAINTENANCEPLAN.
-- 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_MAINTPLAN
-- Parameters: P_Language : abap.lang, P_KeyDate : sydate

CREATE VIEW ESH_N_MAINTENANCEPLAN AS
SELECT
  MaintenancePlan,
  _LongText[1: Language = $parameters.P_Language ].PlainLongText AS PlainLongText,
  NumberOfMaintenanceItems,
  FunctionalLocation,
  _MaintenanceItem.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  MaintenanceLeadFloatInDays,
  SchedulingEndDate,
  MaintPlanStartCntrReadingValue,
  SchedulingStartDate,
  MaintPlanEndCntrReadingValue,
  EarlyCompletionTolerancePct,
  LateCompletionTolerancePercent,
  EarlyCompletionShiftInPercent,
  LateCompletionShiftInPercent,
  SchedulingDurationUnit,
  MaintPlanFreeDefinedAttrib,
  BasicStartDate,
  MaintenancePlanDesc,
  CallHorizonInDays,
  CallHorizonPercent,
  P_MaintenancePlanSearch.MaintPlanSchedgIndicator AS MaintPlanSchedgIndicator,
  _MaintPlanSchedulingIndicator[1: Language = $parameters.P_Language ].MaintPlanSchedgIndDesc AS MaintPlanSchedgIndDesc,
  CycleModificationRatio,
  Equipment,
  MaintenanceStrategy,
  LastChangedByUser,
  CreatedByUser,
  MaintenancePlanCategory,
  _MaintenanceStrategy._MaintenanceStrategyText[1: Language = $parameters.P_Language ].MaintenanceStrategyDesc AS MaintenanceStrategyDesc,
  _MaintenancePlanCatParam._Text[1: Language = $parameters.P_Language ].MaintenancePlanCategoryDesc AS MaintenancePlanCategoryDesc,
  _MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject,
  _MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _MaintenancePlanCycle.MaintPlanCycleDesc AS MaintPlanCycleDesc,
  _FunctionalLocationLabel.FuncnlLocPrimaryLabelName AS FuncnlLocPrimaryLabelName,
  _FactoryCalendar._Text[1: Language = $parameters.P_Language ].FactoryCalendarName AS FactoryCalendarName,
  _Equipment._EquipmentText[1: Language = $parameters.P_Language ].EquipmentName AS EquipmentName,
  _MaintenanceItem.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  AuthorizationGroup,
  _MaintenanceItem._LocationAccountAssignment.ControllingArea AS ControllingArea,
  _MaintenanceItem._LocationAccountAssignment.CostCenter AS CostCenter,
  _MaintenanceItem._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _MaintenanceCall.MaintenanceOrder AS MaintenanceOrder,
  MaintenanceCall,
  _CharValueAssignment(P_KeyDate : $parameters.P_KeyDate).CharcValue AS CharcValue,
  _CharValueAssignment(P_KeyDate : $parameters.P_KeyDate)._CharacteristicValue( P_KeyDate:$parameters.P_KeyDate )._CharacteristicValueDesc( P_KeyDate: $parameters.P_KeyDate ).CharcValueDescription AS CharcValueDescription,
  _CharValueAssignment(P_KeyDate : $parameters.P_KeyDate).CharcFromNumericValue AS CharcFromNumericValue,
  _CharValueAssignment(P_KeyDate : $parameters.P_KeyDate).CharcToNumericValue AS CharcToNumericValue,
  _ClassAssignment(P_KeyDate : $parameters.P_KeyDate).ClassType AS ClassType,
  _ClassAssignment( P_KeyDate: $parameters.P_KeyDate)._Class( P_KeyDate: $parameters.P_KeyDate ).Class AS Class,
  _ClassAssignment( P_KeyDate: $parameters.P_KeyDate)._Class( P_KeyDate: $parameters.P_KeyDate ).ClassInternalID AS ClassInternalID,
  _ClassAssignment( P_KeyDate: $parameters.P_KeyDate)._Class( P_KeyDate: $parameters.P_KeyDate )._ClassDescription( P_KeyDate: $parameters.P_KeyDate ).ClassDescription AS ClassDescription,
  _CharValueAssignment( P_KeyDate: $parameters.P_KeyDate )._Characteristic( P_KeyDate : $parameters.P_KeyDate ).Characteristic AS Characteristic,
  _CharValueAssignment( P_KeyDate: $parameters.P_KeyDate )._Characteristic( P_KeyDate : $parameters.P_KeyDate )._CharacteristicDesc( P_KeyDate: $parameters.P_KeyDate ).CharcDescription AS CharcDescription
FROM P_MaintenancePlanSearch
LEFT OUTER JOIN N_MaintPlanSchedulingIndicator AS _MaintPlanSchedulingIndicator ON MaintPlanSchedgIndicator = _MaintPlanSchedulingIndicator.MaintPlanSchedgIndicator  -- association [0..1]
;

Learn More