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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ANWND | ANWND_EBKO | ANWND_EBKO | CHAR | 4 | 0 | Application using bank data storage | ||
3 | ABSND | ABSND_EB | CHAR50 | CHAR | 50 | 0 | Sending bank (electronic bank statement) | ||
4 | AZIDT | AZIDT_EB | CHAR20 | CHAR | 20 | 0 | Bank statement identification | ||
5 | EMKEY | EMKEY_EB | CHAR20 | CHAR | 20 | 0 | Payee Keys | ||
6 | KUKEY | KUKEY_EB | KUKEY_EB | NUMC | 8 | 0 | Short key (surrogate) | ||
7 | ASTAT | ASTAT_EB | CHAR1 | CHAR | 1 | 0 | Statement status | ||
8 | DSTAT | DSTAT_EB | CHAR1 | CHAR | 1 | 0 | Print status | ||
9 | VB1OK | VB1OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 1 are OK | ||
10 | VB2OK | VB2OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 2 are OK | ||
11 | KIPRE | KIPRE_EB | CHAR1 | CHAR | 1 | 0 | All items on header record were interpreted | ||
12 | VFDAT | VFDAT_EB | DATUM | DATS | 8 | 0 | Data expiry date | ||
13 | GRP01 | GRP01_EB | CHAR12 | CHAR | 12 | 0 | Session name for bank postings | ||
14 | XKEP1 | XKEP1_EB | CHAR1 | CHAR | 1 | 0 | Keep session 1 after processing | ||
15 | GRP02 | GRP02_EB | CHAR12 | CHAR | 12 | 0 | Session name for subledger accounting | ||
16 | XKEP2 | XKEP2_EB | CHAR1 | CHAR | 1 | 0 | Keep session 2 after processing | ||
17 | WVDAT | WVDAT_EB | DATUM | DATS | 8 | 0 | Further processing date | ||
18 | WVTIM | WVTIM_EB | TIMES | TIMS | 6 | 0 | Further processing time | ||
19 | WVART | WVART_EB | CHAR1 | CHAR | 1 | 0 | Further processing type | ||
20 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
21 | KTONR | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
22 | KTOIH | KTOIH_EB | CHAR35 | CHAR | 35 | 0 | Bank account holder | ||
23 | KTOSB | KTOSB_EB | CHAR35 | CHAR | 35 | 0 | Special account name | ||
24 | AZNUM | AZNUM_EB | NUM5 | NUMC | 5 | 0 | Statement number | ||
25 | AZSNR | AZSNR_EB | NUM3 | NUMC | 3 | 0 | Statement page number | ||
26 | AZDAT | AZDAT_EB | DATE_EB | DATS | 8 | 0 | Statement Date | ||
27 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
28 | KTOPL | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | T004 | |
29 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
30 | SSTYP | SSTYP_EB | CHAR1 | CHAR | 1 | 0 | Beginning balance type (F=begin balance, M=interim balance) | ||
31 | SSVOZ | SSVOZ_EB | CHAR1 | CHAR | 1 | 0 | Starting balance +/- sign | ||
32 | SSBTR | SSBTR_EB | WERT9 | CURR | 17 | 2 | Opening balance amount | ||
33 | SUMSO | SUMSO_EB | WERT9 | CURR | 17 | 2 | Total Debit | ||
34 | SUMHA | SUMHA_EB | WERT9 | CURR | 17 | 2 | Total Credit | ||
35 | ESTYP | ESTYP_EB | CHAR1 | CHAR | 1 | 0 | Ending balance type (F=ending balance, M=interim balance) | ||
36 | ESVOZ | ESVOZ_EB | CHAR1 | CHAR | 1 | 0 | Closing balance +/- sign | ||
37 | ESBTR | ESBTR_EB | WERT9 | CURR | 17 | 2 | Ending balance amount | ||
38 | ESDMB | ESDMB_EB | WERT9 | CURR | 17 | 2 | Ending balance equivalent in local currency | ||
39 | BLAUF | BLAUF_EB | DATUM | DATS | 8 | 0 | Life start | ||
40 | ELAUF | ELAUF_EB | DATUM | DATS | 8 | 0 | Life end | ||
41 | HZINS | HZINS_EB | HZINS_EB | DEC | 9 | 3 | Credit interest | ||
42 | TEILN | TEILN_EB | CHAR20 | CHAR | 20 | 0 | Customer/vendor EB number | ||
43 | BKTOA | BKTOA_EB | CHAR23 | CHAR | 23 | 0 | Bank account type | ||
44 | ANZES | ANZES_EB | NUM5 | NUMC | 5 | 0 | Number of memo records from the bank statement | ||
45 | VGTYP | VGTYP_EB | VGTYP_EB | CHAR | 8 | 0 | Transaction type | * | |
46 | EFART | EFART_EB | CHAR1 | CHAR | 1 | 0 | Input Type | ||
47 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
48 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
49 | EUSER | EUSER_EB | CHAR12 | CHAR | 12 | 0 | User who fills the bank data buffer | ||
50 | EDATE | EDATE_EB | DATUM | DATS | 8 | 0 | Import date into bank data puffer | ||
51 | ETIME | ETIME_EB | UZEIT | TIMS | 6 | 0 | Import time into bank data buffer | ||
52 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
53 | XFDIS | XFDIS_EB | XFELD | CHAR | 1 | 0 | X - cash management payment advice notes were created | ||
54 | DSART | DSART | DSART | CHAR | 2 | 0 | Planning type | * | |
55 | XVERD | FFDISXVERD | XFELD | CHAR | 1 | 0 | Summarize bank statement items | ||
56 | XBENR | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
57 | XBTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
58 | SEQ_NUMBER | SEQ_NUMBER | SEQ_NUMBER | NUMC | 4 | 0 | Bank statement sequential number | ||
59 | SEQ_STATUS | SEQ_STATUS | SEQ_STATUS | CHAR | 1 | 0 | Sequence status | ||
60 | INPUT_FORMAT | INPUT_FORMAT | INPUT_FORMAT | CHAR | 2 | 0 | Input format | ||
61 | SIBAN | 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 | T001 | BUKRS | REF | 1 | CN |
2 | FEBKO | HKONT | SKB1 | SAKNR | REF | 1 | CN |
3 | FEBKO | KTOPL | T004 | KTOPL | REF | 1 | CN |
4 | FEBKO | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | FEBKO | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20040315 |
SAP Release Created in |