SAP Table FTE_BSM_STATEMENT
FTE-BSM: Display Structure for Bank Statement Monitor
FTE_BSM_STATEMENT (FTE-BSM: Display Structure for Bank Statement Monitor) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FTE_BSM_STATEMENT to other SAP tables.
FTE_BSM_STATEMENT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | 0 | |||
| HOUSEBANK_ID | Short Key for a House Bank | HBKID | CHAR | 5 | 0 | |||
| ACCOUNT_ID | ID for account details | HKTID | CHAR | 5 | 0 | |||
| CM_ACCOUNT_NAME | Cash Management Account Name | DISKB | CHAR | 10 | 0 | |||
| CURRENCY | Currency Key | WAERS | CUKY | 5 | 0 | |||
| COUNTRY | Bank country key | BANKS | CHAR | 3 | 0 | |||
| BANK_KEY | Bank number | BANKL | CHAR | 15 | 0 | |||
| EXT_ACCOUNT_NO | Bank account number | BANKN | CHAR | 18 | 0 | |||
| ALT_ACCOUNT_NO | Alternative Bank Acct Number (for Ambiguous Acct Number) | BNKN2 | CHAR | 24 | 0 | |||
| GL_ACCOUNT | General Ledger Account | HKONT | CHAR | 10 | 0 | |||
| STATEMENT_DATE | Statement Date | AZDAT_EB | DATS | 8 | 0 | |||
| STATEMENT_NO | Statement number | AZNUM_EB | NUMC | 5 | 0 | |||
| NO_ITEMS | Number of memo records from the bank statement | ANZES_EB | NUMC | 5 | 0 | |||
| IMPORT_DATE | Import date into bank data puffer | EDATE_EB | DATS | 8 | 0 | |||
| IMPORT_TIME | Import time into bank data buffer | ETIME_EB | TIMS | 6 | 0 | |||
| OPEN_BAL_STATEMT | Opening balance amount | SSBTR_EB | CURR | 17 | 2 | |||
| TOTAL_DEBITS | Total Debit | SUMSO_EB | CURR | 17 | 2 | |||
| TOTAL_CREDITS | Total Credit | SUMHA_EB | CURR | 17 | 2 | |||
| CLOS_BAL_STATEMT | Ending balance amount | ESBTR_EB | CURR | 17 | 2 | |||
| CLOS_BAL_GL | FTE-BSM: Closing Balance in G/L Account | ESBTR_GL | CURR | 17 | 2 | |||
| DIFF_STAT_GL | FTE-BSM: Difference Amount | DIFF_AMT | CURR | 17 | 2 | |||
| PROC_STAT | Processing Status for Bank Statement | PROC_STAT | CHAR | 132 | 0 | |||
| BAL_STAT | Difference Status for Bank Statement | BAL_STAT | CHAR | 132 | 0 | |||
| SERIAL_STAT | Serial Number Status for Bank Statement | SERIAL_STAT | CHAR | 132 | 0 | |||
| RECON_STAT | Reconciliation Status for Bank Statement | RECON_STAT | CHAR | 132 | 0 | |||
| SWIFT_CODE | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | 0 | |||
| CONTACT_NAME | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||
| CONTACT_TEL | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | 0 | |||
| BANK_NAME | Name of bank | BANKA | CHAR | 60 | 0 | |||
| TABIX | Row Index of Internal Tables | SYTABIX | INT4 | 10 | 0 | |||
| KUKEY | Short key (surrogate) | KUKEY_EB | NUMC | 8 | 0 | |||
| EUSER | User name | USNAM | CHAR | 12 | 0 | |||
