C_MaintenancePlanDEX_2

DDL: C_MAINTENANCEPLANDEX_2 Type: view_entity CONSUMPTION
47 Fields 1 Data Sources

Maintenance Plan

C_MaintenancePlanDEX_2 (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Maintenance Plan · Asset Management

C_MaintenancePlanDEX_2 is a Consumption CDS View (Dimension) that provides data about "Maintenance Plan" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanBasic) and exposes 47 fields with key field MaintenancePlan.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-MP
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction, Data Source in SQL Select, Analytical Dimension
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanBasic I_MaintenancePlanBasic from

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Plan view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name MaintenancePlan view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey MaintenancePlan view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan Maintenance Plan
MaintenancePlanDesc MaintenancePlanDesc Maintenance Plan Text
CreationDate CreationDate Date of creation
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
SchedulingDuration SchedulingDuration Scheduling Period
Equipment Equipment Equipment Number
FunctionalLocation FunctionalLocation Functional Location
Customer Customer Customer Number
NumberOfMaintenanceItems NumberOfMaintenanceItems Number of maintenance items in the maintenance plan
Language Language Language key of the long text
CycleModificationRatio CycleModificationRatio Cycle modification factor
MaintPlanSchedgIndicator MaintPlanSchedgIndicator Scheduling indicator
CallHorizonPercent CallHorizonPercent Call horizon for maintenance plan calls
CallHorizonInDays CallHorizonInDays Call horizon for maintenance plan calls
AuthorizationGroup AuthorizationGroup Technical Object Authorization Group
MaintenancePlanInternalID MaintenancePlanInternalID Val. Obj. No.
MaintenanceCall MaintenanceCall Maintenance Plan Call Number
MaintenancePlanCategory MaintenancePlanCategory Maintenance plan category
SchedulingDurationUnit SchedulingDurationUnit Unit for Scheduling Period
BasicStartDate BasicStartDate Municipality
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib Sort field for maintenance plans
FactoryCalendar FactoryCalendar Factory calendar key
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls Indicator: maintenance plan locked against calls
LastChangeDateTime LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
LateCompletionShiftInPercent LateCompletionShiftInPercent Shift Factor for Late Completion
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent Shift Factor for Early Completion
LateCompletionTolerancePercent LateCompletionTolerancePercent Tolerance for Late Completion (%)
EarlyCompletionTolerancePct EarlyCompletionTolerancePct Tolerance for Early Completion (%)
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType Calculation Type of Call Horizon
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode Indicator for OR or AND link
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor Shift Factor for Multiple Counter Plan
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue Start counter reading
SchedulingStartDate SchedulingStartDate Start Date for Scheduling
SchedulingStartTime SchedulingStartTime Start Time for Scheduling
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue End Counter for Scheduling
SchedulingEndDate SchedulingEndDate End Date for Scheduling
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays Lead Float in Days
MaintPlnStrtBufDurationInDays MaintPlnStrtBufDurationInDays Scheduling to reoccur when lead float reached
MaintPlanStartBufferUnit MaintPlanStartBufferUnit Unit for Scheduling Period
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd Only Create New Call Object After Completing Predecessor
MaintenancePlanHasLongText MaintenancePlanHasLongText Long Text Indicator
MaintenancePlanCallObject MaintenancePlanCallObject Call object for maintenance plan
_MaintenanceItem _MaintenanceItem
_MaintenancePlanCatParam _MaintenancePlanCatParam

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 C_MaintenancePlanDEX_2.
-- 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.

CREATE VIEW C_MaintenancePlanDEX_2 AS
SELECT
  MaintenancePlan,
  MaintenancePlanDesc,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceStrategy,
  SchedulingDuration,
  Equipment,
  FunctionalLocation,
  Customer,
  NumberOfMaintenanceItems,
  Language,
  CycleModificationRatio,
  MaintPlanSchedgIndicator,
  CallHorizonPercent,
  CallHorizonInDays,
  AuthorizationGroup,
  MaintenancePlanInternalID,
  MaintenanceCall,
  MaintenancePlanCategory,
  SchedulingDurationUnit,
  BasicStartDate,
  MaintPlanFreeDefinedAttrib,
  FactoryCalendar,
  MaintPlanIsLockedAgainstCalls,
  LastChangeDateTime,
  LateCompletionShiftInPercent,
  EarlyCompletionShiftInPercent,
  LateCompletionTolerancePercent,
  EarlyCompletionTolerancePct,
  MaintenanceCallHorizonCalcType,
  MaintPlanLogicalOperatorCode,
  MultipleCounterPlanShiftFactor,
  MaintPlanStartCntrReadingValue,
  SchedulingStartDate,
  SchedulingStartTime,
  MaintPlanEndCntrReadingValue,
  SchedulingEndDate,
  MaintenanceLeadFloatInDays,
  MaintPlnStrtBufDurationInDays,
  MaintPlanStartBufferUnit,
  PrdcssrCallObjCompltnIsRqd,
  MaintenancePlanHasLongText,
  MaintenancePlanCallObject
FROM I_MaintenancePlanBasic
;

Learn More