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.

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 G/L Account
KEY ChartOfAccounts ska1 ktopl G/L Chart of Accounts
KEY CompanyCode skb1 bukrs Value
GLAccountLongName skat txt50 Status Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CostElementVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICOSTELEMENTVH

CREATE VIEW I_CostElementVH AS
SELECT
  GLAccMaster.saknr AS GLAccount,
  GLAccMaster.ktopl AS ChartOfAccounts,
  GLAcccompanyCode.bukrs AS CompanyCode,
  GLAccMasterDesc.txt50 AS GLAccountLongName
FROM ska1 AS GLAccMaster
LEFT OUTER JOIN skat AS GLAccMasterDesc ON /* join condition not captured in parsed metadata */
INNER JOIN t001 AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN skb1 AS GLAcccompanyCode ON /* join condition not captured in parsed metadata */
;