I_MaintPlanningBucketTypeText

DDL: I_MAINTPLANNINGBUCKETTYPETEXT Type: view BASIC Package: EAM_PLANNINGBUCKET

Maintenance Planning Bucket Type

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

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[1] I_Language _Language _Language.Language = $projection.Language
[1] I_MaintPlanningBucketType _PlanningBucketType _PlanningBucketType.MaintPlanningBucketType = $projection.MaintPlanningBucketType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPLNGBKTTYT view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Planning Bucket Type view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaintPlanningBucketType dd07t domvalue_l
MaintPlanningBucketType
KEY Language dd07t ddlanguage
Language
MaintPlanningBucketTypeText
_PlanningBucketType _PlanningBucketType
_Language _Language 
@AbapCatalog: {sqlViewName: 'IPLNGBKTTYT', compiler.compareFilter, preserveKey }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planning Bucket Type'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  dataCategory: #TEXT,  
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S } }

@VDM.viewType: #BASIC

// Note: Reading of DD07L + Usage of coalesce is a temporary workaround until CE Content is delivered


define view I_MaintPlanningBucketTypeText
  as select from           dd07t
    left outer to one join eam_plngbktty_t on  eam_plngbktty_t.maintplanningbuckettype = dd07t.domvalue_l
                                           and eam_plngbktty_t.language                = dd07t.ddlanguage
  association [1] to I_Language                as _Language           on _Language.Language = $projection.Language
  association [1] to I_MaintPlanningBucketType as _PlanningBucketType on _PlanningBucketType.MaintPlanningBucketType = $projection.MaintPlanningBucketType
{
      @ObjectModel.foreignKey.association: '_PlanningBucketType'
      @ObjectModel.text.element: ['MaintPlanningBucketTypeText']
  key dd07t.domvalue_l           as MaintPlanningBucketType,
      --key maintplanningbuckettype     as MaintPlanningBucketType,
      @Semantics.language
      @ObjectModel.foreignKey.association: '_Language'
  key dd07t.ddlanguage           as Language,
      --key language                    as Language,

      @Semantics.text
      cast( coalesce( maintplanningbuckettypetext, dd07t.ddtext )
        as eam_plngbkttypetext ) as MaintPlanningBucketTypeText,
      --maintplanningbuckettypetext as MaintPlanningBucketTypeText,

      _PlanningBucketType,
      _Language
}
where
      dd07t.domname  = 'EAM_PLNGBKTTYPE'
  and dd07t.as4local = 'A'

Learn More