ESH_N_HOUSEBANKACCT_BAM_AM_AMD

Node FCLM_BAM_AMD of search model HOUSEBANKACCT_BAM_H | view: ESH_L_HOUSE_AMD | Extraction: Not supported | Component: Information System
Tables used: FCLM_BAM_AMD
Column Name Description
acc_id Bank Account Technical ID
revision Revision Number
Column Name Description
Column Name Description
Column Name Description
valid_from Bank Account Opening Date
valid_to Bank Account Closing Date
planned_closing_date Planned Closing Date
created_at_dat Bank Account Created On
Column Name Description
status Bank Account Status Show values
Column Name Description Domain name
acc_num Bank Account Number FCLM_BAM_ACC_NUM
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
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
control_key Bank Control Key BKONT
Master Data Relations Join Conditions
Bank Account Supervisor
  • Bank Account Supervisor
  • Client
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.ACCOUNT_SUPERVISOR == USR02.BNAME
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == USR02.MANDT
Bank Key
  • Client
  • Bank Country/Region Key
  • Bank Key
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == BNKA.MANDT
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.BANKS == BNKA.BANKS
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.BANKL == BNKA.BANKL
Bank Country/Region Key
  • Client
  • Bank Country/Region Key
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == T005.MANDT
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.BANKS == T005.LAND1
Company Contact Person
  • Client
  • Company Contact Person
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == USR02.MANDT
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.COMPANY_CONTACT == USR02.BNAME
Payment Transaction Type Group
  • Client
  • Payment Transaction Type Group
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == T028V.MANDT
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.VGTYP == T028V.VGTYP
Currency Key
  • Client
  • Currency Key
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.MANDT == TCURC.MANDT
  • ESH_N_HOUSEBANKACCT_BAM_AM_AMD.WAERS == TCURC.WAERS