I_IL_IncomingPaymentChequeItem

DDL: I_IL_INCOMINGPAYMENTCHEQUEITEM Type: view_entity COMPOSITE

Payment Cheque Item in IL Cashier System

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

2 data source(s) 32 fields

Data Sources (2)

SourceAliasJoin Type
I_IL_PaymentItem CashItem inner
I_OperationalAcctgDocItem DocItem from

Associations (1)

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

Annotations (6)

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

Fields (32)

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
PaymentDifferenceReason I_OperationalAcctgDocItem PaymentDifferenceReason
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
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
BankNumber I_IL_PaymentItem BankNumber
BankAccount I_IL_PaymentItem BankAccount
IL_ChequeNumber I_IL_PaymentItem IL_ChequeNumber
Customer I_IL_PaymentItem Customer
Supplier I_IL_PaymentItem Supplier
GLAccount I_IL_PaymentItem GLAccount
IL_ChequeDueDate I_IL_PaymentItem IL_ChequeDueDate
_IncomingPayment _IncomingPayment
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_TransactionCurrency I_OperationalAcctgDocItem _TransactionCurrency
_PaymentDifferenceReason I_OperationalAcctgDocItem _PaymentDifferenceReason
_SpecialGLCode I_OperationalAcctgDocItem _SpecialGLCode
_FinancialAccountType I_OperationalAcctgDocItem _FinancialAccountType
_PaymentMethodText I_IL_PaymentItem _PaymentMethodText
_DocItems _DocItems 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Payment Cheque Item in IL Cashier System'

@VDM.viewType: #COMPOSITE

@ObjectModel: { usageType: { serviceQuality: #D,
                             sizeCategory: #XL,
                             dataClass: #TRANSACTIONAL } }

define view entity I_IL_IncomingPaymentChequeItem
  as

  select from  I_OperationalAcctgDocItem as DocItem

    inner join I_IL_PaymentItem          as CashItem on  CashItem.CompanyCode                  = DocItem.CompanyCode
                                                     and CashItem.FiscalYear                   = DocItem.FiscalYear
                                                     and CashItem.IL_IdentifierCashPaymentItem = DocItem.PaymentReference --<--- forces 1:1 cardinality!
                                                     and CashItem.IL_PaymentMethod             = 'CE' --<--- Ceque 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,
         DocItem.AmountInTransactionCurrency,
         DocItem.DocumentItemText,
         DocItem.PaymentDifferenceReason,
         DocItem.FinancialAccountType,
         DocItem.SpecialGLCode,

         @Consumption.valueHelpDefinition: [{ entity:{ name: 'I_IL_AllowedPaymentMethod', element: 'PaymentMethod' } } ]
         CashItem.PaymentMethod,

         @Semantics.amount.currencyCode: 'TransactionCurrency'
         CashItem.IL_PaytItmAmountInDocCrcy,
         CashItem.IL_PaymentStatus,
         CashItem.IL_CashNumberKey,
         CashItem.BankNumber,
         CashItem.BankAccount,
         CashItem.IL_ChequeNumber,
         CashItem.Customer,
         CashItem.Supplier,
         CashItem.GLAccount,
         CashItem.IL_ChequeDueDate,


         /* associations */
         _IncomingPayment,
         DocItem._CompanyCode,
         DocItem._FiscalYear,
         DocItem._JournalEntry,
         DocItem._TransactionCurrency,
         DocItem._PaymentDifferenceReason,
         DocItem._SpecialGLCode,
         DocItem._FinancialAccountType,

         CashItem._PaymentMethodText,

         _DocItems
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_IL_PAYMENTITEM",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_FINANCIALACCOUNTTYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_IL_INCOMINGPAYMENTDOCUMENT",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"I_PAYMENTDIFFERENCEREASON",
"I_PAYMENTMETHODTEXT",
"I_SPECIALGLCODE"
],
"BASE":
[
"I_IL_PAYMENTITEM",
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More