R_MaintenancePlanCycleTP

DDL: R_MAINTENANCEPLANCYCLETP Type: view_entity TRANSACTIONAL

Maintenance Plan Cycle

R_MaintenancePlanCycleTP is a Transactional CDS View that provides data about "Maintenance Plan Cycle" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanCycle) and exposes 16 fields with key fields MaintenancePlan, MaintenancePlanCycle. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanCycle I_MaintenancePlanCycle from

Associations (1)

CardinalityTargetAliasCondition
[1] I_MsrgPtLastMsmtDocument _LastMeasurementReading $projection.MeasuringPoint = _LastMeasurementReading.MeasuringPoint

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan Cycle view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #TRANSACTIONAL_ENTITY view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan
KEY MaintenancePlanCycle MaintenancePlanCycle
MaintenanceStrategy _MaintenancePlan MaintenanceStrategy
MaintPlanCycRcrrcIntervalUnit MaintPlanCycRcrrcIntervalUnit
MaintPlanCycleDesc MaintPlanCycleDesc
MeasuringPoint MeasuringPoint
MaintenancePlanCycleIsInactive
CycleSetSequence CycleSetSequence
CycleSetSequenceRepeatFactor CycleSetSequenceRepeatFactor
MaintPlnStrtBufDurationInDays _MaintenancePlan MaintPlnStrtBufDurationInDays
CharcValueUnit
MsmtRdngDate _LastMeasurementReading MsmtRdngDate
_MaintenancePlan _MaintenancePlan
_MeasuringPoint _MeasuringPoint
_UnitOfMeasure _UnitOfMeasure
_MaintenanceStrategy _MaintenancePlan _MaintenanceStrategy
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan Cycle'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
        usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE],
        viewType: #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API
      }

@ObjectModel : {
                    usageType : {
                                    dataClass: #TRANSACTIONAL,
                                    serviceQuality: #X,
                                    sizeCategory: #XL
                                },
                    modelingPattern: #TRANSACTIONAL_ENTITY,
                    supportedCapabilities: [ #TRANSACTIONAL_PROVIDER ]
}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity R_MaintenancePlanCycleTP
  as select from I_MaintenancePlanCycle
  association to parent R_MaintenancePlanTP as _MaintenancePlan on $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
  association [1] to I_MsrgPtLastMsmtDocument as _LastMeasurementReading on $projection.MeasuringPoint = _LastMeasurementReading.MeasuringPoint  
{
  key MaintenancePlan,
  key MaintenancePlanCycle,
      _MaintenancePlan.MaintenanceStrategy as MaintenanceStrategy,
      
      @Semantics.quantity.unitOfMeasure: 'MaintPlanCycRcrrcIntervalUnit'
      cast(unit_conversion(
        quantity => MaintPlanCycRcrrcIntervalQty,
        source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit,
        target_unit => MaintPlanCycRcrrcIntervalUnit,
        error_handling=> 'KEEP_UNCONVERTED' ) as eam_maint_plan_cycle_int ) as MaintPlanCycRcrrcIntervalQty,

      @UI.textArrangement:  #TEXT_LAST
      MaintPlanCycRcrrcIntervalUnit,
      MaintPlanCycleDesc,
      MeasuringPoint,
      cast ( unit_conversion(
        quantity => MaintPlanCycleStartOffsetValue,
        source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit,
        target_unit => MaintPlanCycRcrrcIntervalUnit,
        error_handling=> 'KEEP_UNCONVERTED'
      ) as eam_maint_plan_cycle_int )           as MaintPlanCycleStartOffsetValue,
      
      @Semantics.quantity.unitOfMeasure: 'MaintPlanCycRcrrcIntervalUnit'
      cast( case MeasuringPoint
            when ''
            then 0
            else cast ( unit_conversion(
                        quantity => MaintCycleNextPlndCntrRdng,
                        source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit,
                        target_unit => MaintPlanCycRcrrcIntervalUnit,
                        error_handling=> 'KEEP_UNCONVERTED' ) as eam_maint_plan_cycle_int ) 
            end as eam_maint_plan_cycle_int preserving type ) as MaintCycleNextPlndCntrRdng,
      
      
      dats_add_days( '00010101', cast( case MeasuringPoint
            when ''
            then MaintCycleNextPlndCntrRdng
            else 0
            end as abap.int4 ),'INITIAL' ) as   MaintenanceCallNextPlannedDate,  
          
      cast( MaintenancePlanCycleIsInactive as boole_d ) as MaintenancePlanCycleIsInactive,
      CycleSetSequence,
      CycleSetSequenceRepeatFactor,
      _MaintenancePlan.MaintPlnStrtBufDurationInDays,
      _MeasuringPoint._Characteristic( P_KeyDate:$session.system_date ).CharcValueUnit,
      @Semantics.quantity.unitOfMeasure: 'MaintPlanCycRcrrcIntervalUnit'
      cast ( unit_conversion(
        quantity => _LastMeasurementReading.MeasurementReading,
        source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit,
        target_unit => _LastMeasurementReading.MeasurementReadingEntryUoM,
        error_handling=> 'KEEP_UNCONVERTED'
      ) as eam_maint_plan_cycle_int )          as  MeasurementReading,   
      _LastMeasurementReading.MsmtRdngDate,      
      
      
      /* Associations */

      _MaintenancePlan,
      _MeasuringPoint,
      _UnitOfMeasure,
      _MaintenancePlan._MaintenanceStrategy    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_MAINTENANCEPLANCYCLE",
"I_MEASURINGPOINT",
"I_MSRGPTLASTMSMTDOCUMENT",
"I_UNITOFMEASURE",
"I_UNITOFMEASUREDIMENSION",
"R_MAINTENANCEPLANTP"
],
"ASSOCIATED":
[
"I_MAINTENANCESTRATEGY",
"I_MEASURINGPOINT",
"I_UNITOFMEASURE",
"R_MAINTENANCEPLANTP"
],
"BASE":
[
"I_MAINTENANCEPLANCYCLE",
"R_MAINTENANCEPLANTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/