C_BkAcctInstntBalMntrWthReqRsp

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_BkAcctInstntBalMntrWthReqRsp.
-- 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_BkAcctInstntBalMntrWthReqRsp AS
SELECT
  BankAccountInternalID,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  HouseBank,
  HouseBankAccount,
  HouseBankAccountDescription,
  BankAccountNumber,
  BankInternalID,
  BankNumber,
  _BankData.BankName AS BankName,
  BankCountry,
  _BankCountry._Text[1: Language = $session.system_language].CountryName AS CountryName,
  IBAN,
  SWIFTCode,
  BankAccountCurrency,
  cast( _Currency._Text[1: Language = $session.system_language].CurrencyName as fclm_ib_acc_blnc_currency_name preserving type ) AS CurrencyName,
  BankControlKey,
  CustomerByHouseBank,
  _BkAcctInstntBalLtstResponse.LtstInstntBalResponseNumber AS LtstInstntBalResponseNumber,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceAmount AS BkAcctInstantBalanceAmount,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceCurrency AS BkAcctInstantBalanceCurrency,
  _BkAcctInstntBalLtstResponse.BkAcctInstantBalanceDateTime AS BkAcctInstantBalanceDateTime,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceResponseTP.CreatedByUser as fclm_ib_last_resp_created_by preserving type) AS LtstInstntBalRspCreatedByUser,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceResponseTP._UserCreate.UserDescription as fclm_ib_lst_resp_crtd_by_descr preserving type) AS LtstInstntBalRspCrtedByUsrDesc,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceResponseTP.CreationDateTime as fclm_ib_last_resp_created_at preserving type) AS LtstInstntBalRspDateTime,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceRequestTP.CreatedByUser as fclm_ib_last_avail_blnc_req_by preserving type) AS LtstAvailBalReqCrtedByUsr,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceRequestTP._UserCreate.UserDescription as fclm_ib_lst_avail_req_by_desc preserving type) AS LtstAvailBalReqCrtedByUsrDesc,
  cast(_BkAcctInstntBalLtstResponse._InstantBalanceRequestTP.CreationDateTime as fclm_ib_last_avail_blnc_req_at preserving type) AS LtstAvailInstntBalReqDateTme,
  _BkAcctInstntBalLtstRequest.LtstInstntBalRequestNumber AS LtstInstntBalRequestNumber,
  cast(coalesce(_BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.InstantBalanceRequestState, '00') as fclm_ib_current_update_status preserving type) AS InstantBalanceRequestState,
  _BkAcctInstntBalLtstRequest._InstantBalanceRequestTP._InstantBalanceRequestState._Criticality.InstntBalReqStateCriticality AS InstntBalReqStateCriticality,
  cast(_BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.CreatedByUser as fclm_ib_lst_request_created_by preserving type) AS LtstInstntBalReqCreatedByUser,
  cast(_BkAcctInstntBalLtstRequest._InstantBalanceRequestTP._UserCreate.UserDescription as fclm_ib_last_req_crted_by_desc preserving type) AS LtstInstntBalReqCrtedByUsrDesc,
  cast(_BkAcctInstntBalLtstRequest._InstantBalanceRequestTP.CreationDateTime as fclm_ib_last_req_created_at preserving type) AS LtstInstntBalReqDateTime
FROM I_BkAcctInstntBalanceEnhanced
LEFT OUTER JOIN C_BkAcctInstntBalLtstRequest AS _BkAcctInstntBalLtstRequest ON BankAccountInternalID = _BkAcctInstntBalLtstRequest.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN C_BkAcctInstntBalLtstResponse AS _BkAcctInstntBalLtstResponse ON BankAccountInternalID = _BkAcctInstntBalLtstResponse.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_InstantBalanceRequestState AS _InstantBalanceRequestState ON InstantBalanceRequestState = _InstantBalanceRequestState.InstantBalanceRequestState  -- association [0..1]
;