I_MaintPlanStrategyCycle

DDL: I_MAINTPLANSTRATEGYCYCLE SQL: IMAINTCYCLESTART Type: view COMPOSITE
9 Fields 2 Data Sources 2 Associations

Maintenance Cycles of Strategy Plan

I_MaintPlanStrategyCycle is a Composite CDS View that provides data about "Maintenance Cycles of Strategy Plan" in SAP S/4HANA. It reads from 2 data sources (I_MaintPlnAssignedPackages, I_MaintenancePackage) and exposes 9 fields with key fields MaintenancePlan, NumberOfControlTableEntities. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MaintPlnAssignedPackages _AssignedPackage from
I_MaintenancePackage _MaintenancePackage inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintenancePlan _MaintenancePlan _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = _MaintenancePackage.MaintenanceTaskPerformanceUnit

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IMAINTCYCLESTART view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Cycles of Strategy Plan view
ObjectModel.representativeKey NumberOfControlTableEntities view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan I_MaintPlnAssignedPackages MaintenancePlan MaintenancePlan
KEY NumberOfControlTableEntities
MaintenanceStrategy I_MaintenancePackage MaintenanceStrategy Strategy Fields
MaintPlanCycRcrrcIntervalUnit I_MaintenancePackage MaintenanceTaskPerformanceUnit Unit
MaintPlanCycleDesc
_MaintenancePlan _MaintenancePlan
_MaintenancePackageUnit I_MaintenancePackage _MaintenancePackageUnit
_MaintenanceStrategy I_MaintenancePackage _MaintenanceStrategy
_UnitOfMeasure _UnitOfMeasure

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_MaintPlanStrategyCycle.
-- 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: IMAINTCYCLESTART

CREATE VIEW I_MaintPlanStrategyCycle AS
SELECT
  _AssignedPackage.MaintenancePlan AS MaintenancePlan,
  cast( _AssignedPackage.MaintenancePackage as dzaehler preserving type) AS NumberOfControlTableEntities,
  _MaintenancePackage.MaintenanceStrategy AS MaintenanceStrategy,
  _MaintenancePackage.MaintenanceTaskPerformanceUnit AS MaintPlanCycRcrrcIntervalUnit,
  _MaintenancePackage._MaintenancePackageText[1:Language = $session.system_language].MaintenancePackageText AS MaintPlanCycleDesc,
  _MaintenancePackage._MaintenancePackageUnit AS _MaintenancePackageUnit,
  _MaintenancePackage._MaintenanceStrategy AS _MaintenanceStrategy
FROM I_MaintPlnAssignedPackages AS _AssignedPackage
INNER JOIN I_MaintenancePackage AS _MaintenancePackage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenancePlan AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = _MaintenancePackage.MaintenanceTaskPerformanceUnit  -- association [0..1]
;

Learn More