BKPF_ADD SAP table for – Accounting Document Header

Here we would like to draw your attention to BKPF_ADD table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). BKPF_ADD is a SAP standard transp table used for storing Accounting Document Header related data in SAP. It comes under the package FAGL_DB_PERSISTENCY.

SAP BKPF_ADD table

Table BKPF_ADD technical data

TableBKPF_ADD
Data storingAccounting Document Header
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_DB_PERSISTENCY
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP BKPF_ADD Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in BKPF_ADD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AEDAT : Date of the Last Document Change by Transaction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDDT : Date of the Last Document Update
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WWERT : Translation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • TCODE : Transaction Code
    Its data type is CHAR (Character String) with field length 20
  • BVORG : Number of Cross-Company Code Posting Transaction
    Its data type is CHAR (Character String) with field length 16
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • DBBLG : Recurring Entry Document Number
    Its data type is CHAR (Character String) with field length 10
  • STBLG : Reverse Document Number
    Its data type is CHAR (Character String) with field length 10
  • STJAH : Reverse document fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BKTXT : Document Header Text
    Its data type is CHAR (Character String) with field length 25
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KURSF : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • KZWRS : Currency Key for the Group Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KZKRS : Group Currency Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • XNETB : Indicator: Document posted net ?
    Its data type is CHAR (Character String) with field length 1
  • FRATH : Unplanned Delivery Costs
    Its data type is CURR (Currency Field) with field length 13
  • XRUEB : Indicator: Document is posted to a previous period
    Its data type is CHAR (Character String) with field length 1
  • GLVOR : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • GRPID : Batch Input Session Name
    Its data type is CHAR (Character String) with field length 12
  • DOKID : Document Name in the Archive System
    Its data type is CHAR (Character String) with field length 40
  • ARCID : Extract ID Document Header
    Its data type is CHAR (Character String) with field length 10
  • IBLAR : Internal Document Type for Document Control
    Its data type is CHAR (Character String) with field length 2
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY : Object key
    Its data type is CHAR (Character String) with field length 20
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWAE2 : Currency Key of Second Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWAE3 : Currency Key of Third Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KURS2 : Exchange Rate for the Second Local Currency
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • KURS3 : Exchange Rate for the Third Local Currency
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BASW2 : Source Currency for Currency Translation
    Its data type is CHAR (Character String) with field length 1
  • BASW3 : Source Currency for Currency Translation
    Its data type is CHAR (Character String) with field length 1
  • UMRD2 : Translation Date Type for Second Local Currency
    Its data type is CHAR (Character String) with field length 1
  • UMRD3 : Translation Date Type for Third Local Currency
    Its data type is CHAR (Character String) with field length 1
  • XSTOV : Indicator: Document is flagged for reversal
    Its data type is CHAR (Character String) with field length 1
  • STODT : Planned Date for the Reverse Posting
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XMWST : Calculate tax automatically
    Its data type is CHAR (Character String) with field length 1
  • CURT2 : Currency Type of Second Local Currency
    Its data type is CHAR (Character String) with field length 2
  • CURT3 : Currency Type of Third Local Currency
    Its data type is CHAR (Character String) with field length 2
  • KUTY2 : Exchange Rate Type
    Its data type is CHAR (Character String) with field length 4
  • KUTY3 : Exchange Rate Type
    Its data type is CHAR (Character String) with field length 4
  • XSNET : G/L account amounts entered exclude tax
    Its data type is CHAR (Character String) with field length 1
  • AUSBK : Source Company Code
    Its data type is CHAR (Character String) with field length 4
  • XUSVR : Indicator: US taxes changed at detail level ?
    Its data type is CHAR (Character String) with field length 1
  • DUEFL : Status of Data Transfer into Subsequent Release
    Its data type is CHAR (Character String) with field length 1
  • AWSYS : Logical System
    Its data type is CHAR (Character String) with field length 10
  • TXKRS : Exchange Rate for Taxes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • LOTKZ : Lot Number for Requests
    Its data type is CHAR (Character String) with field length 10
  • XWVOF : Indicator: Customer bill of exchange payment before due date
    Its data type is CHAR (Character String) with field length 1
  • STGRD : Reason for Reversal
    Its data type is CHAR (Character String) with field length 2
  • PPNAM : Name of User Who Parked this Document
    Its data type is CHAR (Character String) with field length 12
  • BRNCH : Branch number
    Its data type is CHAR (Character String) with field length 4
  • NUMPG : Number of pages of invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ADISC : Indicator: entry represents a discount document
    Its data type is CHAR (Character String) with field length 1
  • XREF1_HD : Reference Key 1 Internal for Document Header
    Its data type is CHAR (Character String) with field length 20
  • XREF2_HD : Reference Key 2 Internal for Document Header
    Its data type is CHAR (Character String) with field length 20
  • XREVERSAL : Specifies whether doc. is reversal doc. or reversed doc.
    Its data type is CHAR (Character String) with field length 1
  • REINDAT : Invoice Receipt Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2