I_BankStatementMonitor

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_BankStatementMonitor.
-- 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.

CREATE VIEW I_BankStatementMonitor AS
SELECT
  BkStmntMonitorUUID,
  bkstmntkeydate AS KeyDate,
  company_code AS CompanyCode,
  housebank_id AS HouseBank,
  account_id AS HouseBankAccount,
  Currency,
  country AS BankCountry,
  bank_key AS BankInternalID,
  acc_id AS BankAccountInternalID,
  acc_type_id AS BankAccountType,
  ext_account_no AS BankAccount,
  alt_account_no AS BankAccountAlternative,
  cast(gl_account as farp_hkont preserving type) AS GLAccount,
  statement_date AS BankStatementDate,
  statement_no AS BankStatement,
  no_items AS BankStatementNumberOfItems,
  bankstatementimporttimestamp AS CreatedOnDateTime,
  open_bal_statemt AS OpeningBalanceAmtInTransCrcy,
  total_debits AS TotalDebitAmountInTransCrcy,
  total_credits AS TotalCreditAmountInTransCrcy,
  clos_bal_statemt AS ClosingBalanceAmtInTransCrcy,
  clos_bal_gl AS GLAcctBalanceAmt,
  diff_stat_gl AS RelativeDifferenceAmount,
  procstscritltymessagenumber AS HsBkAcctProcgStsMessageNumber,
  processstatuscriticality AS HsBkAcctProcgStatusCriticality,
  balstscriticalitymessagenumber AS HsBkAcctDiffStsMessageNumber,
  balancestatuscriticality AS HsBkAcctDiffStatusCriticality,
  srlnmbrstscritltymessagenumber AS HsBkAcctSqncStsMessageNumber,
  serialnumberstatuscriticality AS HsBkAcctSqncStatusCriticality,
  recnclnstscritltymessagenumber AS HsBkAcctRecnclnStsMsgNumber,
  reconclnstatuscriticality AS HsBkAcctRecnclnStsCriticality,
  overallstatus AS BkStmntMntrRsltOvrlCriticality,
  BkStmntExpectedArrivalDate,
  swift_code AS SWIFTCode,
  contact_name AS ContactPersonName,
  cast(contact_tel as telf1) AS PhoneNumber1,
  bank_name AS BankName,
  kukey AS BankStatementShortID,
  euser AS CreatedByUser,
  bkont AS BankControlKey,
  azpgno AS BankStatementPageNumber,
  IBAN,
  status AS BankAccountStatus,
  importing_channel AS BankStatementImportChannel,
  procstat_act AS ProcessingStatus,
  balstat_act AS DifferenceStatus,
  serstat_act AS SerialNumberStatus,
  reconstat_act AS ReconciliationStatus,
  bs_forwarding AS BankStatementForwardingType,
  RefByProcessingApplication,
  refprocapplmessagenumber AS HsBkAcctProcgApplMessageNumber,
  exp_number AS ExpectedInterval,
  exp_rhyth AS ControlFrequency,
  calendar AS FactoryCalendar,
  amt_diff AS DifferenceAmount,
  bs_post_cat AS BankStatementPostingType,
  created_at AS BkStmntMntrRsltCrtedOnDateTime,
  created_by AS BkStmntMntrRsltCreatedByUser
FROM far_bsm_result
;