I_Arbankstatement

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 I_Arbankstatement.
-- 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: IBANKSTMT

CREATE VIEW I_Arbankstatement AS
SELECT
  StatementShortID AS BankStatementShortID,
  BankDataStorageApplication,
  SendingBank,
  InternalID AS BankStatementInternalID,
  BankStatementRecipientRefID,
  CompanyCode,
  cast( HouseBank as farp_hbkid ) AS HouseBank,
  HouseBankAccount,
  StatementNumber AS BankStatement,
  StatementDate AS BankStatementDate,
  cast ( StatementStatus as farp_astat ) AS BankStatementStatus,
  cast ( StatementStatusName as farp_bs_stat_desc ) AS BankStatementStatusName,
  StatusCode AS JobStatusValue,
  cast ( ApplicationJob as farp_btcjobcnt ) AS BankStatementReversalJob,
  cast ( ApplicationJobName as btcjob ) AS BankStatementReversalJobName,
  Currency,
  cast ( BankLedgerIsPosted as farp_vb1ok ) AS BankLedgerIsPosted,
  cast ( SubledgerIsPostedSuccessfully as farp_vb2ok ) AS SubledgerIsPostedSuccessfully,
  cast ( StatementIsInterpreted as kipre_eb ) AS BankStatementIsInterpreted,
  GLAccount,
  BankAccountInternalID,
  cast ( BankAccount as farp_bankn ) AS BankAccount,
  cast ( BankAccountAdditionalName as ktosb_eb ) AS BankAccountAdditionalName,
  cast ( StatementPageNumber as farp_azpgno ) AS BankStatementPageNumber,
  ChartOfAccounts,
  OpeningBalanceIsInterim,
  cast ( OpeningBalanceAmtInTransCrcy as farp_ssbtr ) AS OpeningBalanceAmtInTransCrcy,
  cast( InterimOpenBalAmtInTransCrcy as farp_interim_ssbtr ) AS InterimOpenBalAmtInTransCrcy,
  cast( InterimClsgBalAmtInTransCrcy as farp_interim_esbtr ) AS InterimClsgBalAmtInTransCrcy,
  cast ( TotalDebitAmountInTransCrcy as sumso_eb ) AS TotalDebitAmountInTransCrcy,
  cast ( TotalCreditAmountInTransCrcy as sumha_eb ) AS TotalCreditAmountInTransCrcy,
  ClosingBalanceIsInterim,
  cast ( ClosingBalanceAmtInTransCrcy as farp_esbtr ) AS ClosingBalanceAmtInTransCrcy,
  cast ( InterestRateInPercent as farp_hzins ) AS InterestRateInPercent,
  cast ( BankAccountType as farp_bktoa ) AS BankAccountType,
  NumberOfItems AS BankStatementNumberOfItems,
  _ItemCount.ItemCount AS NumberOfItems,
  cast ( PaymentTransactionTypeGroup as farp_vgtyp ) AS PaymentTransactionTypeGroup,
  IsManuallyCreated AS BankStatementIsManuallyCreated,
  IsLatestStatement AS IsLatestBankStatement,
  cast ( CreatedByUser as farp_euser ) AS CreatedByUser,
  cast ( StatementImportDate as farp_edate ) AS BankStatementImportDate,
  cast ( StatementImportTime as farp_etime ) AS BankStatementImportTime,
  cast ( AccountReferenceText as farp_bkref ) AS BankAccountReferenceText,
  cast ( StatementInputFormat as farp_input_format ) AS BankStatementFormat,
  cast (case when IBAN = '' or IBAN is null then _Account.IBAN else IBAN end as farp_siban ) as IBAN AS IBANelseIBANendasfarp_sibanasIBAN,
  BankInternalID,
  BankCountry,
  cast ( BankName as farp_banka ) AS BankName,
  HouseBankAccountDescription,
  cast (CashMgmtPaymtAdviceNoteCreated as xfdis_eb) AS CashManagementAdviceIsCreated,
  cast (SummarizeBankStatementItems as ffdisxverd) AS CashMgmtAdviceIsSummarized,
  CashPositionIsUpdated,
  BkStmntIsCashUpdateRelevant,
  PostingType AS BankStatementPostingType,
  SemObjByProcessingApplication,
  RefByProcessingApplication,
  BankStmntProcessingApplication,
  BankStatementImportMessageUUID,
  BankStatementImportMessageID
FROM P_Arbanktransactiondoc
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = Currency  -- association [0..1]
LEFT OUTER JOIN P_ARBankTransacDocItmCnt AS _ItemCount ON _ItemCount.StatementShortID = BankStatementShortID  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _Account ON BankAccountInternalID = _Account.BankAccountInternalID  -- association [1..1]
;