I_MaintenanceCycle

DDL: I_MAINTENANCECYCLE SQL: IMAINTCYCLE Type: view BASIC Package: IPRM

Maintenance Cycle

I_MaintenanceCycle is a Basic CDS View that provides data about "Maintenance Cycle" in SAP S/4HANA. It reads from 1 data source (mmpt) and exposes 17 fields with key fields MaintenancePlan, NumberOfControlTableEntities. It has 4 associations to related views. Part of development package IPRM.

Data Sources (1)

SourceAliasJoin Type
mmpt mmpt from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MaintenancePlan _MaintenancePlan _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
[0..1] I_MeasuringPoint _MeasuringPoint _MeasuringPoint.MeasuringPoint = $projection.MeasuringPoint
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTCYCLE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Cycle view
ObjectModel.representativeKey NumberOfControlTableEntities view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPERECATED view
VDM.lifecycle.successor I_MaintenancePlanCycle view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan mmpt warpl
KEY NumberOfControlTableEntities mmpt nummer
ComparisonOperator mmpt operator
MaintPlanCycleIntervalCount mmpt zykl1
MaintenanceTaskPerformanceUnit mmpt zeieh
MaintPlanCycleDesc mmpt pak_text
Language mmpt langu
MeasuringPoint mmpt point
MaintPlanCycleStartOffsetValue mmpt offset
MaintCycleNextPlndCntrRdng mmpt nzaeh
EventSchedulingIsInactive mmpt inaktiv
CycleSetSequence mmpt cycleseqind
CycleSetSequenceRepeatFactor mmpt setrepeatind
_MaintenancePlan _MaintenancePlan
_MeasuringPoint _MeasuringPoint
_Language _Language
_UnitOfMeasure _UnitOfMeasure
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMAINTCYCLE'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Cycle'
@ObjectModel: {
  representativeKey: 'NumberOfControlTableEntities',
  semanticKey:  [ 'MaintenancePlan','NumberOfControlTableEntities' ],
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #M
  }
}
@VDM.viewType: #BASIC


@VDM.lifecycle.status   : #DEPERECATED
@VDM.lifecycle.successor: 'I_MaintenancePlanCycle'


define view I_MaintenanceCycle
  as select from mmpt
  
  association [1..1] to I_MaintenancePlan as _MaintenancePlan on _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
  association [0..1] to I_MeasuringPoint  as _MeasuringPoint  on _MeasuringPoint.MeasuringPoint = $projection.MeasuringPoint
  association [0..1] to I_UnitOfMeasure   as _UnitOfMeasure   on _UnitOfMeasure.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit
  association [0..1] to I_Language        as _Language        on _Language.Language = $projection.Language
{
      @ObjectModel.foreignKey.association: '_MaintenancePlan'
  key mmpt.warpl        as MaintenancePlan,
  
  key mmpt.nummer       as NumberOfControlTableEntities,

      mmpt.operator     as ComparisonOperator,

      @Semantics.quantity.unitOfMeasure: 'MaintenanceTaskPerformanceUnit'
      mmpt.zykl1        as MaintPlanCycleIntervalCount,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure: true
      mmpt.zeieh        as MaintenanceTaskPerformanceUnit,

      mmpt.pak_text     as MaintPlanCycleDesc,

      @ObjectModel.foreignKey.association: '_Language'
      mmpt.langu        as Language,

      @ObjectModel.foreignKey.association: '_MeasuringPoint'
      mmpt.point        as MeasuringPoint,

      mmpt.offset       as MaintPlanCycleStartOffsetValue,

      mmpt.nzaeh        as MaintCycleNextPlndCntrRdng,

      mmpt.inaktiv      as EventSchedulingIsInactive,

      mmpt.cycleseqind  as CycleSetSequence,

      mmpt.setrepeatind as CycleSetSequenceRepeatFactor,

      /* Associations */
      _MaintenancePlan,
      _MeasuringPoint,
      _Language,
      _UnitOfMeasure

}