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. It is exposed through 1 OData service (UI_CADOCUMENT_MNG).

1 data source(s) Exposed by 1 service(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

OData Services (1)

ServiceBindingVersionContractRelease
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED

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
}

Learn More