queryviz
tables/relationship path
open in builder
T002
SPRAS
T001
BUKRS
BKPF

BKPF

accounting document header
fi29f · 4k · 18r
Merged into ACDOCA
Accounting document header fields are merged into ACDOCA line items. BKPF still exists in S/4HANA for compatibility, but ACDOCA is the primary table for reporting.
key differences:
  • •Header fields (BUKRS, BELNR, GJAHR, BLDAT, BUDAT, etc.) denormalized into each ACDOCA line
  • •BKPF still physically exists but is populated for compatibility only
  • •New reports and CDS views read from ACDOCA, not BKPF
  • •No separate header query needed — all data is on the line item

fields (29)

fieldtypelengthkeydescription
BELNRchar10pkaccounting document number
BUKRSchar4pkcompany code
GJAHRnumc4pkfiscal year
MANDTclnt3pkclient
AWKEYchar20reference key
AWTYPchar5reference transaction
BLARTchar2document type
BLDATdats8document date in document
BSTATchar1document status
BUDATdats8posting date in the document
BVORGchar16number of a cross-company code posting transaction
CPUDTdats8day on which accounting document was entered
CPUTMtims6time of entry
DBBLGchar10recurring entry document number
GRESSION_IDchar4ledger group
HWAERcuky5local currency
KURS2dec9translation rate: second local currency
KURSFdec9exchange rate
KURSTchar4exchange rate type
LDGRPchar4ledger group
MONATnumc2fiscal period
PPNAMchar12name of person who parked the document
PROPMANOchar20property management application number
STBLGchar10reverse document number
STJAHnumc4reverse document fiscal year
TCODEchar20transaction code
USNAMchar12user name
WAERScuky5currency key
XBLNRchar16reference document number

relationships (18)

master lookup

reference to master data

referenced by
ANLP
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
GLPCA
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
1:N
FEBEP
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
T003
BLARTBLART
1:N
EKBE
BELNRBELNR
GJAHRGJAHR
BUKRSBUKRS
N:1
REGUH
BUKRSZBUKR
BELNRVBLNR
GJAHRVJAHR
1:1
PAYR
BUKRSZBUKR
BELNRVBLNR
GJAHRGJAHR
1:1
REGUP
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
VBRK
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
1:1
RBKP
BELNRBELNR
GJAHRGJAHR
BUKRSBUKRS
1:1
configuration

reference to config tables

references
T001
BUKRSBUKRS
N:1
T003
BLARTBLART
N:1
TCURC
WAERSWAERS
N:1
referenced by
TCURR
KURSTKURST
WAERSFCURR
HWAERTCURR
1:N
header / item

parent-child document structure

references
BSEG
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
1:N
referenced by
BSET
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
ACDOCA
BUKRSRBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
FAGLFLEXA
BUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms