SAP ABAP Table FEBKO (Electronic Bank Statement Header Records)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷
FIN-FSCM-CLM-CM-CM (Application Component) Basic Functions
⤷
FTE (Package) Bank accounting: External payment information
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | FEBKO |
|
| Short Description | Electronic Bank Statement Header Records |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
ANWND_EBKO | ANWND_EBKO | CHAR | 4 | 0 | Application using bank data storage | ||
| 3 | |
ABSND_EB | CHAR50 | CHAR | 50 | 0 | Sending bank (electronic bank statement) | ||
| 4 | |
AZIDT_EB | CHAR20 | CHAR | 20 | 0 | Bank statement identification | ||
| 5 | |
EMKEY_EB | CHAR20 | CHAR | 20 | 0 | Payee Keys | ||
| 6 | |
KUKEY_EB | KUKEY_EB | NUMC | 8 | 0 | Short key (surrogate) | ||
| 7 | |
ASTAT_EB | CHAR1 | CHAR | 1 | 0 | Statement status | ||
| 8 | |
DSTAT_EB | CHAR1 | CHAR | 1 | 0 | Print status | ||
| 9 | |
VB1OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 1 are OK | ||
| 10 | |
VB2OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 2 are OK | ||
| 11 | |
KIPRE_EB | CHAR1 | CHAR | 1 | 0 | All items on header record were interpreted | ||
| 12 | |
VFDAT_EB | DATUM | DATS | 8 | 0 | Data expiry date | ||
| 13 | |
GRP01_EB | CHAR12 | CHAR | 12 | 0 | Session name for bank postings | ||
| 14 | |
XKEP1_EB | CHAR1 | CHAR | 1 | 0 | Keep session 1 after processing | ||
| 15 | |
GRP02_EB | CHAR12 | CHAR | 12 | 0 | Session name for subledger accounting | ||
| 16 | |
XKEP2_EB | CHAR1 | CHAR | 1 | 0 | Keep session 2 after processing | ||
| 17 | |
WVDAT_EB | DATUM | DATS | 8 | 0 | Further processing date | ||
| 18 | |
WVTIM_EB | TIMES | TIMS | 6 | 0 | Further processing time | ||
| 19 | |
WVART_EB | CHAR1 | CHAR | 1 | 0 | Further processing type | ||
| 20 | |
HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
| 21 | |
BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
| 22 | |
KTOIH_EB | CHAR35 | CHAR | 35 | 0 | Bank account holder | ||
| 23 | |
KTOSB_EB | CHAR35 | CHAR | 35 | 0 | Special account name | ||
| 24 | |
AZNUM_EB | NUM5 | NUMC | 5 | 0 | Statement number | ||
| 25 | |
AZSNR_EB | NUM3 | NUMC | 3 | 0 | Statement page number | ||
| 26 | |
AZDAT_EB | DATE_EB | DATS | 8 | 0 | Statement Date | ||
| 27 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 28 | |
KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | T004 | |
| 29 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 30 | |
SSTYP_EB | CHAR1 | CHAR | 1 | 0 | Beginning balance type (F=begin balance, M=interim balance) | ||
| 31 | |
SSVOZ_EB | CHAR1 | CHAR | 1 | 0 | Starting balance +/- sign | ||
| 32 | |
SSBTR_EB | WERT9 | CURR | 17 | 2 | Opening balance amount | ||
| 33 | |
SUMSO_EB | WERT9 | CURR | 17 | 2 | Total Debit | ||
| 34 | |
SUMHA_EB | WERT9 | CURR | 17 | 2 | Total Credit | ||
| 35 | |
ESTYP_EB | CHAR1 | CHAR | 1 | 0 | Ending balance type (F=ending balance, M=interim balance) | ||
| 36 | |
ESVOZ_EB | CHAR1 | CHAR | 1 | 0 | Closing balance +/- sign | ||
| 37 | |
ESBTR_EB | WERT9 | CURR | 17 | 2 | Ending balance amount | ||
| 38 | |
ESDMB_EB | WERT9 | CURR | 17 | 2 | Ending balance equivalent in local currency | ||
| 39 | |
BLAUF_EB | DATUM | DATS | 8 | 0 | Life start | ||
| 40 | |
ELAUF_EB | DATUM | DATS | 8 | 0 | Life end | ||
| 41 | |
HZINS_EB | HZINS_EB | DEC | 9 | 3 | Credit interest | ||
| 42 | |
TEILN_EB | CHAR20 | CHAR | 20 | 0 | Customer/vendor EB number | ||
| 43 | |
BKTOA_EB | CHAR23 | CHAR | 23 | 0 | Bank account type | ||
| 44 | |
ANZES_EB | NUM5 | NUMC | 5 | 0 | Number of memo records from the bank statement | ||
| 45 | |
VGTYP_EB | VGTYP_EB | CHAR | 8 | 0 | Transaction type | * | |
| 46 | |
EFART_EB | CHAR1 | CHAR | 1 | 0 | Input Type | ||
| 47 | |
HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
| 48 | |
HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
| 49 | |
EUSER_EB | CHAR12 | CHAR | 12 | 0 | User who fills the bank data buffer | ||
| 50 | |
EDATE_EB | DATUM | DATS | 8 | 0 | Import date into bank data puffer | ||
| 51 | |
ETIME_EB | UZEIT | TIMS | 6 | 0 | Import time into bank data buffer | ||
| 52 | |
BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
| 53 | |
XFDIS_EB | XFELD | CHAR | 1 | 0 | X - cash management payment advice notes were created | ||
| 54 | |
DSART | DSART | CHAR | 2 | 0 | Planning type | * | |
| 55 | |
FFDISXVERD | XFELD | CHAR | 1 | 0 | Summarize bank statement items | ||
| 56 | |
AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
| 57 | |
AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
| 58 | |
SEQ_NUMBER | SEQ_NUMBER | NUMC | 4 | 0 | Bank statement sequential number | ||
| 59 | |
SEQ_STATUS | SEQ_STATUS | CHAR | 1 | 0 | Sequence status | ||
| 60 | |
INPUT_FORMAT | INPUT_FORMAT | CHAR | 2 | 0 | Input format | ||
| 61 | |
SIBAN_EB | IBAN | CHAR | 34 | 0 | Sender Bank Account: IBAN |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | FEBKO | BUKRS | |
|
REF | 1 | CN |
| 2 | FEBKO | HKONT | |
|
REF | 1 | CN |
| 3 | FEBKO | KTOPL | |
|
REF | 1 | CN |
| 4 | FEBKO | MANDT | |
|
KEY | 1 | CN |
| 5 | FEBKO | WAERS | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20040315 |
| SAP Release Created in |