ESH_S_HOUSEBANKACCT_BAM

Search view for search model HOUSEBANKACCT_BAM_H | view: ESH_U_HOUSEBANKB | Extraction: Not supported | Component: Information System
Tables used: BNKA, T001, FCLM_BAM_AMD_T, FCLM_BAM_AMD, FCLM_BAM_ACLINK2, T012, T005T, T035T
Column Name Description
Column Name Description
Column Name Description
Column Name Description
valid_from Bank Account Opening Date
valid_to Bank Account Closing Date
Column Name Description
Column Name Description Domain name
guid GUID SYSUUID_C
herku Remote System LOGSYS
bukrs Company Code BUKRS
hktid House Bank Account HKTID
bankn Bank account number
refzl Reference Information CHAR27
dtaai DME Sold-To Party Identification (Switzerland) CHAR5
bnkn2 Alternative Bank Account Number (for Ambiguous Acct Number) BNKN2
mindt Minimum days until due date when presenting for collection NUM03
butxt Name of Company Code or Company
VALUE_TEXT Country/Region Name
textl Description TEXT30
description Account Description
bankl Bank Keys
banka Name of Financial Institution
iban IBAN (International Bank Account Number) IBAN
prctr Profit Center PRCTR
beneficial Bank Account Holder TEXT60
bank_contact General Contact Person at Bank BU_PARTNER
rel_manager Bank Relationship Manager BU_PARTNER
created_by Created By XUBNAME
control_key Bank Control Key BKONT
opened_by Bank Account: Opened By XUBNAME
changed_by Changed By XUBNAME
reviewed_by Bank Account Master Record Reviewed By XUBNAME
closed_by Closed By XUBNAME
Master Data Relations Join Conditions
Settlement currency for bank transfers
  • Settlement currency for bank transfers
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.ABWAE == TCURC.WAERS
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == TCURC.MANDT
Bank Account Supervisor
  • Client
  • Bank Account Supervisor
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == USR02.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.ACCOUNT_SUPERVISOR == USR02.BNAME
Bank Account Technical ID
  • Client
  • ?
  • Bank Account Technical ID
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == FCLM_BAM_AMD.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • ESH_S_HOUSEBANKACCT_BAM.ACC_ID == FCLM_BAM_AMD.ACC_ID
Bank Key
  • Bank Keys
  • Bank Key
  • Bank Country/Region Key
  • Country/Region Key of Bank
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.BANKL == BNKA.BANKL
  • ESH_S_HOUSEBANKACCT_BAM.BANKL1 == BNKA.BANKL
  • ESH_S_HOUSEBANKACCT_BAM.BANKS1 == BNKA.BANKS
  • ESH_S_HOUSEBANKACCT_BAM.BANKS == BNKA.BANKS
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == BNKA.MANDT
Country/Region Key of Bank
  • Bank Country/Region Key
  • Country/Region Key of Bank
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.BANKS1 == T005.LAND1
  • ESH_S_HOUSEBANKACCT_BAM.BANKS == T005.LAND1
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T005.MANDT
Bank Country/Region Key
  • Bank Country/Region Key
  • Country/Region Key of Bank
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.BANKS1 == T005.LAND1
  • ESH_S_HOUSEBANKACCT_BAM.BANKS == T005.LAND1
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T005.MANDT
Company Contact Person
  • Client
  • Company Contact Person
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == USR02.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.COMPANY_CONTACT == USR02.BNAME
Planning Group
  • Planning Group
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.FDGRP == T035.GRUPP
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T035.MANDT
Short Key for a House Bank
  • Client
  • Company Code
  • Short Key for a House Bank
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T012.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.BUKRS == T012.BUKRS
  • ESH_S_HOUSEBANKACCT_BAM.HBKID == T012.HBKID
General ledger account
  • General Ledger Account
  • Client
  • Company Code
  • ESH_S_HOUSEBANKACCT_BAM.HKONT == SKB1.SAKNR
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == SKB1.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.BUKRS == SKB1.BUKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.KTOPL == T004.KTOPL
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T004.MANDT
Revision Number
  • Client
  • Revision Number
  • Bank Account Technical ID
Payment Transaction Type Group
  • Payment Transaction Type Group
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.VGTYP == T028V.VGTYP
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == T028V.MANDT
Currency Key
  • Currency Key
  • Client
  • ESH_S_HOUSEBANKACCT_BAM.WAERS == TCURC.WAERS
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == TCURC.MANDT
Subaccount for Bill of Exchange Presentation for Discounting
  • Subaccount for Bill of Exchange Presentation for Discounting
  • Client
  • Company Code
  • ESH_S_HOUSEBANKACCT_BAM.WEKON == SKB1.SAKNR
  • ESH_S_HOUSEBANKACCT_BAM.MANDT == SKB1.MANDT
  • ESH_S_HOUSEBANKACCT_BAM.BUKRS == SKB1.BUKRS