C_BkAcctInstntBalMonitor

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 C_BkAcctInstntBalMonitor.
-- 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 C_BkAcctInstntBalMonitor AS
SELECT
  BankAccountInternalID,
  CompanyCode,
  CompanyCodeName,
  HouseBank,
  HouseBankAccount,
  HouseBankAccountDescription,
  BankAccountNumber,
  BankInternalID,
  BankNumber,
  BankName,
  BankCountry,
  CountryName,
  IBAN,
  SWIFTCode,
  BankAccountCurrency,
  CurrencyName,
  BankControlKey,
  CustomerByHouseBank,
  LtstInstntBalResponseNumber,
  BkAcctInstantBalanceAmount,
  BkAcctInstantBalanceCurrency,
  BkAcctInstantBalanceDateTime,
  cast(BkAcctInstantBalanceDateTime as fclm_ib_utc_available_at preserving type) AS BkAcctInstntBalanceUTCDateTime,
  LtstInstntBalRspCreatedByUser,
  LtstInstntBalRspCrtedByUsrDesc,
  LtstInstntBalRspDateTime,
  cast(LtstInstntBalRspDateTime as fclm_ib_last_resp_utc_crted_at preserving type) AS LtstInstntBalRspUTCDateTime,
  LtstAvailBalReqCrtedByUsr,
  LtstAvailBalReqCrtedByUsrDesc,
  LtstAvailInstntBalReqDateTme,
  LtstInstntBalRequestNumber,
  InstantBalanceRequestState,
  InstntBalReqStateCriticality,
  _InstantBalanceRequestState._Text[1: Language = $session.system_language].InstantBalanceRequestStateText AS InstantBalanceRequestStateText,
  LtstInstntBalReqCreatedByUser,
  LtstInstntBalReqCrtedByUsrDesc,
  LtstInstntBalReqDateTime,
  1 AS DummyMeasure,
  cast('UTC' as timezone) AS CurrentTimeZoneCode
FROM C_BkAcctInstntBalMntrWthReqRsp
LEFT OUTER JOIN C_BkAcctInstantBalanceHistory AS _BkAcctInstantBalanceHistory ON BankAccountInternalID = _BkAcctInstantBalanceHistory.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _LtstRspCreatedByUserCntctCard ON LtstInstntBalRspCreatedByUser = _LtstRspCreatedByUserCntctCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LtstReqCreatedByUserCntctCard ON LtstInstntBalReqCreatedByUser = _LtstReqCreatedByUserCntctCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LtstAvailCrtedByUsrCntctCard ON LtstAvailBalReqCrtedByUsr = _LtstAvailCrtedByUsrCntctCard.ContactCardID  -- association [0..1]
;