FEBKO is a standard Basic Functions Transparent Table in SAP Financials application, which stores Electronic Bank Statement Header Records data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for FEBKO. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
FEBKO — Meta Data
Description: | Electronic Bank Statement Header Records |
Main Category: | Financials |
Sub Category: | Basic Functions |
Table type: | Transparent Table (TRANSP) |
FEBKO — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | ANWND | SEPA: Application for Which Mandate Relevant | X | CHAR | 4 | |
3 | ABSND | Sending bank (electronic bank statement) | X | CHAR | 50 | |
4 | AZIDT | Bank statement identification | X | CHAR | 20 | |
5 | EMKEY | Payee Keys | X | CHAR | 20 | |
6 | KUKEY | Short Key (Surrogate) | NUMC | 8 | ||
7 | ASTAT | Statement status | CHAR | 1 | ||
8 | DSTAT | Duty Station | CHAR | 1 | ||
9 | VB1OK | Update 1 OK | CHAR | 1 | ||
10 | VB2OK | 2nd update OK | CHAR | 1 | ||
11 | KIPRE | All items on header record were interpreted | CHAR | 1 | ||
12 | VFDAT | Shelf Life Expiration or Best-Before Date | DATS | 8 | ||
13 | GRP01 | Session name for bank postings | CHAR | 12 | ||
14 | XKEP1 | Keep session 1 after processing | CHAR | 1 | ||
15 | GRP02 | Session name for subledger accounting | CHAR | 12 | ||
16 | XKEP2 | Keep session 2 after processing | CHAR | 1 | ||
17 | WVDAT | Further processing date | DATS | 8 | ||
18 | WVTIM | Further processing time | TIMS | 6 | ||
19 | WVART | Further processing type | CHAR | 1 | ||
20 | HKONT | G/L | CHAR | 10 | SKB1 | |
21 | KTONR | Account number | CHAR | 18 | ||
22 | KTOIH | Bank account holder | CHAR | 35 | ||
23 | KTOSB | Special account name | CHAR | 35 | ||
24 | AZNUM | Statement number | NUMC | 5 | ||
25 | AZSNR | Statement page number | NUMC | 3 | ||
26 | AZDAT | Statement date | DATS | 8 | ||
27 | BUKRS | Company Code | CHAR | 4 | T001 | |
28 | KTOPL | Chart of Accounts | CHAR | 4 | T004 | |
29 | WAERS | Currency | CUKY | 5 | TCURC | |
30 | SSTYP | Subschema Category | CHAR | 1 | ||
31 | SSVOZ | Starting balance +/- sign | CHAR | 1 | ||
32 | SSBTR | Opening balance amount | CURR | 23 | ||
33 | SUMSO | Total debits | CURR | 23 | ||
34 | SUMHA | Total credits | CURR | 23 | ||
35 | ESTYP | Closing balance type (F=closing | CHAR | 1 | ||
36 | ESVOZ | Closing balance +/- sign | CHAR | 1 | ||
37 | ESBTR | Ending balance amount | CURR | 23 | ||
38 | ESDMB | Ending balance equivalent in local currency | CURR | 23 | ||
39 | BLAUF | Period from | DATS | 8 | ||
40 | ELAUF | Period to | DATS | 8 | ||
41 | HZINS | Credit interest | DEC | 9 | ||
42 | TEILN | POR Subscriber Number | CHAR | 20 | ||
43 | BKTOA | Bank account type | CHAR | 23 | ||
44 | ANZES | Number of memo records from the bank statement | NUMC | 5 | ||
45 | VGTYP | Prec.doc.categ. | CHAR | 8 | ||
46 | EFART | Entry type | CHAR | 1 | ||
47 | HBKID | Short key for a house bank | CHAR | 5 | ||
48 | HKTID | ID for Account Details | CHAR | 5 | ||
49 | EUSER | Multi-purpose field for end entry | CHAR | 12 | ||
50 | EDATE | SAP DB: Analysis Date | DATS | 8 | ||
51 | ETIME | TIME Data Element for SYST | TIMS | 6 | ||
52 | BKREF | Reference specifications for bank details | CHAR | 20 | ||
53 | XFDIS | Indicator: Cash Management activated ? | CHAR | 1 | ||
54 | DSART | Planning type | CHAR | 2 | ||
55 | XVERD | Indicator: Group balance decides on allocation | CHAR | 1 | ||
56 | XBENR | Reference Key | CHAR | 20 | ||
57 | XBTYP | Reference Transaction | CHAR | 5 | ||
58 | SEQ_NUMBER | Natural number | NUMC | 4 | ||
59 | SEQ_STATUS | Sequence status | CHAR | 1 | ||
60 | INPUT_FORMAT | Input format | CHAR | 2 | ||
61 | SIBAN | Sender Bank Account: IBAN | CHAR | 34 | ||
62 | AZPGNO | NUMC | 5 | |||
63 | .INCLUDE | 0 | ||||
64 | DUMMY_FEBKO | Dummy function in length 1 | CHAR | 1 |
SAP Help, Wiki Resources, and Forum Discussions on FEBKO
-
Table FEBKO is blocked; key 0001 - SAP Q&A
there were 20 line items which needed to be entered into SAP, from those 20, 19 were successfu, but one stuck.
https://answers.sap.com/thread/840007
-
Resetting entry in FEBKO | SCN
Hello,
Can we RESET entry in FEBKO table? if yes how?
Thanks in advance
http://scn.sap.com/message/4455421
-
Can't see loaded account statement in FEBA only in Tabel FEBKO, what to do?
We are using FEBA for incoming payments. Yesterday when we load the bank statement , AZNUM= 09999 Today AZNUM = 00000 -->
http://scn.sap.com/message/13858757
-
Bank - electronic BAI statement upload & deleting entries from FEBKO
Is the date of the statement you deleted and are trying to re-load before the date of another statement you have loaded? I.e. if the date of the statement you are trying to load is June 1, does a statement exist with a date of June 2 or later? I've had issues in the past loading BAI statements out of date order.
http://scn.sap.com/message/7702490
-
Datasource which contains fields from table FEBKO and FEBEB
I have a requirement to design a BI report which fetches the data from Electronic Bank Statement of ECC..I have found the tables FEBKO and FEBEP having the fields which is suitable for our requirment.But I couldn't find out the relevant datasource which contains those fields.please help me that any ECC datasource which contains fields related to Electronic bank statement.
http://scn.sap.com/message/10213245
-
KUKEY in table FEBKO & FEBEP | SCN
This value is also populated in my FI document in the document header text field. I am new to electronic bank Statement. can anyone throw some light on this please?
http://scn.sap.com/message/8795007
-
Table FEBKO is blocked; key 003 | SCN
We are getting one error message while processing Lock box payment using transaction FLB1 for items un applied.The message saying that Table FEBKO is blocked key 003 071000013 XXXXX XXXXXXX XXXXXX with error message no FB780.
http://scn.sap.com/thread/3207792
-
FEBKO Table | SCN
I have some different requirement, The user don't want to provide access FEBKO in SE16 or SE11 in production.
http://scn.sap.com/message/6731482
-
FINSTA inbound idocs - "Error during insert in table FEBKO"
has anyone come across this type of error, other than this the system is not showing any information. What kind of error during this insert, im unable to find out.
http://scn.sap.com/message/4242397
Related Tables
TABLE | Description | Functional Area |
---|---|---|
FEBEP | Electronic Bank Statement Line Items | Financials - Basic Functions |
FEBRE | Reference record for electronic bank statement line item | Financials - Basic Functions |
FEBVW | Electronic Banking Management Records | Financials - Basic Functions |
FEBCL | Clearing data for an electronic bank statement line item | Financials - Basic Functions |
FEBAN | Transfer Structure: Requisition to Update Program | MM - Purchasing |
AVIP | Payment Advice Line Item | FI - Financial Accounting |
BSEG | Accounting Document Segment | FI - Financial Accounting |
Transaction Codes for SAP Table FEBKO
TCODE | Description | Functional Area |
---|---|---|
FEBA | Postprocess Electronic Bank Statmt | FIN - Basic Functions |
FF67 | Manual Account Statement | Financials - Basic Functions |
FF_5 | Import Electronic Bank Statement | FI - Bank Statement |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
FEBAN | Bank statement postprocessing | FI - Bank Statement |
F110 | Parameters for Automatic Payment | FI - Financial Accounting |
SE38 | ABAP Editor | Basis - ABAP Editor |
FEBP | Post Electronic Bank Statement | FIN - Basic Functions |
FMs for SAP Table FEBKO
FM | Description | Functional Area |
---|---|---|
EXIT_RFEBBU10_001 | Interpret Note to Payee Lines of the Electronic Bank Statement | Financials - Basic Functions |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
BDC_OPEN_GROUP | Open batch input session for adding transactions | 700 - UI Services |
USER_SETTINGS | User settings | Basis - Terminology/Glossary |
BDC_CLOSE_GROUP | Close batch input session | 700 - UI Services |
BDC_INSERT | Insert batch input transactions in batch input session | 700 - UI Services |
ARFC_DEST_SHIP | Transport der ARFC Daten zum Zielrechner, Sichern und Ausf | Basis - RFC |
SWW_WI_CREATE_VIA_EVENT | Create Work Item as Result of Event | Basis - SAP Business Workflow |
ABAP Reports for SAP Table FEBKO
ABAP REPORT | Description | Functional Area |
---|---|---|
RFEBKA96 | Delete Buffer | Financials - Basic Functions |
RFEBKA00 | Bank Statement: Various Formats (SWIFT, MultiCash, BAI...) | Financials - Basic Functions |
RFEBGB00 | Import Bank Statement: Great Britain | Financials - Basic Functions |
SAPMF40K | Manual Bank Statement: Central Module Pool | Financials - Basic Functions |
RFEBBU00 | Update Account Statement/Check Deposit Transaction | Financials - Basic Functions |
RFEBBU10 | Interpret Bank Statement Information | Financials - Basic Functions |
RFEKA400 | Import Format SWIFT MT940 into Bank Data Buffer | Financials - Basic Functions |
SAPLSPO1 | ?... |
Authorization Objects for SAP Table FEBKO
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_PAYR_BUK | Check Management: Action Authorization for Company Codes | |
J_1IRG23D | Authorisation object for Depo Transactions | |
CRM_CATT | Authorization for CRM eCATT Based Unit Testing | |
ECM_REQ | Change Management: Change Request | |
ECM_ORD | Change Management: Change Order | |
J_1IEWT_HC | health check for Migration to EWT | |
ECM_VAL | Change Management: Validity | |
ECM_CTXT | Engineering Change Management: Context |
Most searched SAP Financials Tables
- Currency Tables
- Bank Statement Tables
- Dispute Management Tables
- Treasury Tables
- Fscm Tables
- Cash Management Tables
- Electronic Bank Statement Tables
- Dispute Case Tables
- Collection Management Tables
- Feban Bank Statement Tables
- Dispute Tables
- Fscm Credit Tables
- Ihc Tables
- Bank Reconciliation Statement Tables
- Feba Tables
- Udm Tables
- Ebs Tables
- Feban Ebs Tables
- Client Copy Tables
- Treasury Management Tables
- Fscm Dispute Management Tables
- Backup Tables