I_BreakdownCategoryFieldText

DDL: I_BREAKDOWNCATEGORYFIELDTEXT Type: view BASIC

Breakdown Category Field Text

I_BreakdownCategoryFieldText is a Basic CDS View that provides data about "Breakdown Category Field Text" in SAP S/4HANA. It reads from 1 data source (dd04t) and exposes 4 fields with key field Language. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd04t dd04t from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBRKDWNCATFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey BreakdownCatFieldName view
VDM.viewType #BASIC view
EndUserText.label Breakdown Category Field Text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language
BreakdownCatDataElementName rollname
BreakdownCatFieldText
_Language _Language 
@AbapCatalog:{
  sqlViewName: 'IBRKDWNCATFT',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #B,
    sizeCategory: #S},
  dataCategory: #TEXT,
  representativeKey: 'BreakdownCatFieldName'
  }
@VDM.viewType: #BASIC
@EndUserText.label: 'Breakdown Category Field Text'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_BreakdownCategoryFieldText
  as select from dd04t

  association [1..1] to I_Language as _Language on $projection.Language = _Language.Language

{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key cast(ddlanguage as spras preserving type )            as Language,

  key case rollname
    when 'RTCUR' then 'RTCUR'
    when 'FC_BUPTR' then 'RBUPTR'
    when 'FC_SITYP' then 'SITYP'
    when 'FC_SITEM' then 'SUBIT'
    when 'FC_RYACQ' then 'YRACQ'
    when 'MEINS' then 'RUNIT'
    when 'RMVCT' then 'RMVCT'
    when 'FKBER' then 'RFAREA'
    when 'FC_RPACQ' then 'PRACQ'
    end                                                     as BreakdownCatFieldName,

      rollname                                              as BreakdownCatDataElementName,

      @Semantics.text
      cast ( scrtext_l as fincs_bdcfieldt preserving type ) as BreakdownCatFieldText,


      _Language
}
where
  (
       rollname   = 'RTCUR'
    or rollname   = 'FC_BUPTR'
    or rollname   = 'FC_SITYP'
    or rollname   = 'FC_SITEM'
    or rollname   = 'FC_RYACQ'
    or rollname   = 'MEINS'
    or rollname   = 'RMVCT'
    or rollname   = 'FKBER'
    or rollname   = 'FC_RPACQ'
  )
  and  as4local   = 'A';
//  and  ddlanguage = $session.system_language;

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD04T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More