SAP ABAP Table EKBEDATA (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	INTTAB	Structure
Structure	EKBEDATA	Table Relationship Diagram
Short Description	History per Purchasing Document

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKBEDATA	BEWTP	T163B	BEWTP	REF	1	N
2	EKBEDATA	BWART	T156	BWART	REF	1	N
3	EKBEDATA	BWTAR	T149D	BWTAR	REF	1	N
4	EKBEDATA	EMATN	MARA	MATNR
5	EKBEDATA	EVERE	T027C	EVERE	REF	1	N
6	EKBEDATA	GRUND	T157D	GRUND
7	EKBEDATA	HSWAE	TCURC	WAERS	REF	1	N
8	EKBEDATA	LSMEH	T006	MSEHI	REF	1	N
9	EKBEDATA	MATNR	MARA	MATNR	REF	1	N
10	EKBEDATA	WAERS	TCURC	WAERS	REF	1	N
11	EKBEDATA	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in