A_MaintenancePlanCycle

DDL: A_MAINTENANCEPLANCYCLE Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
12 Fields 1 Data Sources 2 OData Services

Maintenance Plan Cycle

A_MaintenancePlanCycle is a Consumption CDS View that provides data about "Maintenance Plan Cycle" in SAP S/4HANA. It reads from 1 data source (R_MaintenancePlanCycleTP) and exposes 12 fields with key fields MaintenancePlan, MaintenancePlanCycle. It is exposed through 2 OData services (API_MAINTENANCEPLAN, ASQL_F8664). Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
R_MaintenancePlanCycleTP R_MaintenancePlanCycleTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Maintenance Plan Cycle view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
API_MAINTENANCEPLAN API_MAINTENANCEPLAN V2 C2 C1
ASQL_F8664 ASQL_F8664 C2 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
KEY MaintenancePlanCycle MaintenancePlanCycle
MaintenanceStrategy MaintenanceStrategy
CycleSetSequence CycleSetSequence
MaintPlanCycRcrrcIntervalQty MaintPlanCycRcrrcIntervalQty
MaintPlanCycRcrrcIntervalUnit MaintPlanCycRcrrcIntervalUnit
MaintPlanCycleDesc MaintPlanCycleDesc
MeasuringPoint MeasuringPoint
MaintPlanCycleStartOffsetValue MaintPlanCycleStartOffsetValue Maintenance Plan Cycle Offset
MaintCycleNextPlndCntrRdng MaintCycleNextPlndCntrRdng
MaintenancePlanCycleIsInactive MaintenancePlanCycleIsInactive
CycleSetSequenceRepeatFactor CycleSetSequenceRepeatFactor

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 A_MaintenancePlanCycle.
-- 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 A_MaintenancePlanCycle AS
SELECT
  MaintenancePlan,
  MaintenancePlanCycle,
  MaintenanceStrategy,
  CycleSetSequence,
  MaintPlanCycRcrrcIntervalQty,
  MaintPlanCycRcrrcIntervalUnit,
  MaintPlanCycleDesc,
  MeasuringPoint,
  MaintPlanCycleStartOffsetValue,
  MaintCycleNextPlndCntrRdng,
  MaintenancePlanCycleIsInactive,
  CycleSetSequenceRepeatFactor
FROM R_MaintenancePlanCycleTP
;

Learn More