FCLM_BAL_ACCT_SETTING_HISTORY

DDL: FCLM_BAL_ACCT_SETTING_HISTORY Type: view_entity Package: FCLM_BALANCE
28 Fields 1 Data Sources 7 Associations

Bank Account Setting History

FCLM_BAL_ACCT_SETTING_HISTORY is a CDS View that provides data about "Bank Account Setting History" in SAP S/4HANA. It reads from 1 data source (I_BankAccountSettingHistory) and exposes 28 fields with key fields BankAccountInternalID, ValidityStartDate. It has 7 associations to related views. Part of development package FCLM_BALANCE.

Data Sources (1)

SourceAliasJoin Type
I_BankAccountSettingHistory Setting from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_CashBalancePostingTypeText _BankStatementPostingType $projection.BankStatementPostingType = _BankStatementPostingType.BankStatementPostingType and _BankStatementPostingType.Language = $session.system_language
[0..1] I_CashBalanceTransferModeText _BankStatementTransferMode $projection.BankStatementTransferMode = _BankStatementTransferMode.BankStatementTransferMode and _BankStatementTransferMode.Language = $session.system_language
[0..1] I_BankStmntSettingSourceText _SettingSource $projection.BankStatementSettingSource = _SettingSource.BankStatementSettingSource and _SettingSource.Language = $session.system_language
[0..1] I_IntradayBkStmntPostgTxt _IntradayPostingType $projection.IntradayBankStatementPosting = _IntradayPostingType.IntradayBankStatementPosting and _IntradayPostingType.Language = $session.system_language
[0..1] I_BankStatementForwardingText _BankStatementForwarding $projection.BankStatementForwardingType = _BankStatementForwarding.BankStatementForwardingType and _BankStatementForwarding.Language = $session.system_language
[0..1] I_IntrdayBkStmntTransfModeText _IntradayTransferMode $projection.IntraBankStatementTransferMode = _IntradayTransferMode.IntraBankStatementTransferMode and _IntradayTransferMode.Language = $session.system_language
[0..1] I_UserContactCard _LastChangeUser $projection.LastChangedByUser = _LastChangeUser.ContactCardID

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Account Setting History view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
KEY ValidityStartDate ValidityStartDate Validity Start Date
BankAccountSettingUniqueID BankAccountSettingUniqueID
ValidityEndDate ValidityEndDate ValidTo
CompanyCode CompanyCode Receiver Company Code
BankStatementPostingType BankStatementPostingType Post. Category (EoD)
IntradayBankStatementPosting IntradayBankStatementPosting Intraday Post. Cat.
BankStatementForwardingType BankStatementForwardingType File Forwarding
BankStatementTransferMode BankStatementTransferMode Transfer Mode (EoD)
IntraBankStatementTransferMode IntraBankStatementTransferMode
ManualInputBalanceIsEnabled ManualInputBalanceIsEnabled Manual Entry
ExcelImportBalanceIsEnabled ExcelImportBalanceIsEnabled Spreadsheet Import
InternalAPIBalanceIsEnabled InternalAPIBalanceIsEnabled EPIC
BankStatementSettingSource BankStatementSettingSource Setting Source
BankStatementPostingTypeText _BankStatementPostingType BankStatementPostingTypeText
IntradayBkStatementPostingText _IntradayPostingType IntradayBkStatementPostingText
BankStatementForwardingText _BankStatementForwarding BankStatementForwardingText
BankStatementTransferModeText _BankStatementTransferMode BankStatementTransferModeText
IntrdayBkStmntTransfModeTxt _IntradayTransferMode IntrdayBkStmntTransfModeTxt
BankStatementSettingSourceText _SettingSource BankStatementSettingSourceText
LastChangedByUser LastChangedByUser User Name
UserDescription _LastChangeUser UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
_BankStatementPostingType _BankStatementPostingType
_BankStatementTransferMode _BankStatementTransferMode
_IntradayPostingType _IntradayPostingType
_BankStatementForwarding _BankStatementForwarding
_LastChangeUser _LastChangeUser

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_HISTORY.
-- 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 FCLM_BAL_ACCT_SETTING_HISTORY AS
SELECT
  BankAccountInternalID,
  ValidityStartDate,
  BankAccountSettingUniqueID,
  ValidityEndDate,
  CompanyCode,
  BankStatementPostingType,
  IntradayBankStatementPosting,
  BankStatementForwardingType,
  BankStatementTransferMode,
  IntraBankStatementTransferMode,
  ManualInputBalanceIsEnabled,
  ExcelImportBalanceIsEnabled,
  InternalAPIBalanceIsEnabled,
  BankStatementSettingSource,
  _BankStatementPostingType.BankStatementPostingTypeText AS BankStatementPostingTypeText,
  _IntradayPostingType.IntradayBkStatementPostingText AS IntradayBkStatementPostingText,
  _BankStatementForwarding.BankStatementForwardingText AS BankStatementForwardingText,
  _BankStatementTransferMode.BankStatementTransferModeText AS BankStatementTransferModeText,
  _IntradayTransferMode.IntrdayBkStmntTransfModeTxt AS IntrdayBkStmntTransfModeTxt,
  _SettingSource.BankStatementSettingSourceText AS BankStatementSettingSourceText,
  LastChangedByUser,
  _LastChangeUser.UserDescription AS UserDescription,
  LastChangeDateTime
FROM I_BankAccountSettingHistory AS Setting
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 _IntradayPostingType ON IntradayBankStatementPosting = _IntradayPostingType.IntradayBankStatementPosting AND _IntradayPostingType.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_IntrdayBkStmntTransfModeText AS _IntradayTransferMode ON IntraBankStatementTransferMode = _IntradayTransferMode.IntraBankStatementTransferMode AND _IntradayTransferMode.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangeUser ON LastChangedByUser = _LastChangeUser.ContactCardID  -- association [0..1]
;

Learn More