SAP table FCLM_BAM_AMD (Bank Account Master Data)

SAP table FCLM_BAM_AMD has 3 primary key fields being MANDT,ACC_ID,REVISION.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ACC_ID Bank Account Technical ID NUMC 10 0 FCLM_BAM_ACC_ID
REVISION Revision Number NUMC 4 0 FCLM_REVISION
BANKS Bank Country/Region Key CHAR 3 0 T005 FCLM_BAM_BANK_COUNTRY_KEY
BANKL Bank Key CHAR 15 0 BNKA FCLM_BAM_BANK_KEY
ACC_NUM Bank Account Number CHAR 40 0 FCLM_BAM_ACC_NUM
ACC_TYPE_ID Bank Account Type ID CHAR 10 0 FCLM_BAM_AC_TYPE FCLM_BAM_BK_ACC_TYPE_ID
VALID_FROM Bank Account Opening Date DATS 8 0 FCLM_BAM_AMD_VALID_FROM
VALID_TO Bank Account Closing Date DATS 8 0 FCLM_BAM_AMD_VALID_TO
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
STATUS Bank Account Status CHAR 2 0 FCLM_BAM_ACC_STATUS
01 Inactive
02 Active
09 Marked for Closing
10 Closing Request Sent to Bank
11 Closed at Bank
15 Closed
99 Withdrawn
CASH_POOL Obsolete: Bank Account Master Data: Cash Pool CHAR 30 0 FCLM_BAM_CASH_POOL
CASH_POOL_ID Cash Pool ID CHAR 10 0 FCLM_BAM_CASH_POOL_ID
BUKRS Company Code CHAR 4 0 T001 BUKRS
PRCTR Profit Center CHAR 10 0 PRCTR
GSBER Business Area CHAR 4 0 TGSB GSBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
BENEFICIAL Bank Account Holder CHAR 60 0 FCLM_BAM_BENEFICIARY_NAME
BANK_CONTACT General Contact Person at Bank CHAR 10 0 FCLM_BAM_CONTACT_PERSON
REL_MANAGER Bank Relationship Manager CHAR 10 0 FCLM_BAM_REL_MANAGER
COMPANY_CONTACT Company Contact Person CHAR 12 0 USR02 FCLM_BAM_COMPANY_CONTACT
ACCOUNT_SUPERVISOR Bank Account Supervisor CHAR 12 0 USR02 FCLM_BAM_ACCOUNT_SUPERVISOR
EDBSUM Import Method for End-of-Day Bank Statements CHAR 16 0 FCLM_BAM_BSIMP FCLM_BAM_IMPORT_TYPE_ENDOF_DAY
IDBSUM Import Method for Intraday Bank Statements CHAR 16 0 FCLM_BAM_BSIMP FCLM_BAM_IMPORT_TYPE_INTRA_DAY
BS_UPLOAD_TIME Bank Statement Check Time TIMS 6 0 FCLM_BAM_IMPORT_TIME
CREATED_AT [Obseleted] Timestamp DEC 15 0 FCLM_BAM_OBSOLETEDTIMESTAMP
CREATED_BY Created By CHAR 12 0 FCLM_BAM_CREATED_BY
OPENED_AT [Obseleted] Timestamp DEC 15 0 FCLM_BAM_OBSOLETEDTIMESTAMP
OPENED_BY Bank Account: Opened By CHAR 12 0 FCLM_BAM_OPENED_BY
CHANGED_AT [Obseleted] Timestamp DEC 15 0 FCLM_BAM_OBSOLETEDTIMESTAMP
CHANGED_BY Changed By CHAR 12 0 FCLM_BAM_CHANGED_BY
REVIEWED_AT [Obseleted] Timestamp DEC 15 0 FCLM_BAM_OBSOLETEDTIMESTAMP
REVIEWED_BY Bank Account Master Record Reviewed By CHAR 12 0 FCLM_BAM_REVIEWED_BY
CLOSED_AT [Obseleted] Timestamp DEC 15 0 FCLM_BAM_OBSOLETEDTIMESTAMP
CLOSED_BY Closed By CHAR 12 0 FCLM_BAM_CLOSED_BY
DELETED_FLAG Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') CHAR 1 0 BOOLE_D
IMPORTING_CHANNEL Bank Statement Importing Channel CHAR 16 0 FCLM_BAM_IMPORTING_CHANNEL
AUTOMATIC Automatic
MANUAL Manual
CUTOFF_TIME_D Cut-Off Time Domestic TIMS 6 0 FCLM_BAM_CUTOFF_TIME_D
CUTOFF_TIME_C Cut-Off Time Cross Border TIMS 6 0 FCLM_BAM_CUTOFF_TIME_C
PLANNED_CLOSING_DATE Planned Closing Date DATS 8 0 FCLM_BAM_PLANNING_CLOSE_DATE
UPLOAD_BS_FLAG Upload of Intraday Statements CHAR 1 0 FCLM_BAM_UPLOAD_INTRADAY_FLG
CREATED_AT_DAT Bank Account Created On DATS 8 0 FCLM_BAM_CREATED_ON
CREATED_AT_TIM Created At TIMS 6 0 FCLM_BAM_CREATED_AT
OPENED_AT_DAT Bank Account: Openned On DATS 8 0 FCLM_BAM_OPENED_ON
OPENED_AT_TIM Bank Account Opened At TIMS 6 0 FCLM_BAM_OPENED_AT
CHANGED_AT_DAT Changed On DATS 8 0 FCLM_BAM_CHANGED_ON
CHANGED_AT_TIM Changed At TIMS 6 0 FCLM_BAM_CHANGED_AT
CLOSED_AT_DAT Closed On DATS 8 0 FCLM_BAM_CLOSED_ON
CLOSED_AT_TIM Closed At TIMS 6 0 FCLM_BAM_CLOSED_AT
CONTROL_KEY Bank Control Key CHAR 2 0 BKONT
IBAN_VALID_FROM IBAN Valid From DATS 8 0 FCLM_BAM_IBAN_VALID_FROM
OBJNR Object number CHAR 22 0 J_OBJNR
VGTYP Payment Transaction Type Group CHAR 8 0 T028V FARP_VGTYP
PROCSTAT_ACT Activate Processing Status for Bank Statement CHAR 1 0 PROCSTAT_ACT
BALSTAT_ACT Activate Difference Status for Bank Statement CHAR 1 0 BALSTAT_ACT
SERSTAT_ACT Activate Serial Number Status for Bank Statement CHAR 1 0 SERSTAT_ACT
RECONSTAT_ACT Activate Reconciliation Status for Bank Statement CHAR 1 0 RECONSTAT_ACT
EXP_NUMBER Interval for Expected Bank Statements NUMC 2 0 EXP_NUMBER
EXP_RHYTH FTE-BSM: Frequency Unit NUMC 1 0 EXP_RHY
CALENDAR Factory Calendar CHAR 2 0 WFCID
SORT_IDX FTE-BSM: Display Item in Bank Statement Monitor NUMC 3 0 DISP_IDX
AMT_DIFF FTE_BSM: Difference Amount Permitted in Account Currency CURR 23 2 AMT_DIFF
WAERS Currency Key CUKY 5 0 TCURC WAERS_CURC
CASH_POOL_ID_PARTICIPANT Cash Pool for Subaccount CHAR 10 0 FCLM_BAM_PAR_CASH_POOL_ID
CASH_POOL_TARGET_AMT_MAX Target Balance for Subaccount CURR 23 2 FCLM_BAM_TAR_AMT_MAX
CASH_POOL_TARGET_AMT_MIN Minimum Target Amount for Subaccount CURR 23 2 FCLM_BAM_TAR_AMT_MIN
CASH_POOL_TRANSFER_AMT_MIN Minimum Transfer Amount for Subaccount CURR 23 2 FCLM_BAM_TRANS_AMT_MIN
PAYMENT_METHOD_L Payment Method for Header Account CHAR 1 0 T042Z FCLM_BAM_PAYMENT_METHOD_L
PAYMENT_METHOD_P Payment Method for Subaccount CHAR 1 0 T042Z FCLM_BAM_PAYMENT_METHOD_P
PAYMENT_SERVICE_PROVIDER Payment Service Provider for Digital Payments CHAR 4 0 DP_PAYMENT_SERVICE_PROVIDER
TOLERANCE_GROUP Tolerance Group Key CHAR 10 0 FCLM_D_TOGRU
RECONCILE_INTRADAY Reconcile Intraday Memo Records CHAR 1 0 FCLM_BAM_RECON_INTRA
EXT_RULE_ID Monitoring Rule for Intraday Statements CHAR 5 0 FCLM_BRM_RULE_EXT_ID
PLANNING_LEVEL Planning Level CHAR 2 0 FDLEV
BSR_GROUP Bank Statement Group CHAR 5 0 FCLM_BAL_BSR_GROUP
RECONCILE_ENDOFDAY Reconcile End-of-Day Memo Records CHAR 1 0 FCLM_BAM_RECON_EOD
SGTXT Item Text CHAR 50 0 SGTXT
CASH_POOL_TRANSFER_AMT_MAX Maximum Transfer Amount for Subaccount CURR 23 2 FCLM_BAM_TRANS_AMT_MAX
CONTRACT_TYPE Bank Account Contract Type CHAR 2 0 FCLM_BAM_CONTRACT_TYPE
Current Account
03 Payment Service Provider Account
04 Technical Account
99 Other
OPEN_REQUEST_ID Change Request ID NUMC 12 0 FCLM_BAM_REQ_ID
DUMMY_FCLM_BAM_AMD_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

FCLM_BAM_AMD foreign key relationships

Table Field Check Table Check Field
0 FCLM_BAM_AMD ACCOUNT_SUPERVISOR USR02 Logon Data (Kernel-Side Use) BNAME
1 FCLM_BAM_AMD ACC_TYPE_ID FCLM_BAM_AC_TYPE Bank Account Type MANDT
1 FCLM_BAM_AMD ACC_TYPE_ID FCLM_BAM_AC_TYPE Bank Account Type ACC_TYPE_ID
0 FCLM_BAM_AMD BANKL BNKA Bank master record BANKS
1 FCLM_BAM_AMD BANKS T005 Countries MANDT
1 FCLM_BAM_AMD BANKS T005 Countries LAND1
0 FCLM_BAM_AMD BUKRS T001 Company Codes BUKRS
1 FCLM_BAM_AMD COMPANY_CONTACT USR02 Logon Data (Kernel-Side Use) BNAME
0 FCLM_BAM_AMD GSBER TGSB Business Areas MANDT
0 FCLM_BAM_AMD GSBER TGSB Business Areas GSBER
1 FCLM_BAM_AMD MANDT T000 Clients MANDT
0 FCLM_BAM_AMD PAYMENT_METHOD_L T042Z Payment Methods for Automatic Payment MANDT
0 FCLM_BAM_AMD PAYMENT_METHOD_L T042Z Payment Methods for Automatic Payment LAND1
0 FCLM_BAM_AMD PAYMENT_METHOD_L T042Z Payment Methods for Automatic Payment ZLSCH
1 FCLM_BAM_AMD PAYMENT_METHOD_P T042Z Payment Methods for Automatic Payment MANDT
1 FCLM_BAM_AMD PAYMENT_METHOD_P T042Z Payment Methods for Automatic Payment LAND1
1 FCLM_BAM_AMD PAYMENT_METHOD_P T042Z Payment Methods for Automatic Payment ZLSCH
0 FCLM_BAM_AMD SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FCLM_BAM_AMD WAERS TCURC Currency Codes MANDT
1 FCLM_BAM_AMD WAERS TCURC Currency Codes WAERS