SE11 ABAP Dictionary SE11 EKBE

Popular:

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

EKBE

History per Purchasing Document

SAP MM Transparent Table 74 Fields

Primary Key:

MANDT EBELN EBELP ZEKKN VGABE GJAHR BELNR BUZEI

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	EBELN	KEY	Purch.Doc.	CHAR	10	-	EKKO	Purchasing Document Number
3	EBELP	KEY	Item	NUMC	5	-	-	Item Number of Purchasing Document
4	ZEKKN	KEY	SqNoAccAss	NUMC	2	-	-	Sequential Number of Account Assignment
5	VGABE	KEY	Transact.	CHAR	1	-	-	Transaction/event type, purchase order history
6	GJAHR	KEY	Mat. Year	NUMC	4	-	-	Material Document Year
7	BELNR	KEY	Mat. Doc.	CHAR	10	-	-	Number of Material Document
8	BUZEI	KEY	Item	NUMC	4	-	-	Item in Material Document
9	BEWTP	-	Hist. cat.	CHAR	1	-	-	PO history category
10	BWART	-	Mvmt Type	CHAR	3	-	-	Movement Type (Inventory Management)
11	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
12	MENGE	-	Quantity	QUAN	13	3	-	Quantity
13	BPMNG	-	Qty. OPUn	QUAN	13	3	-	Quantity in purchase order price unit
14	DMBTR	-	Amount LC	CURR	13	2	-	Amount in Local Currency
15	WRBTR	-	Amount	CURR	13	2	-	Amount in document currency
16	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
17	AREWR	-	GR/IR clr.	CURR	13	2	-	GR/IR account clearing value in local currency
18	WESBS	-	GR Bl. OUn	QUAN	13	3	-	Goods Receipt Blocked Stock in Order Unit
19	BPWES	-	GR blocked	QUAN	13	3	-	Quantity in GR blocked stock in order price unit
20	SHKZG	-	D/C indic.	CHAR	1	-	-	Debit/Credit Indicator
21	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
22	ELIKZ	-	Del. Cmpl.	CHAR	1	-	-	"Delivery Completed" Indicator
23	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
24	LFGJA	-	FiscYrRefD	NUMC	4	-	-	Fiscal Year of a Reference Document
25	LFBNR	-	Ref. Doc.	CHAR	10	-	-	Document No. of a Reference Document
26	LFPOS	-	Item	NUMC	4	-	-	Item of a Reference Document
27	GRUND	-	Reason	NUMC	4	-	-	Reason for Movement
28	CPUDT	-	Entered	DATS	8	-	-	Day On Which Accounting Document Was Entered
29	CPUTM	-	Time	TIMS	6	-	-	Time of Entry
30	REEWR	-	Inv. Value	CURR	13	2	-	Invoice Value Entered (in Local Currency)
31	EVERE	-	Compliance	CHAR	2	-	-	Compliance with Shipping Instructions
32	REFWR	-	Inv. value	CURR	13	2	-	Invoice value in foreign currency
33	MATNR	-	Material	CHAR	18	-	MARA	Material Number
34	WERKS	-	Plant	CHAR	4	-	T001W	Plant
35	XWSBR	-	RevGR IR	CHAR	1	-	-	Reversal of GR allowed for GR-based IV despite invoice
36	ETENS	-	Seq. No.	NUMC	4	-	-	Sequential Number of Vendor Confirmation
37	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition
38	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
39	LSMNG	-	DN Qty	QUAN	13	3	-	Quantity in Unit of Measure from Delivery Note
40	LSMEH	-	Del.NoteUn	UNIT	3	-	-	Unit of Measure From Delivery Note
41	EMATN	-	Material	CHAR	18	-	-	Material Number
42	AREWW	-	GR/IR clr.	CURR	13	2	-	Clearing value on GR/IR clearing account (transac. currency)
43	HSWAE	-	Local cur.	CUKY	5	-	-	Local currency key
44	BAMNG	-	Quantity	QUAN	13	3	-	Quantity
45	CHARG	-	Batch	CHAR	10	-	-	Batch Number
46	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
47	XWOFF	-	Value open	CHAR	1	-	-	Calculation of val. open
48	XUNPL	-	UAcctAss.	CHAR	1	-	-	Unplanned Account Assignment from Invoice Verification
49	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
50	SRVPOS	-	Service	CHAR	18	-	-	Service number
51	PACKNO	-	Number	NUMC	10	-	-	Package Number of Service
52	INTROW	-	Line	NUMC	10	-	-	Line Number of Service
53	BEKKN	-	SeqNo.POAA	NUMC	2	-	-	Number of PO Account Assignment
54	LEMIN	-	SrvRet	CHAR	1	-	-	Returns Indicator
55	AREWB	-	GR/IR clr.	CURR	13	2	-	Clearing Value on GR/IR Account in PO Currency
56	REWRB	-	FC amount	CURR	13	2	-	Invoice Amount in PO Currency
57	SAPRL	-	Release	CHAR	4	-	-	SAP Release
58	MENGE_POP	-	Quantity	QUAN	13	3	-	Quantity
59	BPMNG_POP	-	Qty. OPUn	QUAN	13	3	-	Quantity in purchase order price unit
60	DMBTR_POP	-	Amount LC	CURR	13	2	-	Amount in Local Currency
61	WRBTR_POP	-	Amount	CURR	13	2	-	Amount in document currency
62	WESBB	-	Val.BS OUn	QUAN	13	3	-	Valuated Goods Receipt Blocked Stock in Order Unit
63	BPWEB	-	Val. GR BS	QUAN	13	3	-	Quantity in Valuated GR Blocked Stock in Order Price Unit
64	WEORA	-	Orig. Acc.	CHAR	1	-	-	Acceptance At Origin
65	AREWR_POP	-	GR/IR clr.	CURR	13	2	-	GR/IR account clearing value in local currency
66	KUDIF	-	E/R Diff.	CURR	13	2	-	Exchange Rate Difference Amount
67	RETAMT_FC	-	Retention	CURR	13	2	-	Retention Amount in Document Currency
68	RETAMT_LC	-	Retention	CURR	13	2	-	Retention Amount in Company Code Currency
69	RETAMTP_FC	-	Retention	CURR	13	2	-	Posted Retention Amount in Document Currency
70	RETAMTP_LC	-	Retention	CURR	13	2	-	Posted Security Retention Amount in Company Code Currency
71	XMACC	-	Multi AA	CHAR	1	-	-	Multiple Account Assignment
72	WKURS	-	Exch. Rate	DEC	9	5	-	Exchange Rate
73	ET_UPD	-	SU	CHAR	1	-	-	Procedure for Updating the Schedule Line Quantity
74	J_SC_DIE_COMP_F	-	Comp flag	CHAR	1	-	-	Depreciation completion flag

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Goods Receipt Relation → SAP Procurement & MM Document Flow - MIRO Service PO Clearing →

Standard T-Codes

SE11 SE16

Related Tables

EKKO TCURC MARA T001W MKPF MSEG MVER S031

ANSI SQL Query

SELECT a.EBELN,
       a.EBELP,
       a.ZEKKN,
       a.VGABE,
       a.GJAHR,
       a.BELNR,
       a.BUZEI
FROM EKBE AS a
WHERE a.EBELN = '4500017291'
  AND a.EBELP = '0001';

ABAP OpenSQL (7.40+)

SELECT a~ebeln,
       a~ebelp,
       a~zekkn,
       a~vgabe,
       a~gjahr,
       a~belnr,
       a~buzei
  FROM ekbe AS a
  WHERE a~ebeln = '4500017291'
  and a~ebelp = '0001'
  INTO TABLE @DATA(lt_ekbe)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 EKBE

EKBE

Dictionary Fields Fields

Related References & SQL