P_Arbsitmonacc

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_Arbsitmonacc.
-- 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: PARBSITONACC

CREATE VIEW P_Arbsitmonacc AS
SELECT
  BankStatementItem.BankStatementShortID AS BankStatementShortID,
  BankStatementItem.CompanyCode AS CompanyCode,
  BankStatementItem.BankStatement AS BankStatement,
  BankStatementItem.HouseBank AS HouseBank,
  BankStatementItem.HouseBankAccount AS HouseBankAccount,
  BankStatement.BankInternalID AS BankInternalID,
  BankStatement.BankAccount AS BankAccount,
  BankStatement.BankName AS BankName,
  BankStatementItem.Currency AS Currency,
  cast ( BankStatement.BankStatementDate as azidt_eb ) AS BankStatementDate,
  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,
  bnka.banka AS PartnerBankName,
  BankStatementItem.BankLedgerDocument AS BankLedgerDocument,
  BankStatementItem.SubledgerDocument AS SubledgerDocument,
  BankStatementItem.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStatementItem.BankReference AS BankReference,
  MemoLine.MemoLine AS MemoLine,
  BankStatementItem.MachineLrngBankStmntItemStatus AS MachineLrngBankStmntItemStatus,
  OpenItem.CompanyCode AS OICompanyCode,
  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.CompanyCodeCurrency AS OICompanyCodeCurrency,
  OpenItem.AmountInCompanyCodeCurrency AS OIAmountInCompanyCodeCurrency,
  OpenItem.FinancialAccountType AS OIFinancialAccountType,
  OpenItem.AssignmentReference AS OIAssignmentReference,
  OpenItem.PaymentReference AS OIPaymentReference,
  OpenItem.DocumentItemText AS OIDocumentItemText
FROM I_ReceivablesPayablesItem AS OpenItem
INNER JOIN I_Arbankstatementitem AS BankStatementItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_Arbankstatement AS BankStatement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Arbsitmemoline ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bnka ON /* join condition not captured in parsed metadata */
;