I_MaintPlanningBucketType

DDL: I_MAINTPLANNINGBUCKETTYPE Type: view BASIC Package: EAM_PLANNINGBUCKET

Maintenance Planning Bucket Type

I_MaintPlanningBucketType is a Basic CDS View that provides data about "Maintenance Planning Bucket Type" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 4 fields with key field MaintPlanningBucketType. It has 3 associations to related views. Part of development package EAM_PLANNINGBUCKET.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (3)

CardinalityTargetAliasCondition
[*] I_MaintPlanningBucketTypeText _Text _Text.MaintPlanningBucketType = $projection.MaintPlanningBucketType
[1] I_Indicator _MaintPlngBcktTypeIsInactive _MaintPlngBcktTypeIsInactive.IndicatorValue = $projection.MaintPlngBcktTypeIsInactive
[1] I_Indicator _MaintPlngBcktTypeRcrrcIsAllwd _MaintPlngBcktTypeRcrrcIsAllwd.IndicatorValue = $projection.MaintPlngBcktTypeRcrrcIsAllwd

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPLNGBKTTY view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Planning Bucket Type view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaintPlanningBucketType view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketType
_Text _Text
_MaintPlngBcktTypeIsInactive _MaintPlngBcktTypeIsInactive
_MaintPlngBcktTypeRcrrcIsAllwd _MaintPlngBcktTypeRcrrcIsAllwd 
@AbapCatalog: {sqlViewName: 'IPLNGBKTTY', compiler.compareFilter, preserveKey }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planning Bucket Type'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  resultSet.sizeCategory: #XS,
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S } }

@VDM.viewType: #BASIC
 @ObjectModel.representativeKey: 'MaintPlanningBucketType'
// Note: Reading of DD07L + Usage of coalesce is a temporary workaround until CE Content is delivered


define view I_MaintPlanningBucketType
  as select from           dd07l
    left outer to one join eam_plngbktty on eam_plngbktty.maintplanningbuckettype = dd07l.domvalue_l
  association [*] to I_MaintPlanningBucketTypeText as _Text                          on _Text.MaintPlanningBucketType = $projection.MaintPlanningBucketType
  association [1] to I_Indicator                   as _MaintPlngBcktTypeIsInactive   on _MaintPlngBcktTypeIsInactive.IndicatorValue = $projection.MaintPlngBcktTypeIsInactive
  association [1] to I_Indicator                   as _MaintPlngBcktTypeRcrrcIsAllwd on _MaintPlngBcktTypeRcrrcIsAllwd.IndicatorValue = $projection.MaintPlngBcktTypeRcrrcIsAllwd
{
      @ObjectModel.text.association: '_Text'
  key cast( dd07l.domvalue_l as eam_plngbkttype )      as MaintPlanningBucketType,

      cast( coalesce( maintplngbckttypeisinactive, '' )
        as eam_plngbkttypeinactive preserving type )   as MaintPlngBcktTypeIsInactive,
      cast( case dd07l.domvalue_l when 'OPR' then 'X'
            else coalesce( maintplngbckttypercrrcisallwd, '' ) end
        as eam_plngbkttypercrrcallwd preserving type ) as MaintPlngBcktTypeRcrrcIsAllwd,

      _Text,
      _MaintPlngBcktTypeIsInactive,
      _MaintPlngBcktTypeRcrrcIsAllwd
}
where
      dd07l.domname  = 'EAM_PLNGBKTTYPE'
  and dd07l.as4local = 'A'

Learn More