I_ChartOfAccountsStdVH

DDL: I_CHARTOFACCOUNTSSTDVH SQL: IFICOA__VH Type: view COMPOSITE Package: FINS_CHART_OF_ACCOUNTS_VDM

Chart Of Accounts

I_ChartOfAccountsStdVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_ChartOfAccountsStdVH is a Composite CDS View that provides data about "Chart Of Accounts" in SAP S/4HANA. It reads from 1 data source (I_ChartOfAccounts) and exposes 2 fields with key field ChartOfAccounts. It is exposed through 123 OData services (ASQL_F0547B, ASQL_F0731A, ASQL_F0731B, ...). Part of development package FINS_CHART_OF_ACCOUNTS_VDM.

SAP Help Documentation

CategoryChart of Accounts
Purpose
This view provides value help for the chart of accounts ( KTOPL ). This view should be used for value help purposes only. If you intend to select the entire business data, use the Chart of Accounts ( I_ChartOfAccounts ) view instead.

Prerequisites
Authorizations The General Ledger - Master Data for Chart of Accounts ( SAP_FIN_BC_GL_MD_COA_PC ) business catalogs should be assigned to a user to be able to use this CDS view.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-N-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source for Search,Data Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This view provides value help for the chart of accounts (KTOPL).</p> <p>This view should be used for value help purposes only. If you intend to select the entire business data, use the Chart of Accounts (I_ChartOfAccounts) view instead.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ChartOfAccounts I_ChartOfAccounts from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFICOA__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ChartOfAccounts view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Chart Of Accounts view

OData Services (123)

ServiceBindingVersionContractRelease
ASQL_F0547B ASQL_F0547B C2 NOT_RELEASED
ASQL_F0731A ASQL_F0731A C2 NOT_RELEASED
ASQL_F0731B ASQL_F0731B C2 NOT_RELEASED
ASQL_F0763B ASQL_F0763B C2 NOT_RELEASED
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F0997 ASQL_F0997 C2 NOT_RELEASED
ASQL_F1421 ASQL_F1421 C2 NOT_RELEASED
ASQL_F1564 ASQL_F1564 C2 NOT_RELEASED
ASQL_F1605A ASQL_F1605A C2 NOT_RELEASED
ASQL_F1665 ASQL_F1665 C2 NOT_RELEASED
ASQL_F1755 ASQL_F1755 C2 NOT_RELEASED
ASQL_F1865 ASQL_F1865 C2 NOT_RELEASED
ASQL_F2009 ASQL_F2009 C2 NOT_RELEASED
ASQL_F2095 ASQL_F2095 C2 NOT_RELEASED
ASQL_F2096 ASQL_F2096 C2 NOT_RELEASED
ASQL_F2218 ASQL_F2218 C2 NOT_RELEASED
ASQL_F2420 ASQL_F2420 C2 NOT_RELEASED
ASQL_F2421 ASQL_F2421 C2 NOT_RELEASED
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED
ASQL_F2445 ASQL_F2445 C2 NOT_RELEASED
ASQL_F2547 ASQL_F2547 C2 NOT_RELEASED
ASQL_F2564 ASQL_F2564 C2 NOT_RELEASED
ASQL_F2596 ASQL_F2596 C2 NOT_RELEASED
ASQL_F2681 ASQL_F2681 C2 NOT_RELEASED
ASQL_F2691 ASQL_F2691 C2 NOT_RELEASED
ASQL_F2720 ASQL_F2720 C2 NOT_RELEASED
ASQL_F2740 ASQL_F2740 C2 NOT_RELEASED
ASQL_F2873 ASQL_F2873 C2 NOT_RELEASED
ASQL_F2876 ASQL_F2876 C2 NOT_RELEASED
ASQL_F2917 ASQL_F2917 C2 NOT_RELEASED
ASQL_F2935 ASQL_F2935 C2 NOT_RELEASED
ASQL_F2964 ASQL_F2964 C2 NOT_RELEASED
ASQL_F2986 ASQL_F2986 C2 NOT_RELEASED
ASQL_F3029 ASQL_F3029 C2 NOT_RELEASED
ASQL_F3072 ASQL_F3072 C2 NOT_RELEASED
ASQL_F3078 ASQL_F3078 C2 NOT_RELEASED
ASQL_F3096 ASQL_F3096 C2 NOT_RELEASED
ASQL_F3098 ASQL_F3098 C2 NOT_RELEASED
ASQL_F3215 ASQL_F3215 C2 NOT_RELEASED
ASQL_F3302 ASQL_F3302 C2 NOT_RELEASED
ASQL_F3303 ASQL_F3303 C2 NOT_RELEASED
ASQL_F3331 ASQL_F3331 C2 NOT_RELEASED
ASQL_F3333 ASQL_F3333 C2 NOT_RELEASED
ASQL_F3334 ASQL_F3334 C2 NOT_RELEASED
ASQL_F3338A ASQL_F3338A C2 NOT_RELEASED
ASQL_F3398 ASQL_F3398 C2 NOT_RELEASED
ASQL_F3417 ASQL_F3417 C2 NOT_RELEASED
ASQL_F3446 ASQL_F3446 C2 NOT_RELEASED
ASQL_F3516 ASQL_F3516 C2 NOT_RELEASED
ASQL_F3549 ASQL_F3549 C2 NOT_RELEASED
ASQL_F3555 ASQL_F3555 C2 NOT_RELEASED
ASQL_F3567 ASQL_F3567 C2 NOT_RELEASED
ASQL_F3751 ASQL_F3751 C2 NOT_RELEASED
ASQL_F3775 ASQL_F3775 C2 NOT_RELEASED
ASQL_F3799 ASQL_F3799 C2 NOT_RELEASED
ASQL_F3822 ASQL_F3822 C2 NOT_RELEASED
ASQL_F3867 ASQL_F3867 C2 NOT_RELEASED
ASQL_F3888 ASQL_F3888 C2 NOT_RELEASED
ASQL_F3900 ASQL_F3900 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED
ASQL_F3991 ASQL_F3991 C2 NOT_RELEASED
ASQL_F4001 ASQL_F4001 C2 NOT_RELEASED
ASQL_F4008 ASQL_F4008 C2 NOT_RELEASED
ASQL_F4011 ASQL_F4011 C2 NOT_RELEASED
ASQL_F4022 ASQL_F4022 C2 NOT_RELEASED
ASQL_F4095 ASQL_F4095 C2 NOT_RELEASED
ASQL_F4173 ASQL_F4173 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4174 ASQL_F4174 C2 NOT_RELEASED
ASQL_F4175 ASQL_F4175 C2 NOT_RELEASED
ASQL_F4272 ASQL_F4272 C2 NOT_RELEASED
ASQL_F4307 ASQL_F4307 C2 NOT_RELEASED
ASQL_F4345 ASQL_F4345 C2 NOT_RELEASED
ASQL_F4366 ASQL_F4366 C2 NOT_RELEASED
ASQL_F4367 ASQL_F4367 C2 NOT_RELEASED
ASQL_F4423 ASQL_F4423 C2 NOT_RELEASED
ASQL_F4424 ASQL_F4424 C2 NOT_RELEASED
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED
ASQL_F4568 ASQL_F4568 C2 NOT_RELEASED
ASQL_F4597 ASQL_F4597 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4763 ASQL_F4763 C2 NOT_RELEASED
ASQL_F4857 ASQL_F4857 C2 NOT_RELEASED
ASQL_F5133 ASQL_F5133 C2 NOT_RELEASED
ASQL_F5293 ASQL_F5293 C2 NOT_RELEASED
ASQL_F5342 ASQL_F5342 C2 NOT_RELEASED
ASQL_F5370 ASQL_F5370 C2 NOT_RELEASED
ASQL_F5371 ASQL_F5371 C2 NOT_RELEASED
ASQL_F5372 ASQL_F5372 C2 NOT_RELEASED
ASQL_F5373 ASQL_F5373 C2 NOT_RELEASED
ASQL_F5763 ASQL_F5763 C2 NOT_RELEASED
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F6061 ASQL_F6061 C2 NOT_RELEASED
ASQL_F6108 ASQL_F6108 C2 NOT_RELEASED
ASQL_F6109 ASQL_F6109 C2 NOT_RELEASED
ASQL_F6459 ASQL_F6459 C2 NOT_RELEASED
ASQL_F6621 ASQL_F6621 C2 NOT_RELEASED
ASQL_F6785 ASQL_F6785 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F7061 ASQL_F7061 C2 NOT_RELEASED
ASQL_F7100 ASQL_F7100 C2 NOT_RELEASED
ASQL_F7103 ASQL_F7103 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
ASQL_F7343 ASQL_F7343 C2 NOT_RELEASED
ASQL_F7344 ASQL_F7344 C2 NOT_RELEASED
ASQL_F7411 ASQL_F7411 C2 NOT_RELEASED
ASQL_F7738 ASQL_F7738 C2 NOT_RELEASED
ASQL_F7739 ASQL_F7739 C2 NOT_RELEASED
ASQL_F7740 ASQL_F7740 C2 NOT_RELEASED
ASQL_F7741 ASQL_F7741 C2 NOT_RELEASED
ASQL_F7795 ASQL_F7795 C2 NOT_RELEASED
ASQL_F7796 ASQL_F7796 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED
ASQL_F8134 ASQL_F8134 C2 NOT_RELEASED
ASQL_F8417 ASQL_F8417 C2 NOT_RELEASED
ASQL_F8654 ASQL_F8654 C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts Chart of Accounts
_Text _Text

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_ChartOfAccountsStdVH.
-- 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: IFICOA__VH

CREATE VIEW I_ChartOfAccountsStdVH AS
SELECT
  ChartOfAccounts
FROM I_ChartOfAccounts
;