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