FCLM_BALANCE_ACCOUNT

Account with manual balance | view: VBALACCOUNT | TRAN | Extraction: Not supported | Component: Bank Account Management
Column Name Description
BankAccountInternalID Bank Account Technical ID
CashBalanceDate Date
CashBalanceKey Technical ID
Column Name Description
💲 Balance Currency (CashBalanceCurrency):
CashBalanceAmount Balance Amount
Column Name Description
Column Name Description
CashBalanceDate Date
Column Name Description
CashBalanceChannel Bank Account Balance Update Method Show values
BankAccountStatus Bank Account Status Show values
Column Name Description Domain name
CashBalanceChannelText Short Text for Fixed Values DDTEXT
LastChangedByUser User Name UNAME
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUserName User Description SUIDTECHDESC
CreatedByUser User Name UNAME
CreatedByUserName User Description SUIDTECHDESC
CashBalanceCreatedAtDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
iban IBAN (International Bank Account Number) IBAN
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
GLAccount General Ledger Account SAKNR
CompanyCodeName Name of Company Code or Company TEXT25
CountryShortName Name of Country/Region (Short) TEXT15
CurrencyShortName Short text TEXT15
BankName Name of Financial Institution TEXT60
BankAccountTypeText Bank Account Type Description TEXT60
BankAccountStatusName Bank Account Status Description DDTEXT
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • FCLM_BALANCE_ACCOUNT.MANDT == TCURC.MANDT
  • FCLM_BALANCE_ACCOUNT.BANKACCOUNTCURRENCY == TCURC.WAERS
Bank Account Type ID
  • Client
  • Bank Account Type ID
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • FCLM_BALANCE_ACCOUNT.BANKCOUNTRY == T005.LAND1
  • FCLM_BALANCE_ACCOUNT.MANDT == T005.MANDT
Bank Key
  • Bank Key
  • Bank Country/Region Key
  • Client
  • FCLM_BALANCE_ACCOUNT.BANKKEY == BNKA.BANKL
  • FCLM_BALANCE_ACCOUNT.BANKCOUNTRY == BNKA.BANKS
  • FCLM_BALANCE_ACCOUNT.MANDT == BNKA.MANDT
Company Code
  • Company Code
  • Client
  • FCLM_BALANCE_ACCOUNT.COMPANYCODE == T001.BUKRS
  • FCLM_BALANCE_ACCOUNT.MANDT == T001.MANDT