P_CADocumentSumGLItem

DDL: P_CADOCUMENTSUMGLITEM Type: view_entity COMPOSITE

Summarized CA General Ledger Items

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

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocumentGLItem I_CADocumentGLItem from

Annotations (7)

NameValueLevelField
EndUserText.label Summarized CA General Ledger Items view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
VDM.private 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 Amount
NumberOfCADocumentGLItems Number
_CompCode _CompCode
_BusinessArea _BusinessArea
_GLAccount _GLAccount
_DocHeader _DocHeader
_ChartOfAccounts _ChartOfAccounts 
@EndUserText.label: 'Summarized CA General Ledger Items'

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CADocumentSumGLItem
  as select from I_CADocumentGLItem

{
      @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'
      @EndUserText.label: 'Amount'
      cast(sum(CAAmountInTransactionCurrency) as betrw_kk ) as CAAmountInTransactionCurrency,

      @EndUserText.label: 'Number'
      count(*)                           as NumberOfCADocumentGLItems,

      //Associations

      _CompCode,
      _BusinessArea,
      _GLAccount,
      _DocHeader,
      _ChartOfAccounts
}
group by
  CADocumentNumber,
  CompanyCode,
  BusinessArea,
  ChartOfAccounts,
  GLAccount,
  TransactionCurrency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTGLITEM"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_CADOCUMENTHEADER",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[
"I_CADOCUMENTGLITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More