SAP Tables | Financial Accounting(FI) SAP FI

Share |

BKPF SAP Accounting Document Header Table


BKPF is a standard SAP Table which is used to store Accounting Document Header information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table BKPF and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)

==>View Table relationships


Dictionary fields for SAP Table BKPF

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
BUKRSBUKRSCHAR4 T001Company Code
BELNRBELNR_DCHAR10 Accounting Document Number
GJAHRGJAHRNUMC4 Fiscal Year
BLARTBLARTCHAR2 T003Document Type
BLDATBLDATDATS8 Document Date in Document
BUDATBUDATDATS8 Posting Date in the Document
MONATMONATNUMC2 Fiscal Period
CPUDTCPUDTDATS8 Day On Which Accounting Document Was Entered
CPUTMCPUTMTIMS6 Time of Entry
AEDATAEDAT_BKPFDATS8 Date of the Last Document Change by Transaction
UPDDTUPDDTDATS8 Date of the Last Document Update
WWERTWWERT_DDATS8 Translation Date
USNAMUSNAMCHAR12
*
User name
TCODETCODECHAR20
*
Transaction Code
BVORGBVORGCHAR16 Number of Cross-Company Code Posting Transaction
XBLNRXBLNR1CHAR16 Reference Document Number
DBBLGDBBLGCHAR10 Recurring Entry Document Number
STBLGSTBLGCHAR10 Reverse Document Number
STJAHSTJAHNUMC4 Reverse document fiscal year
BKTXTBKTXTCHAR25 Document Header Text
WAERSWAERSCUKY5 TCURCCurrency Key
KURSFKURSFDEC9(5) Exchange rate
KZWRSKZWRSCUKY5 TCURCCurrency Key for the Group Currency
KZKRSKZKRSDEC9(5) Group Currency Exchange Rate
BSTATBSTAT_DCHAR1 Document Status
XNETBXNETBCHAR1 Indicator: Document posted net ?
FRATHFRATHCURR13(2) Unplanned delivery costs
XRUEBXRUEBCHAR1 Indicator: Document is posted to a previous period
GLVORGLVORCHAR4 Business Transaction
GRPIDGRPID_BKPFCHAR12 Batch Input Session Name
DOKIDDOKID_BKPFCHAR40 Document Name in the Archive System
ARCIDEXTID_BKPFCHAR10 Extract ID Document Header
IBLARIBLARCHAR2 Internal Document Type for Document Control
AWTYPAWTYPCHAR5
*
Reference Transaction
AWKEYAWKEYCHAR20 Reference Key
FIKRSFIKRSCHAR4
*
Financial Management Area
HWAERHWAERCUKY5
*
Local Currency
HWAE2HWAE2CUKY5
*
Currency Key of Second Local Currency
HWAE3HWAE3CUKY5
*
Currency Key of Third Local Currency
KURS2KURS2DEC9(5) Exchange Rate for the Second Local Currency
KURS3KURS3DEC9(5) Exchange Rate for the Third Local Currency
BASW2CURSRCHAR1 Source Currency for Currency Translation
BASW3CURSRCHAR1 Source Currency for Currency Translation
UMRD2UMRD2CHAR1 Translation Date Type for Second Local Currency
UMRD3UMRD3CHAR1 Translation Date Type for Third Local Currency
XSTOVXSTOVCHAR1 Indicator: Document is flagged for reversal
STODTSTODTDATS8 Planned Date for the Reverse Posting
XMWSTXMWSTCHAR1 Calculate tax automatically
CURT2CURT2CHAR2 Currency Type of Second Local Currency
CURT3CURT3CHAR2 Currency Type of Third Local Currency
KUTY2KURSTCHAR4 TCURVExchange Rate Type
KUTY3KURSTCHAR4 TCURVExchange Rate Type
XSNETXSNETCHAR1 G/L account amounts entered exclude tax
AUSBKAUSBKCHAR4 T001Source Company Code
XUSVRXUSVR_BKPFCHAR1 Indicator: US taxes changed at detail level ?
DUEFLDUEFL_BKPFCHAR1 Status of Data Transfer into Subsequent Release
AWSYSLOGSYSTEMCHAR10
*
Logical System
TXKRSTXKRS_BKPFDEC9(5) Exchange Rate for Taxes
LOTKZPSO_LOTKZCHAR10 Lot Number for Requests
XWVOFXWVOFCHAR1 Indicator: Customer bill of exchange payment before due date
STGRDSTGRDCHAR2 T041CReason for Reversal
PPNAMPPNAMCHAR12
*
Name of User Who Parked this Document
BRNCHJ_1ABRNCHCHAR4 J_1BBRANCHBranch Number
NUMPGJ_1ANOPGNUMC3 Number of pages of invoice
ADISCJ_1ADISCCHAR1 Indicator: entry represents a discount document
XREF1_HDXREF1_HDCHAR20 Reference Key 1 Internal for Document Header
XREF2_HDXREF2_HDCHAR20 Reference Key 2 Internal for Document Header
XREVERSALXREVERSALCHAR1 Specifies whether doc. is reversal doc. or reversed doc.
REINDATREINDATDATS8 Invoice Receipt Date
RLDNRFAGL_RLDNRCHAR2 T882GLedger in General Ledger Accounting
LDGRPFAGL_LDGRPCHAR4 FAGL_TLDGRPLedger Group
PROPMANORE_MANDATCHAR13 Real Estate Management Mandate
XBLNR_ALTXBLNR_ALTCHAR26 Alternative Reference Number
VATDATEVATDATEDATS8 Tax Reporting Date
DOCCATDOCUMENT_CATEGORYCHAR6 Classification of an FI Document
XSPLITSPLIT_POSTINGCHAR1 FI Document Originates from Split Posting (Indicator)
CASH_ALLOCFAGL_CASH_ALLOCCHAR1 Cash-Relevant Document
FOLLOW_ONFAGL_FOLLOW_ONCHAR1 Follow-on document indicator
XREORGFAGL_R_XDOC_REORGCHAR1 Doc. Contains Open Item that Was Transferred During Reorg.
SUBSETACC_SUBSETCHAR4 Defines subset of components for the FI/CO interface
KURSTKURSTCHAR4 TCURVExchange Rate Type
KURSXGLE_FXR_DTE_RATEX28DEC28(14) Market Data Exchange Rate
KUR2XGLE_FXR_DTE_RATE2X28DEC28(14) Market Data Exchange Rate 2
KUR3XGLE_FXR_DTE_RATE3X28DEC28(14) Market Data Exchange Rate 3
XMCAGLE_DTE_MCA_XMCACHAR1 Document Originates from Multi Currency Accounting
.APPEND/SAPF15/BKPF_APPEND F15 Append BKPF
/SAPF15/STATUS/SAPF15/STATUSCHAR1
.APPENDABKPF_PSO IS-PS: BKPF Append Structure for Payment Requests
.INCLUDEIBKPF_PSO IS-PS: Include Structure BKPF Payment Request Doc.Header
.INCLUDEIVBKPF_PSO IS-PS: Include for Append Parked Payment Request Doc.Header
PSOTYPSOTY_DCHAR2 PSOTPDocument category payment requests
PSOAKPSOAKCHAR10 PSO12Reason
PSOKSPSOKSCHAR10
*
Region
PSOSGPSOSGCHAR1 Reason for reversal - IS-PS requests
PSOFNPSOFNCHAR30 IS-PS: File number
INTFORMFM_INTFORMCHAR4 Interest Formula
INTDATEFM_INTDATEDATS8 Interest Calc. Date
PSOBTPSOBTDATS8 Posting Day
PSOZLPSOZLCHAR1 Actual posting
PSODTAEDATDATS8 Changed On
PSOTMPSOTMTIMS6 Last changed at
.APPENDABKPF_UMB IS-PS: Append Structure for Transfer Transaction FMITPO
FM_UMARTFM_UMARTCHAR1 Type of Payment Transfer
.APPENDBKPF_CARD Credit Card: Append for BKPF
.INCLUDEFCRD_VBKPF Credit Card: Include for Appends for BKPF, VBKPF
CCINSCCINS_30FCHAR4 TCRINPayment cards: Card type
CCNUMCCNUM_30FCHAR25 Payment cards: Card number
.APPENDBKPF_USFED Append structure for US federal government
SSBLKSSBLKCHAR1 Payment Statistical Sampling Block
BATCHLOTKZCHAR10 Lot Number for Documents
SNAMEUNAMECHAR12 User Name
SAMPLEDSAMPLEDCHAR1 Sampled Invoice by Payment Certification
EXCLUDE_FLAGEXCLUDE_FLGCHAR1 PPA Exclude Indicator
BLINDFM_BLINDCHAR1 Budgetary Ledger Indicator
OFFSET_STATUSFMFG_OFFSET_STATUSCHAR2 Treasury Offset Status
OFFSET_REFER_DATFMFG_REFERRED_OFFSET_DATDATS8 Date Record Referred to Treasury
PENRCPENRCCHAR2 Reason for late payment
.APPENDJVBKPF Joint Venture fields
KNUMVKNUMVCHAR10 Number of the document condition


Key field
Non-key field


Relations between BKPF and other tables


PAKET_RRLREC-Remuneration List Recipient
      DOCUMENTS-Documents for Remuneration List Recipient
      DYNSEL-Selektionsdaten
            FOREIGNKEY_SEL-Selection on foreign key
            V_RRLE_REL-Relevant Documents
            V_RRLEE_REL-Relevant External Docs
                  VBRK-Relevant SD Billing Docs
                  BKPF-Relevant AC Document Headers
                        BSEG-Relevant AC Document Lines


MARA-Material Master: General Data
      MBEW-Material Valuation
            MKPF-Header: Material Document
                  MSEG-Document Segment: Material
            BKPF-Accounting Document Header
                  BSEG-Accounting Document Segment


BOSG-Uppermost Hierarchy Segment for BRF
      BKPF-Accounting Document Header
            BSEG-Accounting Document Segment
            BSET-Tax Data Document Segment
            FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
      KNA1-General Data in Customer Master
            KNBK-Customer Master (Bank Details)
            KNB1-Customer Master (Company Code)
                  KNB4-Customer Payment History
                  KNB5-Customer Master (Dunning Data)
                  KNKK-Credit Management Cust. Mstr: Control Area Data
                  KNC1-Customer Master (Transaction Figures)
                  KNC3-Customer Master (Special G/L Transaction Figures)
      LFA1-Vendor Master (General Section)
            LFBK-Vendor Master (Bank Details)
            LFB1-Vendor Master (Company Code)
                  LFB5-Vendor Master (Dunning Data)
                  LFC1-Vendor Master (Transaction Figures)
                  LFC3-Vendor Master (Transaction Figures) Special Ledger
      SKA1-G/L Account Master Record (Chart of Accounts)
            SKB1-G/L Account Master Record (Company Code)
                  SKC1A-G/L Sales Segment Derived from GLDB - Internal
                  SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


BKPF-Accounting Document Header
      BSET-Tax Data Document Segment
      BSEG-Accounting Document Segment
            BSEC-One-Time Account Data Document Segment
            EKKO-Purchasing Document Header
                  EKPO-Purchasing Document Item
                        EKBE-Purchasing Document History


KNA1-General Data in Customer Master
      ADDR1_VAL-Address Data
      KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
      KNKA-Customer Master Credit Management: Central Data
      KNKK-Credit Management Cust. Mstr: Control Area Data
      KNBK-Customer Master (Bank Details)
      KNB1-Customer Master (Company Code)
            KNB4-Customer Payment History
            KNB5-Customer Master (Dunning Data)
            KNC1-Customer Master (Transaction Figures)
            KNC3-Customer Master (Special G/L Transaction Figures)
            BSID-Accounting: Secondary Index for Customers
                  ADMI_FILES-Archive Files
                  BSIDEXT-Secondary Index & Additions Section (bsega)
                  BKPF-Accounting Document Header
                        BSEG-Accounting Document Segment
                              WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                              GSEG-Offsetting Items for B-Segment in Reporting


LFA1-Vendor Master (General Section)
      ADDR1_VAL-Address Data
      LFAS-Vendor Master (General Part EU Tax Number)
      LFBK-Vendor Master (Bank Details)
      LFB1-Vendor Master (Company Code)
            LFB5-Vendor Master (Dunning Data)
            LFC1-Vendor Master (Transaction Figures)
            LFC3-Vendor Master (Transaction Figures) Special Ledger
            BSIK-Accounting: Secondary Index for Vendors
                  ADMI_FILES-Archive Files
                  BSIKEXT-Secondary Index & Additions Section (BSEGA)
                  BKPF-Accounting Document Header
                        BSEG-Accounting Document Segment
                              WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                              GSEG-Offsetting Items for B-Segment in Reporting


SKA1-G/L Account Master Record (Chart of Accounts)
      SKB1-G/L Account Master Record (Company Code)
            SKC1A-G/L Sales Segment Derived from GLDB - Internal
            SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
            FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
            BSIS-Accounting: Secondary Index for G/L Accounts
                  ADMI_FILES-Archive Files
                  BSISEXT-Secondary Index & Additions Section (BSEGA)
                  BKPF-Accounting Document Header
                        BSEG-Accounting Document Segment
                              GSEG-Offsetting Items for B-Segment in Reporting




comments powered by Disqus