P_IL_DepositDocument01

DDL: P_IL_DEPOSITDOCUMENT01 Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_DEPDOCMGMT

Deposit Documents Viewer

P_IL_DepositDocument01 is a Composite CDS View that provides data about "Deposit Documents Viewer" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_IL_PaymentItem) and exposes 6 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package RAP_GLO_FIN_CASH_IL_DEPDOCMGMT.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry Document from
I_IL_PaymentItem PaymentItem inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Deposit Documents Viewer view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
TransactionCurrency I_IL_PaymentItem TransactionCurrency
NumberOfCheques
IL_CashNumberKey I_IL_PaymentItem IL_CashNumberKey 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Deposit Documents Viewer'
@VDM: {private: true, viewType: #COMPOSITE }
@ObjectModel: { usageType: { dataClass: #TRANSACTIONAL ,
                             serviceQuality: #C,
                             sizeCategory: #M }}
define root view entity P_IL_DepositDocument01
  as select from I_JournalEntry   as Document
    inner join   I_IL_PaymentItem as PaymentItem on  Document.CompanyCode         = PaymentItem.ReferenceCompanyCode
                                                 and Document.FiscalYear          = PaymentItem.ReferenceFiscalYear
                                                 and Document.AccountingDocument  = PaymentItem.RefAccountingDocument
                                                 and PaymentItem.IL_PaymentStatus = 'DE'
                                                 and PaymentItem.IL_PaymentMethod = 'CE'
{
  key Document.CompanyCode,
  key Document.FiscalYear,
  key Document.AccountingDocument,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(
        sum(PaymentItem.IL_PaytItmAmountInDocCrcy)
      as wrbtr preserving type )                                     as IL_PaytItmAmountInDocCrcy,

      PaymentItem.TransactionCurrency,

      cast( count( * ) as  gsfincsil_cheques_count preserving type ) as NumberOfCheques,

      PaymentItem.IL_CashNumberKey                                   as IL_CashNumberKey

}
group by
  Document.CompanyCode,
  Document.FiscalYear,
  Document.AccountingDocument,
  PaymentItem.TransactionCurrency,
  PaymentItem.IL_CashNumberKey

Learn More