C_CN_RecnclnJournalEntryItem

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 C_CN_RecnclnJournalEntryItem.
-- 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.
-- SQL view name: CCNRECJOUENTRITM

CREATE VIEW C_CN_RecnclnJournalEntryItem AS
SELECT
  UJEItem.CompanyCode AS CompanyCode,
  UJEItem.HouseBank AS HouseBank,
  UJEItem.HouseBankAccount AS HouseBankAccount,
  UJEItem.BankReconciliationDate AS BankReconciliationDate,
  UJEItem.FiscalYear AS FiscalYear,
  UJEItem.AccountingDocument AS AccountingDocument,
  UJEItem.AccountingDocumentItem AS AccountingDocumentItem,
  UJEItem.Note AS Note,
  UJEItem.BankReconciliationMatchType AS BankReconciliationMatchType,
  _HouseBankAccount.waers AS HouseBankCurrency,
  JE.TransactionCurrency AS TransactionCurrency,
  JE.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JE.CompanyCodeCurrency AS CompanyCodeCurrency,
  JE.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JE.PostingDate AS PostingDate,
  JE.DocumentItemText AS DocumentItemText,
  JE.ValueDate AS ValueDate,
  JE.AssignmentReference AS AssignmentReference
FROM I_CN_RecnclnJournalEntryItem AS UJEItem
LEFT OUTER JOIN P_CN_JOURNALENTRYITEM AS JE ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CN_BankReconciliationItem AS _BankReconciliation ON UJEItem.CompanyCode = _BankReconciliation.CompanyCode AND UJEItem.HouseBank = _BankReconciliation.HouseBank AND UJEItem.HouseBankAccount = _BankReconciliation.HouseBankAccount AND UJEItem.BankReconciliationDate = _BankReconciliation.BankReconciliationDate  -- association [0..1]
LEFT OUTER JOIN C_CN_BankRecnclnStatement AS _BankReconciliationStatement ON UJEItem.CompanyCode = _BankReconciliationStatement.CompanyCode AND UJEItem.HouseBank = _BankReconciliationStatement.HouseBank AND UJEItem.HouseBankAccount = _BankReconciliationStatement.HouseBankAccount AND UJEItem.BankReconciliationDate = _BankReconciliationStatement.BankReconciliationDate  -- association [1]
LEFT OUTER JOIN P_HouseBankAccount AS _HouseBankAccount ON UJEItem.CompanyCode = _HouseBankAccount.bukrs AND UJEItem.HouseBank = _HouseBankAccount.hbkid AND UJEItem.HouseBankAccount = _HouseBankAccount.hktid  -- association [1]
;