C_CnsldtnChartOfAccountsVH

DDL: C_CNSLDTNCHARTOFACCOUNTSVH SQL: CCCHOFACCVH Type: view CONSUMPTION Package: FIN_CS_MD_CHARTOFACCOUNTS
2 Fields 1 Data Sources 13 OData Services

Consolidation Chart of Accounts

C_CnsldtnChartOfAccountsVH is a Consumption CDS View that provides data about "Consolidation Chart of Accounts" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnChartOfAccounts) and exposes 2 fields with key field ConsolidationChartOfAccounts. It is exposed through 13 OData services (ASQL_F2573, ASQL_F2971, ASQL_F3333, ...). Part of development package FIN_CS_MD_CHARTOFACCOUNTS.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnChartOfAccounts I_CnsldtnChartOfAccounts from

Annotations (15)

NameValueLevelField
EndUserText.label Consolidation Chart of Accounts view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCCHOFACCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
Consumption.ranked true view
ObjectModel.semanticKey ConsolidationChartOfAccounts view
ObjectModel.representativeKey ConsolidationChartOfAccounts view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

OData Services (13)

ServiceBindingVersionContractRelease
ASQL_F2573 ASQL_F2573 C2 NOT_RELEASED
ASQL_F2971 ASQL_F2971 C2 NOT_RELEASED
ASQL_F3333 ASQL_F3333 C2 NOT_RELEASED
ASQL_F3334 ASQL_F3334 C2 NOT_RELEASED
ASQL_F3335 ASQL_F3335 C2 NOT_RELEASED
ASQL_F3831 ASQL_F3831 C2 NOT_RELEASED
ASQL_F3924 ASQL_F3924 C2 NOT_RELEASED
ASQL_F6164 ASQL_F6164 C2 NOT_RELEASED
ASQL_F7093 ASQL_F7093 C2 NOT_RELEASED
ASQL_F7271 ASQL_F7271 C2 NOT_RELEASED
ASQL_F8339 ASQL_F8339 C2 NOT_RELEASED
ASQL_F8586 ASQL_F8586 C2 NOT_RELEASED
UI_FINCS_GRPTSKRUN_MONITOR UI_FINCS_GRPTSKRUN_MONITOR V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ConsolidationChartOfAcctsText

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_CnsldtnChartOfAccountsVH.
-- 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: CCCHOFACCVH

CREATE VIEW C_CnsldtnChartOfAccountsVH AS
SELECT
  ConsolidationChartOfAccounts,
  _Text[1: Language = $session.system_language].ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText
FROM I_CnsldtnChartOfAccounts
;

Learn More