C_CADocumentSumGLItem

DDL: C_CADOCUMENTSUMGLITEM Type: view_entity CONSUMPTION
13 Fields 1 Data Sources

Summarized CA General Ledger Items

C_CADocumentSumGLItem is a Consumption CDS View that provides data about "Summarized CA General Ledger Items" in SAP S/4HANA. It reads from 1 data source (P_CADocumentSumGLItem) and exposes 13 fields with key fields CADocumentNumber, CompanyCode, BusinessArea, ChartOfAccounts, GLAccount.

Data Sources (1)

SourceAliasJoin Type
P_CADocumentSumGLItem P_CADocumentSumGLItem from

Annotations (7)

NameValueLevelField
EndUserText.label Summarized CA General Ledger Items view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CompanyCode CompanyCode Receiver Company Code
KEY BusinessArea BusinessArea Business Area
KEY ChartOfAccounts ChartOfAccounts Node Class
KEY GLAccount GLAccount General Ledger
KEY TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
NumberOfCADocumentGLItems NumberOfCADocumentGLItems
_CompCode _CompCode
_BusinessArea _BusinessArea
_GLAccount _GLAccount
_DocHeader _DocHeader
_ChartOfAccounts _ChartOfAccounts

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_CADocumentSumGLItem.
-- 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.

CREATE VIEW C_CADocumentSumGLItem AS
SELECT
  CADocumentNumber,
  CompanyCode,
  BusinessArea,
  ChartOfAccounts,
  GLAccount,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  NumberOfCADocumentGLItems
FROM P_CADocumentSumGLItem
;

Learn More