P_CADOCUMENTSUMGLITEM

CDS View

Summarized CA General Ledger Items

P_CADOCUMENTSUMGLITEM is a CDS View in S/4HANA. Summarized CA General Ledger Items. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CADocumentSumGLItem view_entity from CONSUMPTION Summarized CA General Ledger Items 
@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