BKPF is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting Document Header 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 BKPF. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
BKPF — Meta Data
Description: | Accounting Document Header |
Main Category: | FI |
Sub Category: | Financial Accounting |
Table type: | Transparent Table (TRANSP) |
BKPF — 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 | BUKRS | Company Code | X | CHAR | 4 | T001 |
3 | BELNR | Document Number | X | CHAR | 10 | |
4 | GJAHR | Fiscal Year | X | NUMC | 4 | |
5 | BLART | Document Type | CHAR | 2 | T003 | |
6 | BLDAT | Document Date | DATS | 8 | ||
7 | BUDAT | Posting Date | DATS | 8 | ||
8 | MONAT | Period | NUMC | 2 | ||
9 | CPUDT | Entered on | DATS | 8 | ||
10 | CPUTM | Time of Entry | TIMS | 6 | ||
11 | AEDAT | Changed on | DATS | 8 | ||
12 | UPDDT | Date of the Last Document Update | DATS | 8 | ||
13 | WWERT | Translation date | DATS | 8 | ||
14 | USNAM | User name | CHAR | 12 | ||
15 | TCODE | Screen number or transaction name | CHAR | 20 | ||
16 | BVORG | Number of a Cross-Company Code Posting Transaction | CHAR | 16 | ||
17 | XBLNR | Reference | CHAR | 16 | ||
18 | DBBLG | Recurring Entry Document Number | CHAR | 10 | ||
19 | DBBLG_GJAHR | NUMC | 4 | |||
20 | DBBLG_BUKRS | CHAR | 4 | T001 | ||
21 | STBLG | Reversed with | CHAR | 10 | ||
22 | STJAH | Year | NUMC | 4 | ||
23 | BKTXT | Doc.Header Text | CHAR | 25 | ||
24 | WAERS | Currency | CUKY | 5 | TCURC | |
25 | KURSF | Exchange rate | DEC | 9 | ||
26 | KZWRS | Currency Key for Group Currency | CUKY | 5 | TCURC | |
27 | KZKRS | Group Currency Exchange Rate | DEC | 9 | ||
28 | BSTAT | Doc.status | CHAR | 1 | ||
29 | XNETB | Indicator: Document Posted Net ? | CHAR | 1 | ||
30 | FRATH | Unplanned delivery costs | CURR | 13 | ||
31 | XRUEB | Indicator: Document is Posted to a Previous Period | CHAR | 1 | ||
32 | GLVOR | Business Trans. | CHAR | 4 | ||
33 | GRPID | Application analysis: Analysis | CHAR | 12 | ||
34 | DOKID | Document Name in Archive System | CHAR | 40 | ||
35 | ARCID | Extract ID Document Header | CHAR | 10 | ||
36 | IBLAR | Internal Document Type for Document Control | CHAR | 2 | ||
37 | AWTYP | Ref. Transactn | CHAR | 5 | ||
38 | AWKEY | Reference Key | CHAR | 20 | ||
39 | FIKRS | FM Area | CHAR | 4 | ||
40 | HWAER | Local Currency | CUKY | 5 | ||
41 | HWAE2 | Local curr. 2 | CUKY | 5 | ||
42 | HWAE3 | Local curr. 3 | CUKY | 5 | ||
43 | KURS2 | Exchange Rate for the Second Local Currency | DEC | 9 | ||
44 | KURS3 | Exchange Rate for the Third Local Currency | DEC | 9 | ||
45 | BASW2 | Source Currency for Currency Translation | CHAR | 1 | ||
46 | BASW3 | Source Currency for Currency Translation | CHAR | 1 | ||
47 | UMRD2 | Translation Date Type for Second Local Currency | CHAR | 1 | ||
48 | UMRD3 | Translation Date Type for Third Local Currency | CHAR | 1 | ||
49 | XSTOV | Indicator: Document Is Flagged for Reversal | CHAR | 1 | ||
50 | STODT | Reversal Document Posting Date | DATS | 8 | ||
51 | XMWST | Calculate tax automatically | CHAR | 1 | ||
52 | CURT2 | LC2 curr.type | CHAR | 2 | ||
53 | CURT3 | LC3 curr.type | CHAR | 2 | ||
54 | KUTY2 | Exchange Rate Type | CHAR | 4 | TCURV | |
55 | KUTY3 | Exchange Rate Type | CHAR | 4 | TCURV | |
56 | XSNET | G/L account amounts entered exclude tax | CHAR | 1 | ||
57 | AUSBK | Source Company Code | CHAR | 4 | T001 | |
58 | XUSVR | Value-Added Tax, Use, Sales Tax Entered on Detail Screen | CHAR | 1 | ||
59 | DUEFL | Status of data transfer into subsequent release | CHAR | 1 | ||
60 | AWSYS | Logical System | CHAR | 10 | ||
61 | TXKRS | Exchange Rate for Taxes | DEC | 9 | ||
62 | CTXKRS | Rate for Tax Values in Local Currency (Plants Abroad) | DEC | 9 | ||
63 | LOTKZ | Lot Number for Documents | CHAR | 10 | ||
64 | XWVOF | Indicator: Customer Bill of Exchange Payment Before Due Date | CHAR | 1 | ||
65 | STGRD | Reason for Reversal | CHAR | 2 | T041C | |
66 | PPNAM | Name of User Who Parked this Document | CHAR | 12 | ||
67 | PPDAT | Parking Date of Accounting Document | DATS | 8 | ||
68 | PPTME | Parking Time | TIMS | 6 | ||
69 | PPTCOD | CHAR | 20 | |||
70 | BRNCH | Branch Number | CHAR | 4 | J_1BBRANCH | |
71 | NUMPG | Number of pages of invoice | NUMC | 3 | ||
72 | ADISC | Indicator: entry represents a discount document | CHAR | 1 | ||
73 | XREF1_HD | Reference Key 1 Internal for Document Header | CHAR | 20 | ||
74 | XREF2_HD | Reference Key 2 Internal for Document Header | CHAR | 20 | ||
75 | XREVERSAL | Specifies Whether Doc. Is Reversal Doc. or Reversed Doc. | CHAR | 1 | ||
76 | REINDAT | Invoice Receipt Date | DATS | 8 | ||
77 | RLDNR | Ledger | CHAR | 2 | FINSC_LD_CMP | |
78 | LDGRP | Ledger Group | CHAR | 4 | FAGL_TLDGRP | |
79 | PROPMANO | Real Estate Management Mandate | CHAR | 13 | ||
80 | XBLNR_ALT | Alternative Reference Number | CHAR | 26 | ||
81 | VATDATE | Tax Reporting Date | DATS | 8 | ||
82 | DOCCAT | Classification of an FI Document | CHAR | 6 | ||
83 | XSPLIT | FI Document Originates from Split Posting (Indicator) | CHAR | 1 | ||
84 | CASH_ALLOC | Cash-Relevant Document | CHAR | 1 | ||
85 | FOLLOW_ON | Follow-on document indicator | CHAR | 1 | ||
86 | XREORG | Doc. Contains Open Item that Was Transferred During Reorg. | CHAR | 1 | ||
87 | SUBSET | Defines Subset of Components for FI/CO Interface | CHAR | 4 | ||
88 | KURST | Exch. Rate Type | CHAR | 4 | TCURV | |
89 | KURSX | Market Data Exchange Rate | DEC | 28 | ||
90 | KUR2X | Market Data Exchange Rate 2 | DEC | 28 | ||
91 | KUR3X | Market Data Exchange Rate 3 | DEC | 28 | ||
92 | XMCA | Document Originates from Multi Currency Accounting | CHAR | 1 | ||
93 | RESUBMISSION | Date of Resubmission | DATS | 8 | ||
94 | LOGSYSTEM_SENDER | Logical destination (specified in function call) | CHAR | 10 | ||
95 | BUKRS_SENDER | Company Code | CHAR | 4 | ||
96 | BELNR_SENDER | Accounting Document Number | CHAR | 10 | ||
97 | GJAHR_SENDER | Fiscal Year of Document in Sender System | NUMC | 4 | ||
98 | INTSUBID | NUMC | 6 | |||
99 | AWORG_REV | Reversal: Reverse Document Reference Organization | CHAR | 10 | ||
100 | AWREF_REV | Reversal: Reverse Document Reference Document Number | CHAR | 10 | ||
101 | XREVERSING | Identifier for reversal document | CHAR | 1 | ||
102 | XREVERSED | Indicator: Document was reversed | CHAR | 1 | ||
103 | GLBTGRP | CHAR | 1 | |||
104 | CO_VRGNG | CO Business Transaction | CHAR | 4 | ||
105 | CO_REFBT | Document type of reference document | CHAR | 1 | ||
106 | CO_ALEBN | For ALE: CO Document Number in Generating System | CHAR | 10 | ||
107 | CO_VALDT | Special Valuation Date for Cost Accounting | DATS | 8 | ||
108 | CO_BELNR_SENDER | CHAR | 10 | |||
109 | KOKRS_SENDER | CHAR | 4 | |||
110 | ACC_PRINCIPLE | Accounting Principle | CHAR | 4 | ||
111 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
112 | .INCLU-_PN | 0 | ||||
113 | TRAVA_PN | Transfer variant for intercompany asset transfers | CHAR | 4 | * | |
114 | LDGRPSPEC_PN | CHAR | 1 | |||
115 | AFABESPEC_PN | CHAR | 1 | |||
116 | XSECONDARY | CHAR | 1 | |||
117 | REPROCESSING_STATUS_CODE | CHAR | 1 | |||
118 | TRR_PARTIAL_IND | CHAR | 1 | |||
119 | ITEM_REMOVAL_STATUS | CHAR | 1 | |||
120 | PENRC | Reason for Late Payment | CHAR | 2 | ||
121 | .INCLU--AP | 0 | ||||
122 | ANXTYPE | CHAR | 1 | |||
123 | ANXAMNT | CURR | 13 | |||
124 | ANXPERC | DEC | 6 | |||
125 | ZVAT_INDC | DATS | 8 | |||
126 | .INCLU--AP | 0 | ||||
127 | /SAPF15/STATUS | Document Status | CHAR | 1 | ||
128 | .INCLU--AP | 0 | ||||
129 | .INCLUDE | 0 | ||||
130 | .INCLUDE | 0 | ||||
131 | PSOTY | Document category payment requests | CHAR | 2 | PSOTP | |
132 | PSOAK | Reason | CHAR | 10 | PSO12 | |
133 | PSOKS | Region | CHAR | 10 | * | |
134 | PSOSG | Reason for reversal - IS-PS requests | CHAR | 1 | ||
135 | PSOFN | IS-PS: File number | CHAR | 30 | ||
136 | INTFORM | Interest Formula | CHAR | 4 | ||
137 | INTDATE | Interest Calc. Date | DATS | 8 | ||
138 | PSOBT | Posting Day | DATS | 8 | ||
139 | PSOZL | Checkbox | CHAR | 1 | ||
140 | PSODT | Date of Last Change | DATS | 8 | ||
141 | PSOTM | Last changed at | TIMS | 6 | ||
142 | .INCLU--AP | 0 | ||||
143 | FM_UMART | Type of Payment Transfer | CHAR | 1 | ||
144 | .INCLU--AP | 0 | ||||
145 | .INCLUDE | 0 | ||||
146 | CCINS | Payment cards: Card type | CHAR | 4 | TCRIN | |
147 | CCNUM | Payment cards: Card number | CHAR | 25 | ||
148 | .INCLU--AP | 0 | ||||
149 | SSBLK | Payment Statistical Sampling Block | CHAR | 1 | ||
150 | BATCH | Batch Number | CHAR | 10 | ||
151 | SNAME | Software Name | CHAR | 12 | ||
152 | SAMPLED | Sampled Invoice by Payment Certification | CHAR | 1 | ||
153 | EXCLUDE_FLAG | PPA Exclude Indicator | CHAR | 1 | ||
154 | BLIND | Block | CHAR | 1 | ||
155 | OFFSET_STATUS | Treasury Offset Status | CHAR | 2 | ||
156 | OFFSET_REFER_DAT | Date Record Referred to Treasury | DATS | 8 | ||
157 | .INCLU--AP | 0 | ||||
158 | KNUMV | Number of the document condition | CHAR | 10 | ||
159 | .INCLU--AP | 0 | ||||
160 | OINETNUM | Exchange - netting document number | CHAR | 10 | ||
161 | OINJAHR | Fiscal Year | NUMC | 4 | ||
162 | OININD | Movement-based netting indicator | CHAR | 1 | ||
163 | RECHN | Indicator: post invoice | CHAR | 1 | ||
164 | .INCLU--AP | 0 | ||||
165 | BLO | Natural number | CHAR | 1 | ||
166 | CNT | DB6-DBH: Index Number | CHAR | 10 | ||
167 | .INCLU--AP | 0 | ||||
168 | .INCLUDE | 0 | ||||
169 | PYBASTYP | Type of Payment Basis Document | CHAR | 2 | ||
170 | PYBASNO | Payment Basis Document Number | CHAR | 16 | ||
171 | PYBASDAT | Payment Basis Document Date | DATS | 8 | ||
172 | PYIBAN | IBAN (International Bank Account Number) | CHAR | 34 | ||
173 | .INCLUDE | 0 | ||||
174 | INWARDNO_HD | Incoming Document Number | CHAR | 30 | ||
175 | INWARDDT_HD | Incoming Document Date | DATS | 8 |
SAP Help, Wiki Resources, and Forum Discussions on BKPF
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Changelog on BKPF customer field | SCN
The flag for change document in the data element it only means the field (assigned to that data element) is available to be managed by change documents tool, but it doesn't mean the system inserts all the modification automatically every time you update BKPF.
http://scn.sap.com/message/2483683
-
Performance issues with BKPF and BSET. | SCN
I am doing select statement from two tables BKPF and BSET ,both the tables are taking too much time. Following is the query.
http://scn.sap.com/message/10575308
-
FB60 Transaction, BKPF object | SCN
Do you know what is the neccesary configuration in FI in order to get the events from object BKPF triggered in transaction FB60??
http://scn.sap.com/message/1212143
-
How to solve the performance issue of FI report using BSEG and BKPF query ?
Even i have used the BSEG and BKPF table for getting FI related data and PPDIX, PPOIX, PPDHD used for getting HR related data.
http://scn.sap.com/message/13521601
-
Is it not possible to join BKPF & bseg | SCN
i want to join the table BKPF & bseg in select statement.it is telling pooled cluster table can't join?.
http://scn.sap.com/message/1303405
-
Fectching data in a optimised way from BKPF and BSEG.
i have a requirement of picking up all the documents from BKPF and BSEG based on a creation date modification date dunning date clearing date.
http://scn.sap.com/message/13655242
-
User name in BKPF table should be approver's name instead of WF-BATCH.
I have created the task as you said and now I am able to see the approver's name in BKPF table, but now the following new challenges came up:
http://scn.sap.com/message/10826274
-
Select data from BKPF for a date range | SCN
HI SB,
Create Indexes and select the data ...
i.e,
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
" Selection Criteria
<b>SELECT-OPTIONS : S_DATE FOR BKPF-BLDAT OBLIGATORY.</b>
SELECTION-SCREEN : END OF BLOCK B1.
<b> SELECT * FROM BKPF WHERE BLDAT IN s_date.</b>
Regards,
Santosh P
...http://scn.sap.com/message/1365670
-
Is it worth creating secondary index on BKPF table ?
One of my clients is using ECC version 5.0. I have a requirement wherein I need to fetch the data from BKPF table based on AWKEY, BUKRS and GJAHR. There is no standard secondary index available.
http://scn.sap.com/message/10731509
-
Archieve data issue - BKPF | SCN
My Z report is picking records from BKPF table and showing in ALV display. There are some document numbers which are archieved and Z report is not picking those. Client has requirement to show archieved records also.
http://scn.sap.com/message/10135114
-
Selecting entries from BKPF/BSEG - Toolbox for IT Groups
Hello, Does anybody know how to make the following statements run quicker or please suggest a better time effective method of achieving the same result.
http://sap.ittoolbox.com/groups/technical-functional/sap-dev/selecting-entries-from-bkpfbseg-222503
Related Tables
TABLE | Description | Functional Area |
---|---|---|
BSEG | Accounting Document Segment | FI - Financial Accounting |
BSID | Accounting: Secondary Index for Customers | FI - Financial Accounting |
BSIS | Accounting: Secondary Index for G/L Accounts | FI - Financial Accounting |
BSAD | Accounting: Secondary Index for Customers (Cleared Items) | FI - Financial Accounting |
BSIK | Accounting: Secondary Index for Vendors | FI - Financial Accounting |
BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | FI - Financial Accounting |
KNA1 | General Data in Customer Master | Logistics - Customer Master |
Transaction Codes for SAP Table BKPF
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
MIRO | Enter Incoming Invoice | MM - Invoice Verification |
FB03 | Display Document | FI - Financial Accounting |
FB01 | Post Document | FI - Financial Accounting |
FB60 | Enter Incoming Invoices | FI - Financial Accounting |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
FBL1N | Vendor Line Items | FI - Information System |
F110 | Parameters for Automatic Payment | FI - Financial Accounting |
FMs for SAP Table BKPF
FM | Description | Functional Area |
---|---|---|
BAPI_ACC_DOCUMENT_POST | Accounting: Posting | Accounting - Accounting Interface |
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
BAPI_TRANSACTION_COMMIT | Execute external Commit when using BAPIs | Basis - ALE Integration Technology |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
BAPI_ACC_GL_POSTING_POST | Accounting: General G/L Account Posting | Accounting - Accounting Interface |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
ABAP Reports for SAP Table BKPF
ABAP REPORT | Description | Functional Area |
---|---|---|
RFBIBL00 | Batch Input Documents | FI - Financial Accounting |
BWOM2_TIMEST | BWOM2_TIMEST: Time-stamp Maintenance | CO - Information System, iViews |
RGUGBR00 | Generates ABAP Coding for Validations/Substitutions/Rules | FI - Validation, Substitution and Rules |
RGGBS000 | Exit Routines for Substitutions | FI - Validation, Substitution and Rules |
RSAP0001 | Program for object type SAP0001 : BapiService | Basis - BW Service API |
RGGBR000 | Exit Routines for Rules | FI - Validation, Substitution and Rules |
RFPOSXEXTEND | Correction: Change/Activate RFPOSXEXT | FI - Information System |
BDCRECX1 | Include f | Basis - UI Services, Screen, Batch Input |
BW Datasources for SAP Table BKPF
BW DATASOURCE | Description | Functional Area |
---|---|---|
0FI_GL_4 | General Ledger: Line Items with Delta Extraction | FI - General Ledger Accounting |
0FI_AR_4 | Customers: Line Items with Delta Extraction | FI - Accounts Receivable |
0FI_AP_4 | Vendors: Line Items with Delta Extrcation | FI - Accounts Payable |
2LIS_02_ITM | Purchasing Data (Item Level) | MM - Materials Management |
2LIS_03_BF | Goods Movements From Inventory Management | MM - Materials Management |
0FI_GL_10 | General Ledger: Leading Ledger Balances | FI - General Ledger Accounting |
0FI_TX_4 | Taxes: Line Items by Means of Delta Extraction | FI - General Ledger Accounting |
0FI_AP_3 | Vendors: Line Items | FI - Accounts Payable |
Authorization Objects for SAP Table BKPF
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_BKPF_BUK | Accounting Document: Authorization for Company Codes | |
I_TCODE | PM: Transaction Code | |
F_BKPF_BUP | Accounting Document: Authorization for Posting Periods | |
F_BKPF_KOA | Accounting Document: Authorization for Account Types | |
S_TCODE | Transaction Code Check at Transaction Start | |
F_BKPF_BLA | Accounting Document: Authorization for Document Types | |
F_FAGL_LDR | General Ledger: Authorization for Ledger | |
F_BKPF_BES | Accounting Document: Account Authorization for G/L Accounts |
Most searched SAP Financial Accounting Tables
- Vendor Master Tables
- Customer Master Tables
- Company Codes Tables
- Tax Code Tables
- Gl Account Tables
- Gl Account Master Tables
- Bank Account Tables
- Withholding Tax Tables
- Payment Term Tables
- Region Tables
- Bank Details Tables
- Company Code Tables
- Payment Method Tables
- Asset Tables
- Transaction Type Tables
- Tax Jurisdiction Tables
- Customer Tables
- Vendor Tables
- Business Area Tables
- Payment Tables
- Plant Company Code Tables
- Account Assignment Tables