I_MaintenancePlanData

DDL: I_MAINTENANCEPLANDATA SQL: IMAINTPLANDATA Type: view COMPOSITE
51 Fields 1 Data Sources

Maintenance Plan Data

I_MaintenancePlanData is a Composite CDS View (Dimension) that provides data about "Maintenance Plan Data" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlan) and exposes 51 fields with key field MaintenancePlan.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlan I_MaintenancePlan from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTPLANDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
VDM.lifecycle.status #DEPERECATED view
VDM.lifecycle.successor C_MaintenancePlanDEX view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc MaintPlanText
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
MaintenanceStrategy MaintenanceStrategy Strategy Fields
SchedulingDuration SchedulingDuration SchedPeriod
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls Stock del. flag
NumberOfMaintenanceItems NumberOfMaintenanceItems No. items
MaintenanceCall MaintenanceCall Call Number
LateCompletionShiftFactor LateCompletionShiftFactor Late Completion
EarlyCompletionShiftFactor EarlyCompletionShiftFactor EarlyCompletion
LateCompletionTolerancePercent LateCompletionTolerancePercent Upper Limit
EarlyCompletionTolerancePct EarlyCompletionTolerancePct Tolerance (-)
CycleModificationRatio CycleModificationRatio CycModifFactor
MaintPlanSchedgIndicator MaintPlanSchedgIndicator SchedIndic.
CallHorizonPercent CallHorizonPercent Horizon
CallHorizonInDays CallHorizonInDays Call horizon
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType
LogicalOperator LogicalOperator Operation type
AuthorizationGroup AuthorizationGroup AuthorizGroup
MaintenancePlanCategory MaintenancePlanCategory MPlan cat.
SchedulingDurationUnit SchedulingDurationUnit UoM:HandlCap GR
BasicStartDate BasicStartDate Municipality
MaintSchedulingStartCounter MaintSchedulingStartCounter StrtCtrReadg
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd Compl.Requirmnt
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib Sort field
FactoryCalendar FactoryCalendar Factory Calendar
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead float
SchedulingStartDate SchedulingStartDate Valn start date
SchedulingStartTime SchedulingStartTime Time Stamp
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor Shift Fctr MCP
MaintSchedulingEndCounter MaintSchedulingEndCounter End Counter
SchedulingEndDate SchedulingEndDate End Date for Sched.
LastChangeDateTime LastChangeDateTime Timestamp
NumberOfControlTableEntities _MaintenanceCycle NumberOfControlTableEntities
ComparisonOperator _MaintenanceCycle ComparisonOperator
MaintPlanCycleIntervalCount _MaintenanceCycle MaintPlanCycleIntervalCount
MaintenanceTaskPerformanceUnit _MaintenanceCycle MaintenanceTaskPerformanceUnit
MaintPlanCycleDesc _MaintenanceCycle MaintPlanCycleDesc
Language _MaintenanceCycle Language Report Text Language
MeasuringPoint _MaintenanceCycle MeasuringPoint
MaintPlanCycleStartOffsetValue _MaintenanceCycle MaintPlanCycleStartOffsetValue
EventSchedulingIsInactive _MaintenanceCycle EventSchedulingIsInactive
CycleSetSequence _MaintenanceCycle CycleSetSequence
CycleSetSequenceRepeatFactor _MaintenanceCycle CycleSetSequenceRepeatFactor
_MaintenancePlanCatParam _MaintenancePlanCatParam
_UnitOfMeasure _MaintenanceCycle _UnitOfMeasure
_Language _MaintenanceCycle _Language
_MeasuringPoint _MaintenanceCycle _MeasuringPoint

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 I_MaintenancePlanData.
-- 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: IMAINTPLANDATA

CREATE VIEW I_MaintenancePlanData AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  SchedulingDuration,
  MaintPlanIsLockedAgainstCalls,
  NumberOfMaintenanceItems,
  MaintenanceCall,
  LateCompletionShiftFactor,
  EarlyCompletionShiftFactor,
  LateCompletionTolerancePercent,
  EarlyCompletionTolerancePct,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  MaintenanceCallHorizonCalcType,
  LogicalOperator,
  AuthorizationGroup,
  MaintenancePlanCategory,
  SchedulingDurationUnit,
  BasicStartDate,
  MaintSchedulingStartCounter,
  PrdcssrCallObjCompltnIsRqd,
  MaintPlanFreeDefinedAttrib,
  FactoryCalendar,
  MaintenanceLeadFloatInDays,
  SchedulingStartDate,
  SchedulingStartTime,
  MultipleCounterPlanShiftFactor,
  MaintSchedulingEndCounter,
  SchedulingEndDate,
  LastChangeDateTime,
  _MaintenanceCycle.NumberOfControlTableEntities AS NumberOfControlTableEntities,
  _MaintenanceCycle.ComparisonOperator AS ComparisonOperator,
  _MaintenanceCycle.MaintPlanCycleIntervalCount AS MaintPlanCycleIntervalCount,
  _MaintenanceCycle.MaintenanceTaskPerformanceUnit AS MaintenanceTaskPerformanceUnit,
  _MaintenanceCycle.MaintPlanCycleDesc AS MaintPlanCycleDesc,
  _MaintenanceCycle.Language AS Language,
  _MaintenanceCycle.MeasuringPoint AS MeasuringPoint,
  _MaintenanceCycle.MaintPlanCycleStartOffsetValue AS MaintPlanCycleStartOffsetValue,
  _MaintenanceCycle.EventSchedulingIsInactive AS EventSchedulingIsInactive,
  _MaintenanceCycle.CycleSetSequence AS CycleSetSequence,
  _MaintenanceCycle.CycleSetSequenceRepeatFactor AS CycleSetSequenceRepeatFactor,
  _MaintenanceCycle._UnitOfMeasure AS _UnitOfMeasure,
  _MaintenanceCycle._Language AS _Language,
  _MaintenanceCycle._MeasuringPoint AS _MeasuringPoint
FROM I_MaintenancePlan
;

Learn More