R_CostCenterText

DDL: R_COSTCENTERTEXT Type: view_entity BASIC Package: ODATA_CA_BUM_WF

Cost Center Text

R_CostCenterText is a Basic CDS View that provides data about "Cost Center Text" in SAP S/4HANA. It reads from 1 data source (csks) and exposes 8 fields with key fields CostCenter, ControllingArea, ValidityEndDate, Language. It has 1 association to related views. Part of development package ODATA_CA_BUM_WF.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
csks csks from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CostCenter view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
EndUserText.label Cost Center Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CostCenter csks kostl
KEY ControllingArea csks kokrs
KEY ValidityEndDate csks datbi
KEY Language _CostCenterText spras
ValidityStartDate csks datab
CostCenterName
CostCenterDescription _CostCenterText ltext
_ControllingArea _ControllingArea 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey:'CostCenter'
@Consumption.ranked:true
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Search.searchable: true
@EndUserText.label: 'Cost Center Text'
@ObjectModel.dataCategory: #TEXT

@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #MASTER
}
define view entity R_CostCenterText


  as select from           csks
    left outer to one join cskt as _CostCenterText on  _CostCenterText.kostl = csks.kostl
                                                   and _CostCenterText.kokrs = csks.kokrs
                                                   and _CostCenterText.datbi = csks.datbi
                                                   and _CostCenterText.spras = $session.system_language
  association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
{
  key csks.kostl                                                          as CostCenter,
      @ObjectModel.foreignKey.association: '_ControllingArea'
  key csks.kokrs                                                          as ControllingArea,
      @Semantics.businessDate.to: true
  key csks.datbi                                                          as ValidityEndDate,
      @Semantics.language: true
  key _CostCenterText.spras                                               as Language,
      @Semantics.businessDate.from: true
      csks.datab                                                          as ValidityStartDate,
      @Search.defaultSearchElement: true
      cast(_CostCenterText.ktext as eams_costcenter_desc preserving type) as CostCenterName,
      @Search.defaultSearchElement: true
      @Semantics.text: true
      _CostCenterText.ltext                                               as CostCenterDescription,
      _ControllingArea
}
//

//  as select distinct from csks

//  association [1]    to I_ControllingArea as _ControllingArea on  $projection.ControllingArea = _ControllingArea.ControllingArea

//  association [0..*] to I_CostCenterText  as _CostCenterText  on  $projection.ControllingArea = _CostCenterText.ControllingArea

//                                                              and $projection.CostCenter      = _CostCenterText.CostCenter

//                                                              and $projection.ValidityEndDate = _CostCenterText.ValidityEndDate

//{

////      @Search.defaultSearchElement: true

////      @Search.fuzzinessThreshold: 0.8

//      @ObjectModel.text.association: '_CostCenterText'

//  key csks.kostl as CostCenter,

//      @ObjectModel.foreignKey.association: '_ControllingArea'

//  key csks.kokrs as ControllingArea,

//      @Semantics.businessDate.to: true

//  key csks.datbi as ValidityEndDate,

//      @Semantics.businessDate.from: true

//      csks.datab as ValidityStartDate,

//      _CostCenterText,

//      _ControllingArea

//}

Learn More