C_CADocumentSumGLItem

DDL: C_CADOCUMENTSUMGLITEM Type: view_entity CONSUMPTION

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.

1 data source(s) 13 fields

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
KEY CompanyCode CompanyCode
KEY BusinessArea BusinessArea
KEY ChartOfAccounts ChartOfAccounts
KEY GLAccount GLAccount
KEY TransactionCurrency TransactionCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
NumberOfCADocumentGLItems NumberOfCADocumentGLItems
_CompCode _CompCode
_BusinessArea _BusinessArea
_GLAccount _GLAccount
_DocHeader _DocHeader
_ChartOfAccounts _ChartOfAccounts 
@EndUserText.label: 'Summarized CA General Ledger Items'

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.allowExtensions: true
define view entity C_CADocumentSumGLItem
  as select from P_CADocumentSumGLItem
{
      @ObjectModel.foreignKey.association: '_DocHeader'
  key CADocumentNumber,
      @ObjectModel.foreignKey.association: '_CompCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_BusinessArea'
  key BusinessArea,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_GLAccount'
  key GLAccount,
  
  key TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      CAAmountInTransactionCurrency,

      NumberOfCADocumentGLItems,
      /* Associations */
      _CompCode,
      _BusinessArea,
      _GLAccount,
      _DocHeader,
      _ChartOfAccounts
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CADOCUMENTSUMGLITEM"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_CADOCUMENTHEADER",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[
"P_CADOCUMENTSUMGLITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More