SE11 ABAP Dictionary SE11 BKPF

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

BKPF

Accounting Document Header

SAP FI Transparent Table 99 Fields

Primary Key:

MANDT BUKRS BELNR GJAHR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	BUKRS	KEY	CoCode	CHAR	4	-	T001	Company Code
3	BELNR	KEY	DocumentNo	CHAR	10	-	-	Accounting Document Number
4	GJAHR	KEY	Fiscal Yr	NUMC	4	-	-	Fiscal Year
5	BLART	-	Type	CHAR	2	-	-	Document Type
6	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
7	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
8	MONAT	-	Period	NUMC	2	-	-	Fiscal Period
9	CPUDT	-	Entered	DATS	8	-	-	Day On Which Accounting Document Was Entered
10	CPUTM	-	Time	TIMS	6	-	-	Time of Entry
11	AEDAT	-	Changed	DATS	8	-	-	Date of the Last Document Change by Transaction
12	UPDDT	-	Last updte	DATS	8	-	-	Date of the Last Document Update
13	WWERT	-	TranslDate	DATS	8	-	-	Translation Date
14	USNAM	-	User	CHAR	12	-	-	User Name
15	TCODE	-	TCode	CHAR	20	-	-	Transaction Code
16	BVORG	-	Crss-CC no	CHAR	16	-	-	Number of Cross-Company Code Posting Transaction
17	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
18	DBBLG	-	RecEnt doc	CHAR	10	-	-	Recurring Entry Document Number
19	STBLG	-	Reversal	CHAR	10	-	-	Reverse Document Number
20	STJAH	-	Year	NUMC	4	-	-	Reverse document fiscal year
21	BKTXT	-	HeaderText	CHAR	25	-	-	Document Header Text
22	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
23	KURSF	-	Exch.rate	DEC	9	5	-	Exchange rate
24	KZWRS	-	Currency Key for the Group Currency	CUKY	5	-	-	Currency Key for the Group Currency
25	KZKRS	-	Group Currency Exchange Rate	DEC	9	5	-	Group Currency Exchange Rate
26	BSTAT	-	Status	CHAR	1	-	-	Document Status
27	XNETB	-	Indicator: Document posted net ?	CHAR	1	-	-	Indicator: Document posted net ?
28	FRATH	-	Un.del.cts	CURR	13	2	-	Unplanned delivery costs
29	XRUEB	-	Back-post?	CHAR	1	-	-	Indicator: Document is posted to a previous period
30	GLVOR	-	Transactn	CHAR	4	-	-	Business Transaction
31	GRPID	-	Sess. Name	CHAR	12	-	-	Batch Input Session Name
32	DOKID	-	Document Name in the Archive System	CHAR	40	-	-	Document Name in the Archive System
33	ARCID	-	ExtractID	CHAR	10	-	-	Extract ID Document Header
34	IBLAR	-	Internal Document Type for Document Control	CHAR	2	-	-	Internal Document Type for Document Control
35	AWTYP	-	Ref. Tran.	CHAR	5	-	-	Reference Transaction
36	AWKEY	-	Ref. Key	CHAR	20	-	-	Reference Key
37	FIKRS	-	FM area	CHAR	4	-	-	Financial Management Area
38	HWAER	-	Local Cur.	CUKY	5	-	-	Local Currency
39	HWAE2	-	Loc.curr2	CUKY	5	-	-	Currency Key of Second Local Currency
40	HWAE3	-	Loc.curr3	CUKY	5	-	-	Currency Key of Third Local Currency
41	KURS2	-	Ex.rate 2	DEC	9	5	-	Exchange Rate for the Second Local Currency
42	KURS3	-	Ex.rate 3	DEC	9	5	-	Exchange Rate for the Third Local Currency
43	BASW2	-	Srce curr.	CHAR	1	-	-	Source Currency for Currency Translation
44	BASW3	-	Srce curr.	CHAR	1	-	-	Source Currency for Currency Translation
45	UMRD2	-	Tr.date	CHAR	1	-	-	Translation Date Type for Second Local Currency
46	UMRD3	-	Tr.date	CHAR	1	-	-	Translation Date Type for Third Local Currency
47	XSTOV	-	Indicator: Document is flagged for reversal	CHAR	1	-	-	Indicator: Document is flagged for reversal
48	STODT	-	Revers.Dte	DATS	8	-	-	Planned Date for the Reverse Posting
49	XMWST	-	Calc.tax	CHAR	1	-	-	Calculate tax automatically
50	CURT2	-	Curr.type	CHAR	2	-	-	Currency Type of Second Local Currency
51	CURT3	-	Curr.type	CHAR	2	-	-	Currency Type of Third Local Currency
52	KUTY2	-	ExRateType	CHAR	4	-	-	Exchange Rate Type
53	KUTY3	-	ExRateType	CHAR	4	-	-	Exchange Rate Type
54	XSNET	-	Net entry	CHAR	1	-	-	G/L account amounts entered exclude tax
55	AUSBK	-	Srce CoCde	CHAR	4	-	-	Source Company Code
56	XUSVR	-	Tax detail	CHAR	1	-	-	Indicator: US taxes changed at detail level ?
57	DUEFL	-	Status	CHAR	1	-	-	Status of Data Transfer into Subsequent Release
58	AWSYS	-	Log.System	CHAR	10	-	-	Logical System
59	TXKRS	-	Rte txs	DEC	9	5	-	Exchange Rate for Taxes
60	LOTKZ	-	Request No	CHAR	10	-	-	Lot Number for Requests
61	XWVOF	-	Indicator: Customer bill of exchange payment before due date	CHAR	1	-	-	Indicator: Customer bill of exchange payment before due date
62	STGRD	-	Reason	CHAR	2	-	-	Reason for Reversal
63	PPNAM	-	Parked by	CHAR	12	-	-	Name of User Who Parked this Document
64	BRNCH	-	Branch no.	CHAR	4	-	-	Branch Number
65	NUMPG	-	Pages	NUMC	3	-	-	Number of pages of invoice
66	ADISC	-	disc. doc.	CHAR	1	-	-	Indicator: entry represents a discount document
67	XREF1_HD	-	Ref.key 1	CHAR	20	-	-	Reference Key 1 Internal for Document Header
68	XREF2_HD	-	Ref.key 2	CHAR	20	-	-	Reference Key 2 Internal for Document Header
69	XREVERSAL	-	Reversal	CHAR	1	-	-	Specifies whether doc. is reversal doc. or reversed doc.
70	REINDAT	-	IR date	DATS	8	-	-	Invoice Receipt Date
71	RLDNR	-	Ledger	CHAR	2	-	-	Ledger in General Ledger Accounting
72	LDGRP	-	Ledger Grp	CHAR	4	-	-	Ledger Group
73	PROPMANO	-	Mandate	CHAR	13	-	-	Real Estate Management Mandate
74	XBLNR_ALT	-	Alt Refer	CHAR	26	-	-	Alternative Reference Number
75	VATDATE	-	Rep. Date	DATS	8	-	-	Tax Reporting Date
76	PSOTY	-	Rqst type	CHAR	2	-	-	Document category payment requests
77	PSOAK	-	Reason	CHAR	10	-	-	Reason
78	PSOKS	-	Region	CHAR	10	-	-	Region
79	PSOSG	-	Rev.reas.	CHAR	1	-	-	Reason for reversal - IS-PS requests
80	PSOFN	-	File no.	CHAR	30	-	-	IS-PS: File number
81	INTFORM	-	Int.form.	CHAR	4	-	-	Interest Formula
82	INTDATE	-	Int.rt.dte	DATS	8	-	-	Interest Calc. Date
83	PSOBT	-	Postng Day	DATS	8	-	-	Posting Day
84	PSOZL	-	Actual	CHAR	1	-	-	Actual posting
85	PSODT	-	Chngd	DATS	8	-	-	Changed On
86	PSOTM	-	Time	TIMS	6	-	-	Last changed at
87	FM_UMART	-	A	CHAR	1	-	-	Type of Payment Transfer
88	CCINS	-	Card type	CHAR	4	-	-	Payment cards: Card type
89	CCNUM	-	Card no.	CHAR	25	-	-	Payment cards: Card number
90	SSBLK	-	Block	CHAR	1	-	-	Payment Statistical Sampling Block
91	BATCH	-	Lot	CHAR	10	-	-	Lot Number for Documents
92	SNAME	-	User	CHAR	12	-	-	User Name
93	SAMPLED	-	Sampled	CHAR	1	-	-	Sampled Invoice by Payment Certification
94	EXCLUDE_FLAG	-	PPA Excl.	CHAR	1	-	-	PPA Exclude Indicator
95	BLIND	-	BL Ind.	CHAR	1	-	-	Budgetary Ledger Indicator
96	OFFSET_STATUS	-	OffsetStat	CHAR	2	-	-	Treasury Offset Status
97	OFFSET_REFER_DAT	-	Refer.Date	DATS	8	-	-	Date Record Referred to Treasury
98	PENRC	-	Reason	CHAR	2	-	-	Reason for late payment
99	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition

Foreign Keys & Joins

BSEG → 1 : N

              BKPF-BUKRS = BSEG-BUKRS AND BKPF-BELNR = BSEG-BELNR AND BKPF-GJAHR = BSEG-GJAHR            

BVOR → N : 1

              BKPF-BUKRS = BVOR-BUKRS AND BKPF-BELNR = BVOR-BELNR            

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk BKPF.

Interactive ERD Diagrams

SAP Finance - FI/CO Document Tables →

Standard T-Codes

FB03 FB01 FB50 FBL3N FB08

Related Tables

BSEG BVOR T001 TCURC BSAD BSID BSIK BSAK

ANSI SQL Query

SELECT a.BUKRS,
       a.BELNR,
       a.GJAHR,
       a.BLART,
       a.BLDAT,
       a.BUDAT,
       a.MONAT
FROM BKPF AS a
LEFT JOIN BSEG AS b
  ON b.MANDT = a.MANDT
 AND b.BUKRS = a.BUKRS
WHERE a.BUKRS = '1000'
  AND a.BELNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~bukrs,
       a~belnr,
       a~gjahr,
       a~blart,
       a~bldat,
       a~budat,
       a~monat
  FROM bkpf AS a
  LEFT OUTER JOIN bseg AS b
    ON b~BUKRS = a~BUKRS
  WHERE a~bukrs = '1000'
  and a~belnr = '0001'
  INTO TABLE @DATA(lt_bkpf)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 BKPF

BKPF

Dictionary Fields Fields

Foreign Keys & Joins

Related References & SQL