P_Arbsitmopenbs

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_Arbsitmopenbs.
-- 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: PARBSITMOPBS
-- Parameters: P_DCCode : epvoz_eb

CREATE VIEW P_Arbsitmopenbs AS
SELECT
  BankStatementItem.CompanyCode AS CompanyCode,
  CompanyCtryKey.CountryKey AS CountryKey,
  BankStatementItem.HouseBank AS HouseBank,
  BankStatementItem.HouseBankAccount AS HouseBankAccount,
  BankStatementItem.BankStatement AS BankStatement,
  BankStatement.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,
  cast('' as abap.sstring( 1333)) AS MemoLine,
  BankStatementItem.MemoLineIsChanged AS MemoLineIsChanged,
  BankStatementItem.PaymentTransactionDescription AS PaymentTransactionDescription,
  BankStatementItem.Cheque AS Cheque,
  BankStatementItem.BankPostingKey AS BankPostingKey,
  BankStatementItem.PaymentTransaction AS PaymentTransaction,
  BankStatementItem.PaymentExternalTransacType AS PaymentExternalTransacType,
  BankStatement.BankDataStorageApplication AS BankDataStorageApplication,
  BankStatementItem.MachineLrngBankStmntItemStatus AS MachineLrngBankStmntItemStatus,
  BankStatementItem.BankStatementItemDescription1 AS BankStatementItemDescription1,
  BankStatementItem.BankStmntItemIsReprocessed AS BankStmntItemIsReprocessed,
  cast('' as abap.sstring( 64)) AS BankStatementKey
FROM I_Arbankstatementitem AS BankStatementItem
INNER JOIN I_Arbankstatement AS BankStatement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ARBSITMCOMPANY AS CompanyCtryKey ON /* join condition not captured in parsed metadata */
;