C_CN_GLAcctVH

DDL: C_CN_GLACCTVH SQL: CVCNGLACCTVH Type: view CONSUMPTION
4 Fields 1 Data Sources

GL Account Value Help

C_CN_GLAcctVH is a Consumption CDS View that provides data about "GL Account Value Help" in SAP S/4HANA. It reads from 1 data source (I_GLAccount) and exposes 4 fields with key fields GLAccountName, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_GLAccount I_GLAccount from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CVCNGLACCTVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label GL Account Value Help view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY GLAccountName GLAccount General Ledger
KEY CompanyCode CompanyCode Receiver Company Code
ChartOfAccounts ChartOfAccounts Node Class
GLAccountLongName

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 C_CN_GLAcctVH.
-- 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: CVCNGLACCTVH
-- Parameters: P_Language : sylangu

CREATE VIEW C_CN_GLAcctVH AS
SELECT
  GLAccount AS GLAccountName,
  CompanyCode,
  ChartOfAccounts,
  cast(_Text[1:Language = $parameters.P_Language].GLAccountLongName as idcn_accountdesc) AS GLAccountLongName
FROM I_GLAccount
;

Learn More