ESH_S_MAINTENANCEPLAN

DDL: ESH_S_MAINTENANCEPLAN SQL: ESH_U_MAINTPLAN Type: view
52 Fields 1 Data Sources

ESH_S_MAINTENANCEPLAN is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_MAINTENANCEPLAN) and exposes 52 fields with key field MaintenancePlan.

Data Sources (1)

SourceAliasJoin Type
ESH_N_MAINTENANCEPLAN ESH_N_MAINTENANCEPLAN from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KeyDate sydate

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 MaintenancePlan view
UI.headerInfo.typeName Maintenance Plan view
UI.headerInfo.typeNamePlural Maintenance Plans view
Consumption.semanticObject MaintenancePlan view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value MAINTENANCEPLAN view
AbapCatalog.sqlViewName ESH_U_MAINTPLAN view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan Maintenance Plan
PlainLongText PlainLongText Long Texts
NumberOfMaintenanceItems NumberOfMaintenanceItems Number of Maintenance Items
FunctionalLocation FunctionalLocation Functional Location Internal ID
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead Float (days)
SchedulingStartDate SchedulingStartDate Scheduling Start Date
SchedulingEndDate SchedulingEndDate Scheduling End Date
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue Scheduling Start Counter
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue Scheduling End Counter
EarlyCompletionTolerancePct EarlyCompletionTolerancePct Early Completion Tolerance (%)
LateCompletionTolerancePercent LateCompletionTolerancePercent Late Completion Tolerance (%)
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent Early Completion Shift Factor
LateCompletionShiftInPercent LateCompletionShiftInPercent Late Completion Shift Factor
SchedulingDurationUnit SchedulingDurationUnit Scheduling Duration Unit
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib Maintenance Plan Sort Field
BasicStartDate BasicStartDate Start of Cycle
MaintenancePlanDesc MaintenancePlanDesc Maintenance Plan Description
CallHorizonInDays CallHorizonInDays Call Horizon (days)
CallHorizonPercent CallHorizonPercent Call Horizon (%)
MaintPlanSchedgIndicator MaintPlanSchedgIndicator Scheduling Indicator
MaintPlanSchedgIndDesc MaintPlanSchedgIndDesc Scheduling Indicator Description
CycleModificationRatio CycleModificationRatio Cycle Modification Factor
Equipment Equipment Equipment check
MaintenanceStrategy MaintenanceStrategy Maintenance Plan Strategy
LastChangedByUser LastChangedByUser User Name
CreatedByUser CreatedByUser User Name
MaintenancePlanCategory MaintenancePlanCategory Maintenance Plan Category
MaintenancePlanCallObject MaintenancePlanCallObject Maintenance Plan Call Object
MaintenanceStrategyDesc MaintenanceStrategyDesc Strategy Description
MaintenancePlanCategoryDesc MaintenancePlanCategoryDesc Maintenance Plan Category Description
MaintenanceItemDescription MaintenanceItemDescription Maintenance Item Description
MaintPlanCycleDesc MaintPlanCycleDesc Maintenance Cycle Description
FuncnlLocPrimaryLabelName FuncnlLocPrimaryLabelName Functional Location - primary label
FactoryCalendarName FactoryCalendarName
EquipmentName EquipmentName Equipment Description
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
AuthorizationGroup AuthorizationGroup Authorization Group
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
MaintenancePlant MaintenancePlant Plant
MaintenanceOrder MaintenanceOrder Order
MaintenanceCall MaintenanceCall Maintenance Call No.
CharcValue CharcValue Characteristic Value
CharcFromNumericValue CharcFromNumericValue Characteristic Numeric Value (From)
CharcToNumericValue CharcToNumericValue Characteristic Numeric Value (To)
ClassType ClassType Class Type
Class Class Class
Characteristic Characteristic Characteristic
ClassDescription ClassDescription Class Description
CharcDescription CharcDescription Characteristic Description
CharcValueDescription CharcValueDescription Characteristic Value Description

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

CREATE VIEW ESH_S_MAINTENANCEPLAN AS
SELECT
  MaintenancePlan,
  PlainLongText,
  NumberOfMaintenanceItems,
  FunctionalLocation,
  MaintenancePlannerGroup,
  MaintenanceLeadFloatInDays,
  SchedulingStartDate,
  SchedulingEndDate,
  MaintPlanStartCntrReadingValue,
  MaintPlanEndCntrReadingValue,
  EarlyCompletionTolerancePct,
  LateCompletionTolerancePercent,
  EarlyCompletionShiftInPercent,
  LateCompletionShiftInPercent,
  SchedulingDurationUnit,
  MaintPlanFreeDefinedAttrib,
  BasicStartDate,
  MaintenancePlanDesc,
  CallHorizonInDays,
  CallHorizonPercent,
  MaintPlanSchedgIndicator,
  MaintPlanSchedgIndDesc,
  CycleModificationRatio,
  Equipment,
  MaintenanceStrategy,
  LastChangedByUser,
  CreatedByUser,
  MaintenancePlanCategory,
  MaintenancePlanCallObject,
  MaintenanceStrategyDesc,
  MaintenancePlanCategoryDesc,
  MaintenanceItemDescription,
  MaintPlanCycleDesc,
  FuncnlLocPrimaryLabelName,
  FactoryCalendarName,
  EquipmentName,
  MaintenancePlanningPlant,
  AuthorizationGroup,
  ControllingArea,
  CostCenter,
  MaintenancePlant,
  MaintenanceOrder,
  MaintenanceCall,
  CharcValue,
  CharcFromNumericValue,
  CharcToNumericValue,
  ClassType,
  Class,
  Characteristic,
  ClassDescription,
  CharcDescription,
  CharcValueDescription
FROM ESH_N_MAINTENANCEPLAN
;

Learn More