R_BankStatementMonitorTP

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 R_BankStatementMonitorTP.
-- 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 R_BankStatementMonitorTP AS
SELECT
  BkStmntMonitorUUID,
  KeyDate,
  CompanyCode,
  HouseBank,
  HouseBankAccount,
  Currency,
  BankCountry,
  BankInternalID,
  BankAccount,
  BankAccountInternalID,
  BankAccountType,
  BankAccountAlternative,
  GLAccount,
  BankStatementDate,
  BankStatement,
  BankStatementNumberOfItems,
  CreatedOnDateTime,
  OpeningBalanceAmtInTransCrcy,
  TotalDebitAmountInTransCrcy,
  TotalCreditAmountInTransCrcy,
  ClosingBalanceAmtInTransCrcy,
  GLAcctBalanceAmt,
  RelativeDifferenceAmount,
  HsBkAcctProcgStsMessageNumber,
  HsBkAcctProcgStatusCriticality,
  HsBkAcctDiffStsMessageNumber,
  HsBkAcctDiffStatusCriticality,
  HsBkAcctSqncStsMessageNumber,
  HsBkAcctSqncStatusCriticality,
  HsBkAcctRecnclnStsMsgNumber,
  HsBkAcctRecnclnStsCriticality,
  BkStmntMntrRsltOvrlCriticality,
  BkStmntExpectedArrivalDate,
  SWIFTCode,
  ContactPersonName,
  PhoneNumber1,
  BankName,
  BankStatementShortID,
  CreatedByUser,
  BankControlKey,
  BankStatementPageNumber,
  IBAN,
  BankAccountStatus,
  BankStatementImportChannel,
  ProcessingStatus,
  DifferenceStatus,
  SerialNumberStatus,
  ReconciliationStatus,
  BankStatementForwardingType,
  RefByProcessingApplication,
  cast(_ProcessingAppText.SystemMessageText as far_bs_itm_sem_obj_proc_app ) AS SemObjByProcessingApplication,
  HsBkAcctProcgApplMessageNumber,
  ExpectedInterval,
  ControlFrequency,
  FactoryCalendar,
  DifferenceAmount,
  BankStatementPostingType,
  BkStmntMntrRsltCrtedOnDateTime,
  BkStmntMntrRsltCreatedByUser,
  ProcessingStatusIsHidden,
  DifferenceStatusIsHidden,
  DifferenceAmountIsHidden,
  SequenceStatusIsHidden,
  ReconciliationStatusIsHidden
FROM I_BankStatementMonitor
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_Bankaccountlinkage AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus  -- association [0..*]
LEFT OUTER JOIN I_BankAccountType AS _BankAccountType ON BankAccountType = _BankAccountType.BankAccountType  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_BankAccountIntervalUnitText AS _BkAcctIntvlUnitText ON ControlFrequency = _BkAcctIntvlUnitText.ControlFrequency  -- association [0..*]
LEFT OUTER JOIN I_CashBalancePostingTypeText AS _BankStatementPostingTypeText ON BankStatementPostingType = _BankStatementPostingTypeText.BankStatementPostingType  -- association [0..*]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_BkStmntMntrCriticalityText AS _BkStmntMntrCritltyText ON BkStmntMntrRsltOvrlCriticality = _BkStmntMntrCritltyText.BkStmntMntrCriticality  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrCriticalityText AS _BkStmntMntrProcgCritltyText ON HsBkAcctProcgStatusCriticality = _BkStmntMntrProcgCritltyText.BkStmntMntrCriticality  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrCriticalityText AS _BkStmntMntrDiffCritltyText ON HsBkAcctDiffStatusCriticality = _BkStmntMntrDiffCritltyText.BkStmntMntrCriticality  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrCriticalityText AS _BkStmntMntrSqncCritltyText ON HsBkAcctSqncStatusCriticality = _BkStmntMntrSqncCritltyText.BkStmntMntrCriticality  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrCriticalityText AS _BkStmntMntrRecnclnCritltyText ON HsBkAcctRecnclnStsCriticality = _BkStmntMntrRecnclnCritltyText.BkStmntMntrCriticality  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrMessageText AS _ProcessText ON HsBkAcctProcgStsMessageNumber = _ProcessText.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrMessageText AS _BalanceText ON HsBkAcctDiffStsMessageNumber = _BalanceText.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrMessageText AS _SerialText ON HsBkAcctSqncStsMessageNumber = _SerialText.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrMessageText AS _ReconciliationText ON HsBkAcctRecnclnStsMsgNumber = _ReconciliationText.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_BkStmntMntrMessageText AS _ProcessingAppText ON HsBkAcctProcgApplMessageNumber = _ProcessingAppText.SystemMessageNumber AND _ProcessingAppText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _BankStatementMonitorCreatedBy ON BkStmntMntrRsltCreatedByUser = _BankStatementMonitorCreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankStatementForwardingText AS _BankStatementForwardingText ON BankStatementForwardingType = _BankStatementForwardingText.BankStatementForwardingType AND _BankStatementForwardingText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_BkStmntProcgStsCritltyTP AS _Process ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BkStmntSequenceStatusTP AS _Serial ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BkStmntRecnclnStsCritltyTP AS _Reconciliation ON /* condition not available in parsed metadata */  -- association [0..*]
;