C_MaintenancePlanDP

DDL: C_MAINTENANCEPLANDP Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
47 Fields 1 Data Sources 1 Associations 1 OData Services

Data Provider for Maint Plan

C_MaintenancePlanDP is a Consumption CDS View that provides data about "Data Provider for Maint Plan" in SAP S/4HANA. It reads from 1 data source (C_MaintenancePlanDEX_2) and exposes 47 fields with key field MaintenancePlan. It has 1 association to related views. It is exposed through 1 OData service (DP_MAINTENANCEPLAN). Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
C_MaintenancePlanDEX_2 C_MaintenancePlanDEX_2 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MaintenanceItemDP _MaintenanceItem _MaintenanceItem.MaintenancePlan = $projection.MaintenancePlan

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Data Provider for Maint Plan view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name MaintenancePlan view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
DataIntegration.deltaReplication.intended true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_MAINTENANCEPLAN DP_MAINTENANCEPLAN C2 NOT_RELEASED

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
MaintenanceStrategy MaintenanceStrategy
SchedulingDuration SchedulingDuration
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
Customer Customer Sold-to Party
NumberOfMaintenanceItems NumberOfMaintenanceItems
Language Language Report Text Language
CycleModificationRatio CycleModificationRatio
MaintPlanSchedgIndicator MaintPlanSchedgIndicator
CallHorizonPercent CallHorizonPercent
CallHorizonInDays CallHorizonInDays
AuthorizationGroup AuthorizationGroup AuthorizGroup
MaintenancePlanInternalID MaintenancePlanInternalID
MaintenanceCall MaintenanceCall Call Number
MaintenancePlanCategory MaintenancePlanCategory
SchedulingDurationUnit SchedulingDurationUnit
BasicStartDate BasicStartDate
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib
FactoryCalendar FactoryCalendar Factory Calendar
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls
LastChangeDateTime LastChangeDateTime Timestamp
LateCompletionShiftInPercent LateCompletionShiftInPercent
EarlyCompletionShiftInPercent EarlyCompletionShiftInPercent
LateCompletionTolerancePercent LateCompletionTolerancePercent
EarlyCompletionTolerancePct EarlyCompletionTolerancePct
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType
MaintPlanLogicalOperatorCode MaintPlanLogicalOperatorCode
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor
MaintPlanStartCntrReadingValue MaintPlanStartCntrReadingValue
SchedulingStartDate SchedulingStartDate
SchedulingStartTime SchedulingStartTime
MaintPlanEndCntrReadingValue MaintPlanEndCntrReadingValue
SchedulingEndDate SchedulingEndDate
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays
MaintPlnStrtBufDurationInDays MaintPlnStrtBufDurationInDays
MaintPlanStartBufferUnit MaintPlanStartBufferUnit
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd
MaintenancePlanHasLongText MaintenancePlanHasLongText
MaintenancePlanCallObject MaintenancePlanCallObject
_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_MaintenancePlanDP.
-- 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_MaintenancePlanDP 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 C_MaintenancePlanDEX_2
LEFT OUTER JOIN C_MaintenanceItemDP AS _MaintenanceItem ON _MaintenanceItem.MaintenancePlan = MaintenancePlan  -- association [0..*]
;

Learn More