I_MaintenancePlanData

DDL: I_MAINTENANCEPLANDATA SQL: IMAINTPLANDATA Type: view COMPOSITE

Maintenance Plan Data

I_MaintenancePlanData is a Composite CDS View (Dimension) that provides data about "Maintenance Plan Data" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlan) and exposes 51 fields with key field MaintenancePlan.

1 data source(s) 51 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlan I_MaintenancePlan from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTPLANDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan Data view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #EXTRACTION_DATA_SOURCE view
VDM.lifecycle.status #DEPERECATED view
VDM.lifecycle.successor C_MaintenancePlanDEX view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan
MaintenancePlanDesc MaintenancePlanDesc
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
MaintenanceStrategy MaintenanceStrategy
SchedulingDuration SchedulingDuration
MaintPlanIsLockedAgainstCalls MaintPlanIsLockedAgainstCalls
NumberOfMaintenanceItems NumberOfMaintenanceItems
MaintenanceCall MaintenanceCall
LateCompletionShiftFactor LateCompletionShiftFactor
EarlyCompletionShiftFactor EarlyCompletionShiftFactor
LateCompletionTolerancePercent LateCompletionTolerancePercent
EarlyCompletionTolerancePct EarlyCompletionTolerancePct
CycleModificationRatio CycleModificationRatio
MaintPlanSchedgIndicator MaintPlanSchedgIndicator
CallHorizonPercent CallHorizonPercent
CallHorizonInDays CallHorizonInDays
MaintenanceCallHorizonCalcType MaintenanceCallHorizonCalcType
LogicalOperator LogicalOperator
AuthorizationGroup AuthorizationGroup
MaintenancePlanCategory MaintenancePlanCategory
SchedulingDurationUnit SchedulingDurationUnit
BasicStartDate BasicStartDate
MaintSchedulingStartCounter MaintSchedulingStartCounter
PrdcssrCallObjCompltnIsRqd PrdcssrCallObjCompltnIsRqd
MaintPlanFreeDefinedAttrib MaintPlanFreeDefinedAttrib
FactoryCalendar FactoryCalendar
MaintenanceLeadFloatInDays MaintenanceLeadFloatInDays
SchedulingStartDate SchedulingStartDate
SchedulingStartTime SchedulingStartTime
MultipleCounterPlanShiftFactor MultipleCounterPlanShiftFactor
MaintSchedulingEndCounter MaintSchedulingEndCounter
SchedulingEndDate SchedulingEndDate
LastChangeDateTime LastChangeDateTime
NumberOfControlTableEntities _MaintenanceCycle NumberOfControlTableEntities
ComparisonOperator _MaintenanceCycle ComparisonOperator
MaintPlanCycleIntervalCount _MaintenanceCycle MaintPlanCycleIntervalCount
MaintenanceTaskPerformanceUnit _MaintenanceCycle MaintenanceTaskPerformanceUnit
MaintPlanCycleDesc _MaintenanceCycle MaintPlanCycleDesc
Language _MaintenanceCycle Language
MeasuringPoint _MaintenanceCycle MeasuringPoint
MaintPlanCycleStartOffsetValue _MaintenanceCycle MaintPlanCycleStartOffsetValue
EventSchedulingIsInactive _MaintenanceCycle EventSchedulingIsInactive
CycleSetSequence _MaintenanceCycle CycleSetSequence
CycleSetSequenceRepeatFactor _MaintenanceCycle CycleSetSequenceRepeatFactor
_MaintenancePlanCatParam _MaintenancePlanCatParam
_UnitOfMeasure _MaintenanceCycle _UnitOfMeasure
_Language _MaintenanceCycle _Language
_MeasuringPoint _MaintenanceCycle _MeasuringPoint 
@AbapCatalog.sqlViewName: 'IMAINTPLANDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan Data'

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: [ 'MaintenancePlan' ]
@ObjectModel.semanticKey: [ 'MaintenancePlan' ]
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true

@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.byElement: {
      name: 'LastChangeDateTime'
    }
  }
}

@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #S
  }
}
@AbapCatalog.preserveKey:true 
@ObjectModel.modelingPattern:   #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #EXTRACTION_DATA_SOURCE ]

@VDM.lifecycle.status   : #DEPERECATED
@VDM.lifecycle.successor: 'C_MaintenancePlanDEX'
 
define view I_MaintenancePlanData 
    as select from I_MaintenancePlan
{     
        @ObjectModel.text.element: 'MaintenancePlanDesc'
    key MaintenancePlan,
        
        @Semantics.text: true
        MaintenancePlanDesc,
        
        @Semantics.systemDate.createdAt: true
        CreationDate,
        
        @Semantics.user.createdBy: true
        CreatedByUser,
        
        @Semantics.systemDate.lastChangedAt: true
        LastChangeDate,
        
        @Semantics.user.lastChangedBy: true
        LastChangedByUser,
        
        MaintenanceStrategy,
        
        SchedulingDuration,
        
        MaintPlanIsLockedAgainstCalls,
        
        NumberOfMaintenanceItems,
        
        MaintenanceCall,
        
        LateCompletionShiftFactor,
        
        EarlyCompletionShiftFactor,
        
        LateCompletionTolerancePercent,
        
        EarlyCompletionTolerancePct,
                
        CycleModificationRatio,
        
        MaintPlanSchedgIndicator,
        
        CallHorizonPercent,
        
        CallHorizonInDays,
        
        MaintenanceCallHorizonCalcType,
                
        LogicalOperator,
        
        AuthorizationGroup,
        
        @ObjectModel.foreignKey.association: '_MaintenancePlanCatParam'
        MaintenancePlanCategory,
        
        SchedulingDurationUnit,
        
        BasicStartDate,
        
        MaintSchedulingStartCounter,
        
        PrdcssrCallObjCompltnIsRqd,
       
        MaintPlanFreeDefinedAttrib,
        
        FactoryCalendar,
        
        MaintenanceLeadFloatInDays,
        
        SchedulingStartDate,
        
        SchedulingStartTime,
        
        MultipleCounterPlanShiftFactor,
        
        MaintSchedulingEndCounter,
      
        SchedulingEndDate,
        
        @Semantics.systemDateTime.lastChangedAt: true
        LastChangeDateTime,
            
        _MaintenanceCycle.NumberOfControlTableEntities,                           
    
        _MaintenanceCycle.ComparisonOperator,                           
        
        _MaintenanceCycle.MaintPlanCycleIntervalCount,
        
        @ObjectModel.foreignKey.association: '_UnitOfMeasure'
        _MaintenanceCycle.MaintenanceTaskPerformanceUnit,
        
        _MaintenanceCycle.MaintPlanCycleDesc,
        
        @ObjectModel.foreignKey.association: '_Language'
        _MaintenanceCycle.Language,                              
        
        @ObjectModel.foreignKey.association: '_MeasuringPoint'
        _MaintenanceCycle.MeasuringPoint,                     
               
        _MaintenanceCycle.MaintPlanCycleStartOffsetValue,      
        
        _MaintenanceCycle.EventSchedulingIsInactive,                                
        
        _MaintenanceCycle.CycleSetSequence,                                      
        
        _MaintenanceCycle.CycleSetSequenceRepeatFactor,                            
        
        /* Associations */
        _MaintenancePlanCatParam,
        _MaintenanceCycle._UnitOfMeasure,
        _MaintenanceCycle._Language,
        _MaintenanceCycle._MeasuringPoint
}

Learn More