TFTE_BSM_CUST (Customizing: 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 TFTE_BSM_CUST to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||
|
HBKID
Short Key for a House Bank
|
HBKID | T012 |
CHAR
|
5 | 0 | |||||||||||||
|
HKTID
ID for account details
|
HKTID | T012K |
CHAR
|
5 | 0 | |||||||||||||
|
PROCSTAT_ACT
Activate Processing Status for Bank Statement
|
PROCSTAT_ACT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
BALSTAT_ACT
Activate Difference Status for Bank Statement
|
BALSTAT_ACT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
SERSTAT_ACT
Activate Serial Number Status for Bank Statement
|
SERSTAT_ACT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
RECONSTAT_ACT
Activate Reconciliation Status for Bank Statement
|
RECONSTAT_ACT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
EXP_NUMBER
Interval for Expected Bank Statements
|
EXP_NUMBER |
NUMC
|
2 | 0 | ||||||||||||||
|
EXP_RHYTH
FTE-BSM: Frequency Unit
|
EXP_RHY |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CALENDAR
Factory Calendar
|
WFCID | TFACD |
CHAR
|
2 | 0 | |||||||||||||
|
SORT_IDX
FTE-BSM: Display Item in Bank Statement Monitor
|
DISP_IDX |
NUMC
|
3 | 0 | ||||||||||||||
|
AMT_DIFF
FTE_BSM: Difference Amount Permitted in Account Currency
|
AMT_DIFF |
CURR
|
13 | 2 | ||||||||||||||
|
CURR_DIFF
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TFTE_BSM_CUST | BUKRS | TFTE_BSM_CUST | MANDT |
T001
Company Codes
|
MANDT |
| TFTE_BSM_CUST | BUKRS | TFTE_BSM_CUST | BUKRS |
T001
Company Codes
|
BUKRS |
| TFTE_BSM_CUST | CALENDAR | TFTE_BSM_CUST | CALENDAR |
TFACD
Factory calendar definition
|
IDENT |
| TFTE_BSM_CUST | CURR_DIFF | TFTE_BSM_CUST | MANDT |
TCURC
Currency Codes
|
MANDT |
| TFTE_BSM_CUST | CURR_DIFF | TFTE_BSM_CUST | CURR_DIFF |
TCURC
Currency Codes
|
WAERS |
| TFTE_BSM_CUST | HBKID | TFTE_BSM_CUST | MANDT |
T012
House Banks
|
MANDT |
| TFTE_BSM_CUST | HBKID | TFTE_BSM_CUST | BUKRS |
T012
House Banks
|
BUKRS |
| TFTE_BSM_CUST | HBKID | TFTE_BSM_CUST | HBKID |
T012
House Banks
|
HBKID |
| TFTE_BSM_CUST | HKTID | TFTE_BSM_CUST | BUKRS |
T012K
House Bank Accounts
|
BUKRS |
| TFTE_BSM_CUST | HKTID | TFTE_BSM_CUST | HBKID |
T012K
House Bank Accounts
|
HBKID |
| TFTE_BSM_CUST | HKTID | TFTE_BSM_CUST | HKTID |
T012K
House Bank Accounts
|
HKTID |
| TFTE_BSM_CUST | HKTID | TFTE_BSM_CUST | MANDT |
T012K
House Bank Accounts
|
MANDT |