C_CADocumentSumGLItem

DDL: C_CADOCUMENTSUMGLITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

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 2 OData services (UI_CAACCOUNTBALANCE_DISPLAY, UI_CADOCUMENT_MNG). Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

1 data source(s) Exposed by 2 service(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_CADocumentSumGLItem P_CADocumentSumGLItem from

Annotations (8)

NameValueLevelField
EndUserText.label Summarized CA General Ledger Items view
AccessControl.authorizationCheck #CHECK view
AccessControl.auditFilter #ENABLED 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 (2)

ServiceBindingVersionContractRelease
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED
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
_BusinessArea _BusinessArea
_CADocument _CADocument
_CompanyCode _CompanyCode
_GLAccount _GLAccount
_ChartOfAccounts _ChartOfAccounts 
@EndUserText.label: 'Summarized CA General Ledger Items'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.auditFilter: #ENABLED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@Consumption.dbHints:['USE_HEX_PLAN']
@Metadata.allowExtensions: true
define view entity C_CADocumentSumGLItem
  as select from P_CADocumentSumGLItem
{
      @ObjectModel.foreignKey.association: '_CADocument'
  key CADocumentNumber,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  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 */
      _BusinessArea,
      _CADocument,
      _CompanyCode,
      _GLAccount,
      _ChartOfAccounts
}

Learn More