FCLM_BAM_AMD - Bank Account Master Data

Bank Account Master Data information is stored in SAP table FCLM_BAM_AMD.
It is part of development package FCLM_BAM in software component FIN-FSCM-CLM-BAM. This development package consists of objects that can be grouped under "Bank Account Management".

Fields for table FCLM_BAM_AMD

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