I_IL_IncomingPaymentCashItem

DDL: I_IL_INCOMINGPAYMENTCASHITEM Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_INCOMPMT

Payment Cash Item in IL Cashier System

I_IL_IncomingPaymentCashItem is a Composite CDS View that provides data about "Payment Cash Item in IL Cashier System" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_IL_PaymentItem) and exposes 21 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 1 association to related views. Part of development package RAP_GLO_FIN_CASH_IL_INCOMPMT.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem DocItem from
I_IL_PaymentItem PaymentItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_OperationalAcctgDocItem _DocItems _DocItems.CompanyCode = $projection.CompanyCode and _DocItems.AccountingDocument = $projection.AccountingDocument and _DocItems.FiscalYear = $projection.FiscalYear

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Payment Cash Item in IL Cashier System view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
IL_IdentifierCashPaymentItem I_OperationalAcctgDocItem PaymentReference
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency
DocumentItemText I_OperationalAcctgDocItem DocumentItemText
PaymentMethod I_IL_PaymentItem PaymentMethod
IL_PaytItmAmountInDocCrcy I_IL_PaymentItem IL_PaytItmAmountInDocCrcy
IL_PaymentStatus I_IL_PaymentItem IL_PaymentStatus
IL_CashNumberKey I_IL_PaymentItem IL_CashNumberKey
Customer I_IL_PaymentItem Customer
Supplier I_IL_PaymentItem Supplier
GLAccount I_IL_PaymentItem GLAccount
_IncomingPayment _IncomingPayment
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_TransactionCurrency I_OperationalAcctgDocItem _TransactionCurrency
_DocItems _DocItems 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel: { usageType: { serviceQuality: #C,
                             sizeCategory: #XL,
                             dataClass: #MIXED } }

@EndUserText.label: 'Payment Cash Item in IL Cashier System'


define view entity I_IL_IncomingPaymentCashItem
  as

  select from  I_OperationalAcctgDocItem as DocItem

    inner join I_IL_PaymentItem          as PaymentItem on  PaymentItem.IL_IdentifierCashPaymentItem = DocItem.PaymentReference
                                                        and PaymentItem.CompanyCode                  = DocItem.CompanyCode
                                                        and PaymentItem.FiscalYear                   = DocItem.FiscalYear
                                                        and PaymentItem.AccountingDocument           = DocItem.AccountingDocument
                                                        and PaymentItem.IL_PaymentMethod             = 'CS' --<--- Cash Item

  association        to parent I_IL_IncomingPaymentDocument as _IncomingPayment on  _IncomingPayment.CompanyCode        = $projection.CompanyCode
                                                                                and _IncomingPayment.FiscalYear         = $projection.FiscalYear
                                                                                and _IncomingPayment.AccountingDocument = $projection.AccountingDocument

  association [1..*] to I_OperationalAcctgDocItem           as _DocItems        on  _DocItems.CompanyCode        = $projection.CompanyCode
                                                                                and _DocItems.AccountingDocument = $projection.AccountingDocument
                                                                                and _DocItems.FiscalYear         = $projection.FiscalYear

{

  key    DocItem.CompanyCode,
  key    DocItem.FiscalYear,
  key    DocItem.AccountingDocument,
  key    DocItem.AccountingDocumentItem,

         DocItem.PaymentReference as IL_IdentifierCashPaymentItem,
         DocItem.TransactionCurrency,
         @Semantics.amount.currencyCode: 'TransactionCurrency'
         DocItem.AmountInTransactionCurrency,
         DocItem.DocumentItemText,

         @Consumption.valueHelpDefinition: [{ entity:{ name: 'I_IL_AllowedPaymentMethod', element: 'PaymentMethod' },
                                              additionalBinding: [{ element: 'IL_CashNumberKey', localElement: 'IL_CashNumberKey'}] } ]
         PaymentItem.PaymentMethod,

         @Semantics.amount.currencyCode: 'TransactionCurrency'
         PaymentItem.IL_PaytItmAmountInDocCrcy,
         PaymentItem.IL_PaymentStatus,
         PaymentItem.IL_CashNumberKey,
         PaymentItem.Customer,
         PaymentItem.Supplier,
         PaymentItem.GLAccount,


         /* associations */
         _IncomingPayment,
         DocItem._CompanyCode,
         DocItem._FiscalYear,
         DocItem._JournalEntry,
         DocItem._TransactionCurrency,

         _DocItems
}

Learn More