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.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.AccountType AS AccountType,
  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 (I_User.UserDescription as farp_euser_name ) AS PersonFullName,
  I_Arbankstatement.BankStatementImportDate AS BankStatementImportDate,
  I_Arbankstatement.BankStatementImportTime AS BankStatementImportTime,
  I_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,
  cast ( I_Arbankstatement.IsLatestBankStatement as far_islatestbs_ui ) AS IsLatestBankStatement,
  cast ( Bs_Postingdate.PostingDate as farp_budat ) AS PostingDate,
  cast ( ReversalJob.ApplicationJob as farp_btcjobcnt ) AS BankStatementReversalJob,
  cast ( ReversalJob.ApplicationJobName as btcjob ) 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
FROM I_Arbankstatement
LEFT OUTER JOIN I_Arbankstatementpostingdate AS Bs_Postingdate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IncomingPaymentFileLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Arbankstatementjob AS ReversalJob ON /* join condition not captured in parsed metadata */
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 E_ARBankStatement AS _Extension ON BankStatementShortID = _Extension.BankStatementShortID AND SendingBank = _Extension.SendingBank AND BankStatementInternalID = _Extension.BankStatementInternalID AND BankStatementRecipientRefID = _Extension.BankStatementRecipientRefID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;