FCLM_BAL_ACCT_SETTING_DETAILS

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 FCLM_BAL_ACCT_SETTING_DETAILS.
-- 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.
-- SQL view name: VBACCTSETDET

CREATE VIEW FCLM_BAL_ACCT_SETTING_DETAILS AS
SELECT
  setting.BankAccountInternalID AS BankAccountInternalID,
  setting.ValidityStartDate AS ValidityStartDate,
  setting.ValidityEndDate AS ValidityEndDate,
  setting.BankStatementPostingType AS BankStatementPostingType,
  setting.IntradayBankStatementPosting AS IntradayBankStatementPosting,
  setting.BankStatementForwardingType AS BankStatementForwardingType,
  setting.BankStatementTransferMode AS BankStatementTransferMode,
  setting.BankStatementSettingSource AS BankStatementSettingSource,
  setting.SpecificSettingIsEnabled AS SpecificSettingIsEnabled,
  setting.ManualInputBalanceIsEnabled AS ManualInputBalanceIsEnabled,
  setting.ExcelImportBalanceIsEnabled AS ExcelImportBalanceIsEnabled,
  setting.InternalAPIBalanceIsEnabled AS InternalAPIBalanceIsEnabled,
  _Account.CompanyCode AS CompanyCode,
  _Account.BankCountry AS BankCountry,
  _Account.Bank AS Bank,
  _Account.BankAccountCurrency AS BankAccountCurrency,
  _Account.BankAccountType AS BankAccountType,
  _Account.BankAccountStatus AS BankAccountStatus,
  _Account.BankAccountNumber AS BankAccountNumber,
  _AccountText.BankAccountDescription AS BankAccountDescription,
  setting.LastChangedByUser AS LastChangedByUser,
  _LastChangeUser.UserDescription AS UserDescription,
  setting.LastChangeDateTime AS LastChangeDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Country.CountryShortName AS CountryShortName,
  _Currency.CurrencyShortName AS CurrencyShortName,
  _Bank.BankName AS BankName,
  _BankAccountTypeText.BankAccountTypeText AS BankAccountTypeText,
  _BankAccountStatus.BankAccountStatusName AS BankAccountStatusName,
  _HouseBankAccount.HouseBank AS HouseBank,
  _HouseBankAccount.HouseBankAccount AS HouseBankAccount,
  _BankStatementPostingType.BankStatementPostingTypeText AS BankStatementPostingTypeText,
  _IntradayBSPostingType.IntradayBkStatementPostingText AS IntradayBkStatementPostingText,
  _BankStatementForwardingType.BankStatementForwardingText AS BankStatementForwardingText,
  _BankStatementTransferMode.BankStatementTransferModeText AS BankStatementTransferModeText,
  _SettingSource.BankStatementSettingSourceText AS BankStatementSettingSourceText
FROM FCLM_BAL_ACCOUNT_SETTINGS AS setting
LEFT OUTER JOIN I_BankAccount AS _Account ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAccountText AS _AccountText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SingleActiveHouseBankAccount AS _HouseBankAccount ON setting.BankAccountInternalID = _HouseBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _Country ON BankCountry = _Country.Country AND _Country.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _Currency ON BankAccountCurrency = _Currency.Currency AND _Currency.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Bank AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountTypeText AS _BankAccountTypeText ON BankAccountType = _BankAccountTypeText.BankAccountType AND _BankAccountTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus AND _BankAccountStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangeUser ON LastChangedByUser = _LastChangeUser.UserID  -- association [0..1]
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_BankStmntSettingSourceText AS _SettingSource ON BankStatementSettingSource = _SettingSource.BankStatementSettingSource AND _SettingSource.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IntradayBkStmntPostgTxt AS _IntradayBSPostingType ON IntradayBankStatementPosting = _IntradayBSPostingType.IntradayBankStatementPosting AND _IntradayBSPostingType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankStatementForwardingText AS _BankStatementForwardingType ON BankStatementForwardingType = _BankStatementForwardingType.BankStatementForwardingType AND _BankStatementForwardingType.Language = $session.system_language  -- association [0..1]
;