P_ARBSItmWithPayDoc

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_ARBSItmWithPayDoc.
-- 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: PARBSITMWPAYDOC

CREATE VIEW P_ARBSItmWithPayDoc 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,
  BankStatementItem.FiscalYear AS FiscalYear,
  BankStatementItem.BankStatementDate 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,
  BankStatementItem.BankLedgerDocument AS BankLedgerDocument,
  BankStatementItem.SubledgerDocument AS SubledgerDocument,
  BankStatementItem.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStatementItem.BankReference AS BankReference,
  MemoLine.MemoLine AS MemoLine,
  BankStatementItemPayDoc
FROM I_Arbankstatementitem AS BankStatementItem
INNER JOIN P_ARBSITMPAYDOC ON /* join condition not captured in parsed metadata */
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 */
;