I_CostElementVH

DDL: I_COSTELEMENTVH SQL: ICOSTELEMENTVH Type: view BASIC

Cost Element Value Help

I_CostElementVH is a Basic CDS View that provides data about "Cost Element Value Help" in SAP S/4HANA. It reads from 4 data sources (t001, skb1, ska1, skat) and exposes 4 fields with key fields GLAccount, ChartOfAccounts, CompanyCode.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
t001 CompanyCode inner
skb1 GLAcccompanyCode inner
ska1 GLAccMaster from
skat GLAccMasterDesc left_outer

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICOSTELEMENTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Element Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #BASIC view
ObjectModel.representativeKey GLAccount view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.compositionRoot true view
Consumption.ranked true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GLAccount ska1 saknr
KEY ChartOfAccounts ska1 ktopl
KEY CompanyCode skb1 bukrs
GLAccountLongName skat txt50 
@AbapCatalog.sqlViewName: 'ICOSTELEMENTVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost Element Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@VDM.viewType:#BASIC
@ObjectModel.representativeKey: 'GLAccount'
@ObjectModel.usageType: {serviceQuality: #B ,sizeCategory: #XL , dataClass : #CUSTOMIZING}
@ObjectModel.dataCategory: #VALUE_HELP
//@Analytics: { dataExtraction.enabled: true }

@ObjectModel.compositionRoot:true
@Consumption.ranked: true

define view I_CostElementVH as select from ska1 as GLAccMaster                      
                              left outer 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             
     {
     
        @EndUserText:{ label:'G/L Account', quickInfo:'G/L Account' }
        @Search.defaultSearchElement: true
        @Search.ranking: #HIGH
        @Search.fuzzinessThreshold: 0.8
    key GLAccMaster.saknr   as GLAccount,    
        @EndUserText:{ label:'Chart of Accounts', quickInfo:'Chart of Accounts' }
    key GLAccMaster.ktopl  as ChartOfAccounts,   
        @EndUserText:{ label:'Company Code', quickInfo:'Company Code' }
    key GLAcccompanyCode.bukrs as CompanyCode,   
        @EndUserText:{ label:'G/L Account Description', quickInfo:'G/L Account Description' }
        @Search.defaultSearchElement: true
        @Search.ranking: #LOW
        @Search.fuzzinessThreshold: 0.8
        GLAccMasterDesc.txt50  as GLAccountLongName             
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKA1",
"SKAT",
"SKB1",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More