I_IL_ReturnableFromBankItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_IL_ReturnableFromBankItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_IL_ReturnableFromBankItem AS
SELECT
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  IL_IdentifierCashPaymentItem,
  RefAccountingDocument,
  ReferenceCompanyCode,
  ReferenceFiscalYear,
  IL_PaytItmAmountInDocCrcy,
  TransactionCurrency,
  IL_PaymentMethod,
  PaymentMethod,
  PaymentMethodDescription,
  IL_CashNumberKey,
  BankNumber,
  BankAccount,
  IL_ChequeDueDate,
  IL_ChequeNumber,
  Customer,
  Supplier,
  IL_PaymentItemIconURL,
  IL_DepositItemType,
  IL_CancelDepositStatus,
  _RepresentItem.HouseBank AS HouseBank,
  _RepresentItem.HouseBankAccount AS HouseBankAccount,
  IL_ChqInfoFacetIsToBeHidden,
  IL_DocInfoFacetIsToBeHidden,
  EntryTimestamp
FROM P_IL_ReturnableFromBankItem01
LEFT OUTER JOIN I_IL_CashText AS _CashRegisterText ON _CashRegisterText.IL_CashLanguageKey = $session.system_language AND _CashRegisterText.IL_CashNumberKey = IL_CashNumberKey  -- association [0..1]
LEFT OUTER JOIN I_IL_PaymentMethodText AS _IL_PaymentMethodText ON _IL_PaymentMethodText.Language = $session.system_language AND _IL_PaymentMethodText.IL_PaymentMethod = IL_PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_IL_CancelDepositStatusText AS _CancelDepositStatusText ON _CancelDepositStatusText.Language = $session.system_language AND _CancelDepositStatusText.IL_CancelDepositStatus = IL_CancelDepositStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = ReferenceCompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _JournalEntry.AccountingDocument = RefAccountingDocument AND _JournalEntry.CompanyCode = ReferenceCompanyCode AND _JournalEntry.FiscalYear = ReferenceFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _RepresentItem ON _RepresentItem.AccountingDocument = RefAccountingDocument AND _RepresentItem.CompanyCode = ReferenceCompanyCode AND _RepresentItem.FiscalYear = ReferenceFiscalYear AND _RepresentItem.AccountingDocumentItem = '001'  -- association [0..1]
LEFT OUTER JOIN I_HouseBankText AS _HouseBankText ON _HouseBankText.Language = $session.system_language AND _HouseBankText.CompanyCode = ReferenceCompanyCode AND _HouseBankText.HouseBank = housebank AND _HouseBankText.HouseBankAccount = housebankaccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON _HouseBankAccountText.Language = $session.system_language AND _HouseBankAccountText.CompanyCode = ReferenceCompanyCode AND _HouseBankAccountText.HouseBank = housebank AND _HouseBankAccountText.HouseBankAccount = housebankaccount  -- association [0..1]
LEFT OUTER JOIN I_IL_DepositItemTypeText AS _DepositItemTypeText ON _DepositItemTypeText.Language = $session.system_language AND _DepositItemTypeText.IL_DepositItemType = IL_DepositItemType  -- association [0..1]
LEFT OUTER JOIN I_IL_ReturnableFromBankCheque AS _DepositCheque ON /* condition not available in parsed metadata */  -- association [0..*]
;