I_MaintenancePlanStatus

DDL: I_MAINTENANCEPLANSTATUS SQL: IMPLANSTATUS Type: view COMPOSITE

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.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenancePlanBasic I_MaintenancePlanBasic from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPLANSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
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
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION 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 
@AbapCatalog.sqlViewName: 'IMPLANSTATUS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan System Status'

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

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@Analytics.dataCategory : #DIMENSION
@Metadata.allowExtensions:true
@Analytics.internalName:#LOCAL

define view I_MaintenancePlanStatus as select from I_MaintenancePlanBasic

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

      AuthorizationGroup  ,
      MaintenancePlanCategory,
      _MaintenancePlanCatParam     
}   
where ( _MaintenancePlanCatParam.MaintenancePlanCallObject is initial or _MaintenancePlanCatParam.MaintenancePlanCallObject = '2' or MaintenancePlanCallObject = '5' ) 
        and _MaintenancePlanCatParam.MaintPlanHasContract <> 'X'
        
group by I_MaintenancePlanBasic.MaintenancePlan,
      AuthorizationGroup  ,
      MaintenancePlanCategory
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANCATPARAM",
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_MAINTENANCEPLANCATPARAM"
],
"BASE":
[
"I_MAINTENANCEPLANBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More