I_ProjStkCostElementText

DDL: I_PROJSTKCOSTELEMENTTEXT Type: view_entity COMPOSITE

Cost Element - Text

I_ProjStkCostElementText is a Composite CDS View that provides data about "Cost Element - Text" in SAP S/4HANA. It reads from 3 data sources (t001, skb1, ska1) and exposes 5 fields with key fields GLAccount, ChartOfAccounts, CompanyCode, Language.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
t001 CompanyCode inner
skb1 GLAcccompanyCode inner
ska1 GLAccMaster from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Element - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY GLAccount ska1 saknr
KEY ChartOfAccounts ska1 ktopl
KEY CompanyCode skb1 bukrs
KEY Language
CostElementName GLAccMasterDesc txt20 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost Element - Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #COMPOSITE

define view entity I_ProjStkCostElementText
  as select from            ska1 as GLAccMaster
    left outer to many join skat as GLAccMasterDesc  on  GLAccMaster.saknr     = GLAccMasterDesc.saknr
                                                     and GLAccMaster.ktopl     = GLAccMasterDesc.ktopl
                                                     and GLAccMasterDesc.spras = $session.system_language
    inner join              t001 as CompanyCode      on GLAccMaster.ktopl = CompanyCode.ktopl
    inner join              skb1 as GLAcccompanyCode on  GLAccMaster.saknr      = GLAcccompanyCode.saknr
                                                     and GLAcccompanyCode.bukrs = CompanyCode.bukrs
{

  key GLAccMaster.saknr      as GLAccount,
  key GLAccMaster.ktopl      as ChartOfAccounts,
  key GLAcccompanyCode.bukrs as CompanyCode,
      @Semantics.language: true
  key $session.system_language as Language,
      @Semantics.text:true
      GLAccMasterDesc.txt20  as CostElementName
}

Learn More