SAP ABAP Table EKBE (History per Purchasing Document)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EKBE	Table Relationship Diagram
Short Description	History per Purchasing Document

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	ZEKKN	☑	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
5	VGABE	☑	VGABE	VGABE	CHAR	1	0	Transaction/event type, purchase order history
6	GJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
7	BELNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
8	BUZEI	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
9	.INCLUDE	☐				0	0	History per Purchasing Document
10	BEWTP	☐	BEWTP	BEWTP	CHAR	1	0	Purchase Order History Category	T163B
11	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
12	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
14	BPMNG	☐	MENGE_BPR	MENG13	QUAN	13	3	Quantity in purchase order price unit
15	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
16	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
17	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	AREWR	☐	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
19	WESBS	☐	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
20	BPWES	☐	BPWES	MENG13	QUAN	13	3	Quantity in GR blocked stock in order price unit
21	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
22	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
23	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
24	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
25	LFGJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
26	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
27	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
28	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
29	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
30	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
31	REEWR	☐	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
32	EVERE	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
33	REFWR	☐	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
34	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
35	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
36	XWSBR	☐	XWSBR	XFELD	CHAR	1	0	Reversal of GR allowed for GR-based IV despite invoice
37	ETENS	☐	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
38	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
39	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
40	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
41	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	T006
42	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
43	AREWW	☐	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
44	HSWAE	☐	HSWAE	WAERS	CUKY	5	0	Local currency key	TCURC
45	BAMNG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
46	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
47	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
48	XWOFF	☐	XWOFF	XFELD	CHAR	1	0	Calculation of val. open
49	XUNPL	☐	XUNPL	XFELD	CHAR	1	0	Unplanned Account Assignment from Invoice Verification
50	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
51	SRVPOS	☐	SRVPOS	ASNUM	CHAR	18	0	Service number	*
52	PACKNO	☐	PACKNO_EKBE	PACKNO	NUMC	10	0	Package Number of Service	*
53	INTROW	☐	INTROW_EKBE	INTROW	NUMC	10	0	Line Number of Service
54	BEKKN	☐	BEKKN	NUM02	NUMC	2	0	Number of PO Account Assignment
55	LEMIN	☐	SRVRET	XFELD	CHAR	1	0	Returns Indicator
56	AREWB	☐	AREWB	WERT7	CURR	13	2	Clearing Value on GR/IR Account in PO Currency
57	REWRB	☐	REWRB	WERT7	CURR	13	2	Invoice Amount in PO Currency
58	SAPRL	☐	SAPRL	SAPRL	CHAR	4	0	SAP Release
59	MENGE_POP	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
60	BPMNG_POP	☐	MENGE_BPR	MENG13	QUAN	13	3	Quantity in purchase order price unit
61	DMBTR_POP	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
62	WRBTR_POP	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
63	WESBB	☐	WESBB	MENG13	QUAN	13	3	Valuated Goods Receipt Blocked Stock in Order Unit
64	BPWEB	☐	BPWEB	MENG13	QUAN	13	3	Quantity in Valuated GR Blocked Stock in Order Price Unit
65	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
66	AREWR_POP	☐	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
67	KUDIF	☐	KUDIF	WERT7	CURR	13	2	Exchange Rate Difference Amount
68	RETAMT_FC	☐	RET_AMT_FC	WERT7	CURR	13	2	Retention Amount in Document Currency
69	RETAMT_LC	☐	RET_AMT_LC	WERT7	CURR	13	2	Retention Amount in Company Code Currency
70	RETAMTP_FC	☐	RET_AMT_POST_FC	WERT7	CURR	13	2	Posted Retention Amount in Document Currency
71	RETAMTP_LC	☐	RET_AMT_POST_LC	WERT7	CURR	13	2	Posted Security Retention Amount in Company Code Currency
72	XMACC	☐	XMACC	CHAR1	CHAR	1	0	Multiple Account Assignment
73	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
74	INV_ITEM_ORIGIN	☐	INV_ITM_ORIGIN	INV_ITM_ORIGIN	CHAR	1	0	Origin of an Invoice Item
75	VBELN_ST	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
76	VBELP_ST	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
77	.INCLUDE	☐				0	0	Return Delivery/Handling of Quantity Differences
78	ET_UPD	☐	ET_UPD1	ET_UPD1	CHAR	1	0	Procedure for Updating the Schedule Line Quantity
79	.INCLU--AP	☐				0	0	Subcontracting Management
80	J_SC_DIE_COMP_F	☐	/SAPNEA/J_SC_DIE_COMP_F	/SAPNEA/J_SC_DIE_COMP_F	CHAR	1	0	Depreciation completion flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKBE	BEWTP	T163B	BEWTP	REF	1	N
2	EKBE	BWART	T156	BWART	REF	1	N
3	EKBE	BWTAR	T149D	BWTAR	REF	1	N
4	EKBE	EBELN	EKKO	EBELN	KEY	1	N
5	EKBE	EBELP	EKPO	EBELP	KEY	1	N
6	EKBE	EMATN	MARA	MATNR
7	EKBE	EVERE	T027C	EVERE	REF	1	N
8	EKBE	GRUND	T157D	GRUND
9	EKBE	HSWAE	TCURC	WAERS	REF	1	N
10	EKBE	LSMEH	T006	MSEHI	REF	1	N
11	EKBE	MANDT	T000	MANDT	KEY	1	N
12	EKBE	MATNR	MARA	MATNR	REF	1	N
13	EKBE	WAERS	TCURC	WAERS	REF	1	N
14	EKBE	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in