I_MaintenancePlanStatus

DDL: I_MAINTENANCEPLANSTATUS Type: view_entity COMPOSITE Package: VDM_EAM_MAINTENANCEPLAN

Maintenance Plan System Status

I_MaintenancePlanStatus is a Composite CDS View (Dimension) that provides data about "Maintenance Plan System Status" in SAP S/4HANA. It reads from 1 data source (I_MaintenancePlanBasic) and exposes 8 fields with key field MaintenancePlan. Part of development package VDM_EAM_MAINTENANCEPLAN.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanBasic I_MaintenancePlanBasic from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan System Status view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName IMPLANSTATUS view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan I_MaintenancePlanBasic MaintenancePlan
MaintPlanIsMarkedForDeletion
MaintenancePlanIsInactive
MaintenancePlanIsScheduled
MaintenancePlanIsCreated
AuthorizationGroup AuthorizationGroup
MaintenancePlanCategory MaintenancePlanCategory
_MaintenancePlanCatParam _MaintenancePlanCatParam 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan System Status'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #COMPOSITE
@Analytics.dataCategory : #DIMENSION
@Analytics.technicalName: 'IMPLANSTATUS'
@Metadata.allowExtensions:true
@Analytics.internalName:#LOCAL

define view entity I_MaintenancePlanStatus as select from I_MaintenancePlanBasic

{
  key I_MaintenancePlanBasic.MaintenancePlan,
      sum( case when I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusCode = 'I0076' and I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusIsActive  = 'X' then 1  end ) as MaintPlanIsMarkedForDeletion ,
      sum( case when I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusCode = 'I0320' and I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusIsActive  = 'X' then 1  end ) as MaintenancePlanIsInactive ,
      sum( case when I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusCode = 'I0001'  and MaintenanceCall != 0  then 1 end ) as MaintenancePlanIsScheduled ,
      sum( case when I_MaintenancePlanBasic._StatusObjectActiveStatus.StatusCode = 'I0001' and MaintenanceCall = 0 then 1  end ) as MaintenancePlanIsCreated  ,
      
      // fields for DCL

      AuthorizationGroup  ,
      MaintenancePlanCategory,
      _MaintenancePlanCatParam     
}   
where ( I_MaintenancePlanBasic._MaintenancePlanCatParam.MaintenancePlanCallObject is initial or I_MaintenancePlanBasic._MaintenancePlanCatParam.MaintenancePlanCallObject = '2' or MaintenancePlanCallObject = '5' ) 
        and I_MaintenancePlanBasic._MaintenancePlanCatParam.MaintPlanHasContract <> 'X'
        
group by I_MaintenancePlanBasic.MaintenancePlan,
      AuthorizationGroup  ,
      MaintenancePlanCategory

Learn More