I_IL_IncomingPmtBankTransItem

DDL: I_IL_INCOMINGPMTBANKTRANSITEM Type: view_entity COMPOSITE

Bank Transfer Item in IL Cashier System

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

2 data source(s) 22 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 Bank Transfer Item in IL Cashier System view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

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
Customer I_IL_PaymentItem Customer
Supplier I_IL_PaymentItem Supplier
GLAccount I_IL_PaymentItem GLAccount
IL_CashNumberKey I_IL_PaymentItem IL_CashNumberKey
IL_BankTransferReferenceNumber I_IL_PaymentItem IL_BankTransferReferenceNumber
_IncomingPayment _IncomingPayment
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_TransactionCurrency I_OperationalAcctgDocItem _TransactionCurrency
_DocItems _DocItems 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Transfer Item in IL Cashier System'

@VDM.viewType: #COMPOSITE

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

define view entity I_IL_IncomingPmtBankTransItem
  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             = 'BT' --<--- Bank-Transfer 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,

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

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


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

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

Learn More