P_ARBSITMBANKSTMT02

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_ARBSITMBANKSTMT02.
-- 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: PARBSITMBNKSTMT2

CREATE VIEW P_ARBSITMBANKSTMT02 AS
SELECT
  BankStatementItem.CompanyCode AS CompanyCode,
  BankStatementItem.HouseBank AS HouseBank,
  BankStatementItem.HouseBankAccount AS HouseBankAccount,
  BankStatementItem.BankStatement AS BankStatement,
  BankStatementItem.BankStatementShortID AS BankStatementShortID,
  BankStatementItem.BankStatementItem AS BankStatementItem,
  BankStatementItem.FiscalYear AS FiscalYear,
  BankStatementItem.PostingDate AS PostingDate,
  BankStatementItem.ValueDate AS ValueDate,
  BankStatementItem.Currency AS Currency,
  BankStatementItem.TransactionCurrency AS TransactionCurrency,
  BankStatementItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BankStatementItem.DebitCreditCode AS DebitCreditCode,
  BankStatementItem.PartnerBankCountry AS PartnerBankCountry,
  BankStatementItem.PartnerBank AS PartnerBank,
  BankStatementItem.PartnerBankSWIFTCode AS PartnerBankSWIFTCode,
  BankStatementItem.PartnerBankAccount AS PartnerBankAccount,
  BankStatementItem.PartnerBankIBAN AS PartnerBankIBAN,
  BankStatementItem.BusinessPartnerName AS BusinessPartnerName,
  BankStatementItem.BankLedgerDocument AS BankLedgerDocument,
  BankStatementItem.SubledgerDocument AS SubledgerDocument,
  BankStatementItem.DocumentReferenceID AS DocumentReferenceID,
  BankStatementItem.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  BankStatementItem.PaymentAdviceAccount AS PaymentAdviceAccount,
  BankStatementItem.AssignmentReference AS AssignmentReference,
  BankStatementItem.PaymentReference AS PaymentReference,
  BankStatementItem.BankStatementPostingRule AS BankStatementPostingRule,
  BankStatementItem.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStatementItem.PaymentAdvice AS PaymentAdvice,
  MemoLine.MemoLine AS MemoLine,
  BankStatementItem.PaymentTransactionDescription AS PaymentTransactionDescription,
  BankStatementItem.Cheque AS Cheque,
  BankStatementItem.BankPostingKey AS BankPostingKey,
  BankStatementItem.PaymentTransaction AS PaymentTransaction,
  BankStatementItem.PaymentExternalTransacType AS PaymentExternalTransacType
FROM P_ARBSITMCLRITEM01 AS ReceivableItem
INNER JOIN P_ARBSITMBANKSTMT01 AS BankStatementItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Arbsitmemoline ON /* join condition not captured in parsed metadata */
;