C_MaintPlanScheduleDEX_2

DDL: C_MAINTPLANSCHEDULEDEX_2 Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
19 Fields 1 Data Sources

Data Extraction for Maint Plan Schedule

C_MaintPlanScheduleDEX_2 is a Consumption CDS View (Fact) that provides data about "Data Extraction for Maint Plan Schedule" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanSchedule) and exposes 19 fields with key fields MaintenancePlan, MaintenancePlanCallNumber, MaintenancePackage. Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanSchedule _MaintenancePlanSchedule from

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Data Extraction for Maint Plan Schedule view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.technicalName CMNTPLNSCHEDLDEX view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name MaintenancePlanSchedule view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan I_MaintenancePlanSchedule MaintenancePlan MaintenancePlan
KEY MaintenancePlanCallNumber I_MaintenancePlanSchedule MaintenancePlanCallNumber
KEY MaintenancePackage I_MaintenancePlanSchedule MaintenancePackage
SchedulingType I_MaintenancePlanSchedule SchedulingType
SchedulingStatus Scheduling Status
MeasuringPoint I_MaintenancePlanSchedule MeasuringPoint
MaintenanceCallNextPlannedDate I_MaintenancePlanSchedule MaintenanceCallNextPlannedDate
CompletionDate I_MaintenancePlanSchedule CompletionDate Completion Date
CycleSetSequence I_MaintenancePlanSchedule CycleSetSequence
MaintCallCompltnCntrRdng I_MaintenancePlanSchedule MaintCallCompltnCntrRdng
MaintenanceCallIsOutstanding I_MaintenancePlanSchedule MaintenanceCallIsOutstanding
MaintCallIsInvokedOnPlndDate I_MaintenancePlanSchedule MaintCallIsInvokedOnPlndDate
MaintCallHorizonIsNotReached I_MaintenancePlanSchedule MaintCallHorizonIsNotReached
MaintPlanLastScheduledDate I_MaintenancePlanSchedule MaintPlanLastScheduledDate
ReleasedByUserName I_MaintenancePlanSchedule ReleasedByUserName Description
MaintPlanPrdcssrCallCompltnDte I_MaintenancePlanSchedule MaintPlanPrdcssrCallCompltnDte
MaintenancePlanManualCallDate I_MaintenancePlanSchedule MaintenancePlanManualCallDate
MaintenanceCallLastPlannedDate I_MaintenancePlanSchedule MaintenanceCallLastPlannedDate
_MaintenancePlan I_MaintenancePlanSchedule _MaintenancePlan

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_MaintPlanScheduleDEX_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_MaintPlanScheduleDEX_2 AS
SELECT
  _MaintenancePlanSchedule.MaintenancePlan AS MaintenancePlan,
  _MaintenancePlanSchedule.MaintenancePlanCallNumber AS MaintenancePlanCallNumber,
  _MaintenancePlanSchedule.MaintenancePackage AS MaintenancePackage,
  _MaintenancePlanSchedule.SchedulingType AS SchedulingType,
  cast(_MaintenancePlanSchedule.SchedulingStatus as char1 preserving type ) AS SchedulingStatus,
  _MaintenancePlanSchedule.MeasuringPoint AS MeasuringPoint,
  _MaintenancePlanSchedule.MaintenanceCallNextPlannedDate AS MaintenanceCallNextPlannedDate,
  _MaintenancePlanSchedule.CompletionDate AS CompletionDate,
  _MaintenancePlanSchedule.CycleSetSequence AS CycleSetSequence,
  _MaintenancePlanSchedule.MaintCallCompltnCntrRdng AS MaintCallCompltnCntrRdng,
  _MaintenancePlanSchedule.MaintenanceCallIsOutstanding AS MaintenanceCallIsOutstanding,
  _MaintenancePlanSchedule.MaintCallIsInvokedOnPlndDate AS MaintCallIsInvokedOnPlndDate,
  _MaintenancePlanSchedule.MaintCallHorizonIsNotReached AS MaintCallHorizonIsNotReached,
  _MaintenancePlanSchedule.MaintPlanLastScheduledDate AS MaintPlanLastScheduledDate,
  _MaintenancePlanSchedule.ReleasedByUserName AS ReleasedByUserName,
  _MaintenancePlanSchedule.MaintPlanPrdcssrCallCompltnDte AS MaintPlanPrdcssrCallCompltnDte,
  _MaintenancePlanSchedule.MaintenancePlanManualCallDate AS MaintenancePlanManualCallDate,
  _MaintenancePlanSchedule.MaintenanceCallLastPlannedDate AS MaintenanceCallLastPlannedDate,
  _MaintenancePlanSchedule._MaintenancePlan AS _MaintenancePlan
FROM I_MaintenancePlanSchedule AS _MaintenancePlanSchedule
;

Learn More