I_ARBankStatementTP

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_ARBankStatementTP.
-- 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: IBANKSTMTTP

CREATE VIEW I_ARBankStatementTP AS
SELECT
  cast ( I_Arbankstatement.BankStatementShortID as farp_kukey ) AS BankStatementShortID,
  cast ( I_Arbankstatement.BankDataStorageApplication as far_anwnd_idbs_bs ) AS BankDataStorageApplication,
  I_Arbankstatement.SendingBank AS SendingBank,
  cast ( I_Arbankstatement.BankStatementInternalID as farp_azidt ) AS BankStatementInternalID,
  I_Arbankstatement.BankStatementRecipientRefID AS BankStatementRecipientRefID,
  I_Arbankstatement.CompanyCode AS CompanyCode,
  cast('' as fis_hryid_ccode_42) AS CompanyCodeHierarchy,
  cast('' as fis_hrynid_ccode_50) AS CompanyCodeHierarchyNode,
  I_Arbankstatement.HouseBank AS HouseBank,
  cast(I_Arbankstatement.HouseBankAccount as farp_hktid) AS HouseBankAccount,
  I_Arbankstatement.BankAccountInternalID AS BankAccountInternalID,
  cast ( I_Arbankstatement.BankStatement as farp_aznum ) AS BankStatement,
  cast ( I_Arbankstatement.BankStatementDate as farp_azdat ) AS BankStatementDate,
  cast ( I_Arbankstatement.BankStatementTime as farp_aztim ) AS BankStatementTime,
  I_Arbankstatement.BankStatementStatus AS BankStatementStatus,
  I_Arbankstatement.BankStatementStatusName AS BankStatementStatusName,
  I_Arbankstatement.Currency AS Currency,
  I_Arbankstatement.BankLedgerIsPosted AS BankLedgerIsPosted,
  I_Arbankstatement.SubledgerIsPostedSuccessfully AS SubledgerIsPostedSuccessfully,
  cast ( I_Arbankstatement.BankStatementIsInterpreted as farp_kipre ) AS BankStatementIsInterpreted,
  cast ( I_Arbankstatement.GLAccount as farp_hkont ) AS GLAccount,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  I_Arbankstatement.BankAccount AS BankAccount,
  I_Arbankstatement.BankInternalID AS BankInternalID,
  I_Arbankstatement.BankAccountHolderName AS BankAccountHolderName,
  cast ( I_Arbankstatement.BankAccountAdditionalName as farp_ktosb ) AS BankAccountAdditionalName,
  cast ( I_Arbankstatement.BankStatementPageNumber as farp_azpgno ) AS BankStatementPageNumber,
  I_Arbankstatement.ChartOfAccounts AS ChartOfAccounts,
  cast ( I_Arbankstatement.OpeningBalanceIsInterim as farp_opening_bal_interim_ind ) AS OpeningBalanceIsInterim,
  I_Arbankstatement.OpeningBalanceAmtInTransCrcy AS OpeningBalanceAmtInTransCrcy,
  I_Arbankstatement.InterimOpenBalAmtInTransCrcy AS InterimOpenBalAmtInTransCrcy,
  I_Arbankstatement.InterimClsgBalAmtInTransCrcy AS InterimClsgBalAmtInTransCrcy,
  I_Arbankstatement.TotalDebitAmountInTransCrcy AS TotalDebitAmountInTransCrcy,
  I_Arbankstatement.TotalCreditAmountInTransCrcy AS TotalCreditAmountInTransCrcy,
  cast ( I_Arbankstatement.ClosingBalanceIsInterim as farp_closing_bal_interim_ind ) AS ClosingBalanceIsInterim,
  I_Arbankstatement.ClosingBalanceAmtInTransCrcy AS ClosingBalanceAmtInTransCrcy,
  I_Arbankstatement.InterestRateInPercent AS InterestRateInPercent,
  I_Arbankstatement.BankAccountType AS BankAccountType,
  I_Arbankstatement.BankStatementNumberOfItems AS BankStatementNumberOfItems,
  I_Arbankstatement.NumberOfItems AS NumberOfItems,
  I_Arbankstatement.PaymentTransactionTypeGroup AS PaymentTransactionTypeGroup,
  cast ( I_Arbankstatement.BankStatementIsManuallyCreated as farp_bs_manual_created_ind ) AS BankStatementIsManuallyCreated,
  I_Arbankstatement.CreatedByUser AS CreatedByUser,
  cast (_User.UserDescription as farp_euser_name ) AS PersonFullName,
  I_Arbankstatement.BankStatementImportDate AS BankStatementImportDate,
  I_Arbankstatement.BankStatementImportTime AS BankStatementImportTime,
  _IncomingPaymentFileLine.IncomingPaymentFile AS IncomingPaymentFile,
  I_Arbankstatement.BankAccountReferenceText AS BankAccountReferenceText,
  I_Arbankstatement.BankStatementFormat AS BankStatementFormat,
  I_Arbankstatement.IBAN AS IBAN,
  I_Arbankstatement.BankCountry AS BankCountry,
  I_Arbankstatement.BankName AS BankName,
  I_Arbankstatement.HouseBankAccountDescription AS HouseBankAccountDescription,
  cast ( I_Arbankstatement.IsLatestBankStatement as far_islatestbs_ui ) AS IsLatestBankStatement,
  cast ( _PostingDate.PostingDate as farp_budat ) AS PostingDate,
  I_Arbankstatement.BankStatementReversalJob AS BankStatementReversalJob,
  I_Arbankstatement.BankStatementReversalJobName AS BankStatementReversalJobName,
  cast ( I_Arbankstatement.CashPositionIsUpdated as far_cash_position_is_updated ) AS CashPositionIsUpdated,
  cast ( I_Arbankstatement.BkStmntIsCashUpdateRelevant as far_cash_pos_is_updat_relevant ) AS BkStmntIsCashUpdateRelevant,
  BankStatementPostingType,
  SemObjByProcessingApplication,
  RefByProcessingApplication,
  BankStmntProcessingApplication,
  BankStatementImportMessageUUID,
  BankStatementImportMessageID
FROM I_Arbankstatement
LEFT OUTER JOIN I_Arbankstatementpostingdate AS _PostingDate ON I_Arbankstatement.BankStatementShortID = _PostingDate.BankStatementShortID  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = I_Arbankstatement.CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_IncomingPaymentFileLine AS _IncomingPaymentFileLine ON I_Arbankstatement.BankStatementShortID = _IncomingPaymentFileLine.BankStatementShortID AND( _IncomingPaymentFileLine.IncomingPaymentFileType = 'B' OR _IncomingPaymentFileLine.IncomingPaymentFileType = 'I' )  -- association [0..1]
LEFT OUTER JOIN I_ARBankStatementItemTP AS _Item ON BankStatementShortID = _Item.BankStatementShortID  -- association [0..*]
LEFT OUTER JOIN I_BankStmntStsText AS _BankStatementStatus ON BankStatementStatus = _BankStatementStatus.BankStatementStatus  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;