I_BankAccountSetting

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_BankAccountSetting.
-- 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_BankAccountSetting AS
SELECT
  config.acc_id AS BankAccountInternalID,
  config.valid_from AS ValidityStartDate,
  config.valid_to AS ValidityEndDate,
  config.bs_post_cat AS BankStatementPostingType,
  config.bs2fqm_mode AS BankStatementTransferMode,
  config.flag_epic AS InternalAPIBalanceIsEnabled,
  config.flag_import AS ExcelImportBalanceIsEnabled,
  config.flag_manual AS ManualInputBalanceIsEnabled,
  config.bs_forwarding AS BankStatementForwardingType,
  config.intraday_bs_post_cat AS IntradayBankStatementPosting,
  config.bs2fqm_mode_intra AS IntraBankStatementTransferMode,
  _BankStatementPostingType.BankStatementPostingTypeText AS BankStatementPostingTypeText,
  _BankStatementTransferMode.BankStatementTransferModeText AS BankStatementTransferModeText,
  _BankStatementForwarding.BankStatementForwardingText AS BankStatementForwardingText,
  _IntradayBankStatementPosting.IntradayBkStatementPostingText AS IntradayBkStatementPostingText,
  _IntraBankStatementTransferMod.IntrdayBkStmntTransfModeTxt AS IntrdayBkStmntTransfModeTxt
FROM fclm_acc_bs_conf AS config
LEFT OUTER JOIN I_CashBalancePostingTypeText AS _BankStatementPostingType ON BankStatementPostingType = _BankStatementPostingType.BankStatementPostingType AND _BankStatementPostingType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CashBalanceTransferModeText AS _BankStatementTransferMode ON BankStatementTransferMode = _BankStatementTransferMode.BankStatementTransferMode AND _BankStatementTransferMode.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankStatementForwardingText AS _BankStatementForwarding ON BankStatementForwardingType = _BankStatementForwarding.BankStatementForwardingType AND _BankStatementForwarding.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IntradayBkStmntPostgTxt AS _IntradayBankStatementPosting ON IntradayBankStatementPosting = _IntradayBankStatementPosting.IntradayBankStatementPosting AND _IntradayBankStatementPosting.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IntrdayBkStmntTransfModeText AS _IntraBankStatementTransferMod ON IntraBankStatementTransferMode = _IntraBankStatementTransferMod.IntraBankStatementTransferMode AND _IntraBankStatementTransferMod.Language = $session.system_language  -- association [0..1]
;