P_Arbsitmopenitm

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 P_Arbsitmopenitm.
-- 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: PARBSITMOPIT

CREATE VIEW P_Arbsitmopenitm AS
SELECT
  BankStatementItem.BankStatementShortID AS BankStatementShortID,
  BankStatementItem.CompanyCode AS CompanyCode,
  BankStatementItem.BankStatement AS BankStatement,
  BankStatementItem.HouseBank AS HouseBank,
  BankStatementItem.HouseBankAccount AS HouseBankAccount,
  BankStatementItem.Currency AS Currency,
  BankStatement.BankStatementImportDate AS BankStatementImportDate,
  BankStatement.BankStatementImportTime AS BankStatementImportTime,
  BankStatement.CreatedByUser AS CreatedByUser,
  BankStatementItem.BankStatementItem AS BankStatementItem,
  BankStatementItem.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  BankStatementItem.PaymentAdviceAccount AS PaymentAdviceAccount,
  BankStatementItem.PaymentAdvice AS PaymentAdvice,
  BankStatementItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BankStatementItem.OriginalCurrency AS OriginalCurrency,
  BankStatementItem.AmountInOriginalCurrency AS AmountInOriginalCurrency,
  BankStatementItem.CustomerReferenceNumber AS CustomerReferenceNumber,
  BankStatementItem.PaymentReference AS PaymentReference,
  BankStatementItem.DocumentReferenceID AS DocumentReferenceID,
  BankStatementItem.AssignmentReference AS AssignmentReference,
  BankStatementItem.BankPostingKey AS BankPostingKey,
  BankStatementItem.PaymentExternalTransacType AS PaymentExternalTransacType,
  BankStatementItem.BankStatementPostingRule AS BankStatementPostingRule,
  BankStatementItem.DocumentItemText AS DocumentItemText,
  BankStatementItem.PostingDate AS PostingDate,
  BankStatementItem.DebitCreditCode AS DebitCreditCode,
  BankStatementItem.BankLedgerIsPosted AS BankLedgerIsPosted,
  BankStatementItem.SubledgerIsPostedSuccessfully AS SubledgerIsPostedSuccessfully,
  BankStatementItem.IsCompleted AS IsCompleted,
  BankStatementItem.InterpretationAlgorithm AS InterpretationAlgorithm,
  BankStatementItem.BusinessPartnerName AS BusinessPartnerName,
  BankStatementItem.PartnerBankCountry AS PartnerBankCountry,
  BankStatementItem.PartnerBank AS PartnerBank,
  BankStatementItem.PartnerBankSWIFTCode AS PartnerBankSWIFTCode,
  BankStatementItem.PartnerBankAccount AS PartnerBankAccount,
  BankStatementItem.PartnerBankIBAN AS PartnerBankIBAN,
  BankStatementItem.BankLedgerDocument AS BankLedgerDocument,
  BankStatementItem.SubledgerDocument AS SubledgerDocument,
  BankStatementItem.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStatementItem.BankReference AS BankReference,
  MemoLine.MemoLine AS MemoLine,
  OpenItem.CompanyCode AS OICompanyCode,
  OpenItem.CompanyCodeCurrency AS OICompanyCodeCurrency,
  OpenItem.AccountingDocument AS OIAccountingDocument,
  OpenItem.FiscalYear AS OIFiscalYear,
  OpenItem.TransactionCurrency AS OITransactionCurrency,
  OpenItem._JournalEntry.DocumentReferenceID AS OIDocumentReferenceID,
  OpenItem.OriginalReferenceDocument AS OIOriginalReferenceDocument,
  OpenItem.ReferenceDocumentLogicalSystem AS OIReferenceDocumentLogicalSys,
  OpenItem.ReferenceDocumentType AS OIReferenceDocumentType,
  OpenItem._JournalEntry.AccountingDocumentHeaderText AS OIAccountingDocumentHeaderText,
  OpenItem.PostingDate AS OIPostingDate,
  OpenItem.AccountingDocumentType AS OIAccountingDocumentType,
  OpenItem._JournalEntry.AccountingDocCreatedByUser AS OIAccountingDocCreatedByUser,
  OpenItem._JournalEntry.TransactionCode AS OITransactionCode,
  OpenItem._JournalEntry.AccountingDocumentCreationDate AS OIAccountingDocCreationDate,
  OpenItem._JournalEntry.CreationTime AS OICreationTime,
  OpenItem.AccountingDocumentItem AS OIAccountingDocumentItem,
  OpenItem.Debtor AS OIDebtor,
  OpenItem.ClearingAccountingDocument AS OIClearingAccountingDocument,
  OpenItem.ClearingCreationDate AS OIClearingCreationDate,
  OpenItem.DebitCreditCode AS OIDebitCreditCode,
  OpenItem.ClearingDocFiscalYear AS OIClearingDocFiscalYear,
  OpenItem.AmountInTransactionCurrency AS OIAmountInTransactionCurrency,
  OpenItem.AmountInCompanyCodeCurrency AS OIAmountInCompanyCodeCurrency,
  OpenItem.FinancialAccountType AS OIFinancialAccountType,
  OpenItem.AssignmentReference AS OIAssignmentReference,
  OpenItem.PaymentReference AS OIPaymentReference,
  OpenItem.DocumentItemText AS OIDocumentItemText,
  OpenItem.InvoiceReference AS OIInvoiceReference,
  OpenItem.InvoiceReferenceFiscalYear AS OIInvoiceReferenceFiscalYear,
  OpenItem.InvoiceItemReference AS OIInvoiceItemReference,
  OpenItem.FollowOnDocumentType AS OIFollowOnDocumentType
FROM I_Arbankstatementitem AS BankStatementItem
INNER JOIN I_Arbankstatement AS BankStatement ON /* join condition not captured in parsed metadata */
INNER JOIN P_Arbsitmemoline ON /* join condition not captured in parsed metadata */
INNER JOIN I_AccountingDocument AS SubledgerDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReceivablesPayablesItem AS OpenItem ON /* join condition not captured in parsed metadata */
;