SAP ABAP Table VL31_HIST (Structure VL31_HIST for Purchase Order History)

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	VL31_HIST	Table Relationship Diagram
Short Description	Structure VL31_HIST for Purchase Order History

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	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	BEWTP	☐	BEWTP	BEWTP	CHAR	1	0	Purchase Order History Category	T163B
10	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
13	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
14	BPMNG	☐	MENGE_BPR	MENG13	QUAN	13	3	Quantity in purchase order price unit
15	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
16	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
17	HSWAE	☐	HSWAE	WAERS	CUKY	5	0	Local currency key	TCURC
18	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	AREWR	☐	AREWR	WERT7	CURR	13	2	GR/IR account clearing value in local currency
21	WESBS	☐	WESBS	MENG13	QUAN	13	3	Goods receipt blocked stock in order unit
22	BPWES	☐	BPWES	MENG13	QUAN	13	3	Quantity in GR blocked stock in order price unit
23	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
24	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
25	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
26	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
27	LFGJA	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
28	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
29	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
30	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
31	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
32	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
33	REEWR	☐	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
34	EVERE	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
35	REFWR	☐	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
37	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
38	XWSBR	☐	XWSBR	XFELD	CHAR	1	0	Reversal of GR allowed for GR-based IV despite invoice
39	ETENS	☐	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
40	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
41	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
42	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
43	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	T006
44	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
45	AREWW	☐	AREWW	WERT7	CURR	13	2	Clearing value on GR/IR clearing account (transac. currency)
46	BAMNG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
47	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
48	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
49	XWOFF	☐	XWOFF	XFELD	CHAR	1	0	Calculation of val. open
50	XUNPL	☐	XUNPL	XFELD	CHAR	1	0	Unplanned Account Assignment from Invoice Verification
51	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
52	SRVPOS	☐	SRVPOS	ASNUM	CHAR	18	0	Service number	*
53	PACKNO	☐	PACKNO_EKBE	PACKNO	NUMC	10	0	Package Number of Service	*
54	INTROW	☐	INTROW_EKBE	INTROW	NUMC	10	0	Line Number of Service
55	BEKKN	☐	BEKKN	NUM02	NUMC	2	0	Number of PO Account Assignment
56	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in