SAP ABAP Table MMVBAK (Purchase Order Item + Sales Document Header Data)

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	MMVBAK	Table Relationship Diagram
Short Description	Purchase Order Item + Sales Document Header Data

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	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
2	.INCLUDE	☐				0	0	Sales Document: Header Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
5	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
6	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
9	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
10	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
11	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
12	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
13	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
14	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
15	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
16	SUBMI	☐	SUBMI_SD	CHAR10	CHAR	10	0	Collective number (SD)
17	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
18	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
19	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
20	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
21	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
22	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
23	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
24	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
25	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
26	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
27	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
28	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
29	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
30	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
31	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
32	VPRGR	☐	PRGRS_VBAK	PRGRS	CHAR	1	0	Proposed Period for Date
33	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
34	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
35	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
36	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
37	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
38	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
39	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
40	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
41	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
42	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
43	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
44	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
45	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
46	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
47	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
48	MAHZA	☐	MAHZA	PACK2	DEC	3	0	Number of reminder notices, reminders for delivery purchase
49	MAHDT	☐	MAHDT	DATUM	DATS	8	0	Last Delivery Reminder Notice
50	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
51	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
52	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
53	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
54	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
55	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
56	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
57	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
58	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
59	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
60	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
61	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
62	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
63	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
64	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
65	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
66	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	*
67	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
68	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
69	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
70	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
71	CMNUP	☐	CMNUP	DATUM	DATS	8	0	Date of next credit check of document
72	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
73	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
74	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
75	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
76	ABDIS	☐	ABDIS	ABRAB	CHAR	1	0	MRP for Release Types
77	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
78	OBJNR	☐	OBJKO	J_OBJNR	CHAR	22	0	Object number at header level	ONR00
79	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
80	TAXK1	☐	TAXK1_AK	TAXKD	CHAR	1	0	Alternative tax classification	*
81	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
82	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
83	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
84	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
85	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
86	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
87	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
88	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
89	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
90	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
91	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
92	KALSM_CH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination	T683
93	AGRZR	☐	AGRZR	NUM2	NUMC	2	0	Accrual period for order-related billing docs.to be accrued
94	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
95	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
96	VBELN_GRP	☐	VBELN_GRP	VBELN	CHAR	10	0	Group Master Contract	*
97	SCHEME_GRP	☐	SCHEME_GRP	SCHEME_GRP	CHAR	4	0	Referencing requirement: Procedure	TVGRPS
98	ABRUF_PART	☐	ABRUF_PART	ABRUF_PART	CHAR	1	0	Check partner authorizations
99	ABHOD	☐	ABHOD	DATUM	DATS	8	0	Pick up date
100	ABHOV	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
101	ABHOB	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
102	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
103	VZEIT	☐	EZEIT_VBAK	TIME_SAORG	TIMS	6	0	Proposed schedule line time (local with ref. to sales org.)
104	STCEG_L	☐	LAND1TX	LAND1	CHAR	3	0	Tax Destination Country	T005
105	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	T005
106	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
107	ENQUEUE_GRP	☐	ENQUEUE_GRP	ENQUEUE_GRP	CHAR	1	0	Block master contr. until all lower level contracts updated
108	DAT_FZAU	☐	DAT_FZAU	DATUM	DATS	8	0	Cml delivery order qty date
109	FMBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
110	VSNMR_V	☐	VSNMR_V	VSNMR	CHAR	12	0	Sales document version number
111	HANDLE	☐	TSEGGUID_VBAK	SYSUUID_22	CHAR	22	0	International unique key for VBAK-VBELN
112	PROLI	☐	ADGE_PROLI	ADGD_PROLI	CHAR	3	0	Dangerous Goods Management Profile in SD Documents	TDGC5
113	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
114	CRM_GUID	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
115	UPD_TMSTMP	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
116	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
117	TM_CTRL_KEY	☐	TM_CTRL_KEY		CHAR	4	0	Control Key for Document Transfer to TM
118	.INCLUDE	☐				0	0	Structure: Handover of Goods at Agreed Location
119	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
120	.INCLU--AP	☐				0	0	Append structure for Posting Date in PSM
121	PSM_BUDAT	☐	PSM_BUDAT	DATUM	DATS	8	0	Posting Date in the Document
122	.INCLU--AP	☐				0	0	RE-SCM append to VBAK
123	SWENR	☐	HB_SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
124	SMENR	☐	HB_SMENR	SMENR	CHAR	8	0	Number of Sales Unit	VIMI01
125	PHASE	☐	HB_SPHSE	HBS_PHASE	CHAR	11	0	Sales Phase	HBSSPH
126	MTLAUR	☐	HB_MTLAUR	HBS_MTLAUR	CHAR	1	0	Marker for Low Income Housing	CHBSNCM
127	STAGE	☐	HB_STAGE	INT4	INT4	10	0	Construction Stage
128	HB_CONT_REASON	☐	HB_CONT	CHAR2	CHAR	2	0	Contingency data	HBSCREASON
129	HB_EXPDATE	☐	HB_EXP	DATS	DATS	8	0	Expiration date
130	HB_RESDATE	☐	HB_RES	DATS	DATS	8	0	Resolution date
131	.INCLU--AP	☐				0	0	VBAK Fields for CRM Documents
132	LOGSYSB	☐	LOGSYSB	LOGSYS	CHAR	10	0	Logical system with which document was created	*
133	.INCLU--AP	☐				0	0	TPM Campaign Determination: Append to VBAK
134	KALCD	☐	KALCD	KALSM	CHAR	6	0	Procedure for Campaign Determination	*
135	MULTI	☐	CMPC_MULT_CAMPAIGN	CMPGN_MULT_CAMPAIGN	CHAR	1	0	Multiple Campaigns/Trade Promotions Active Indicator
136	.INCLU--AP	☐				0	0	Append Structure for Special Paymenents
137	SPPAYM	☐	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MMVBAK	ABRVW	TVLV	ABRVW	REF	C	CN
2	MMVBAK	AUART	TVAK	AUART	REF	1	CN
3	MMVBAK	AUFNR	AUFK	AUFNR	REF	C	CN
4	MMVBAK	AUGRU	TVAU	AUGRU	REF	C	CN
5	MMVBAK	BSARK	T176	BSARK	REF	C	CN
6	MMVBAK	BUKRS_VF	T001	BUKRS	REF	C	CN
7	MMVBAK	CMWAE	TCURC	WAERS	REF	C	CN
8	MMVBAK	CTLPC	T691A	CTLPC	REF	C	CN
9	MMVBAK	FAKSK	TVFS	FAKSP	REF	C	CN
10	MMVBAK	FKARA	TVFK	FKART	REF	C	CN
11	MMVBAK	GSBER	TGSB	GSBER	REF	C	CN
12	MMVBAK	GSKST	TGSB	GSBER	REF	C	CN
13	MMVBAK	HB_CONT_REASON	HBSCREASON	HB_CONT	KEY
14	MMVBAK	HITYP_PR	THIT	HITYP	REF	C	CN
15	MMVBAK	KALSM	T683	KALSM	REF	C	CN
16	MMVBAK	KALSM_CH	T683	KALSM	REF	C	CN
17	MMVBAK	KKBER	T014	KKBER	REF	C	CN
18	MMVBAK	KNKLI	KNA1	KUNNR	REF	C	CN
19	MMVBAK	KNUMA	KONA	KNUMA	KEY	1	CN
20	MMVBAK	KOKRS	TKA01	KOKRS	REF	C	CN
21	MMVBAK	KUNNR	KNA1	KUNNR	REF	C	CN
22	MMVBAK	KURST	TCURV	KURST	REF	C	CN
23	MMVBAK	KVGR1	TVV1	KVGR1	REF	C	CN
24	MMVBAK	KVGR2	TVV2	KVGR2	REF	C	CN
25	MMVBAK	KVGR3	TVV3	KVGR3	REF	C	CN
26	MMVBAK	KVGR4	TVV4	KVGR4	REF	C	CN
27	MMVBAK	KVGR5	TVV5	KVGR5	REF	C	CN
28	MMVBAK	LANDTX	T005	LAND1		C	CN
29	MMVBAK	LIFSK	TVLS	LIFSP	REF	C	CN
30	MMVBAK	MANDT	T000	MANDT	KEY	1	CN
31	MMVBAK	MTLAUR	CHBSNCM	INCOME
32	MMVBAK	OBJNR	ONR00	OBJNR	REF	C	CN
33	MMVBAK	PHASE	HBSSPH	PHASE
34	MMVBAK	PROLI	TDGC5	PROLI
35	MMVBAK	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
36	MMVBAK	QMNUM	QMEL	QMNUM	REF	C	CN
37	MMVBAK	RPLNR	FPLA	FPLNR	REF	C	1
38	MMVBAK	SBGRP	T024B	SBGRP	REF	C	CN
39	MMVBAK	SCHEME_GRP	TVGRPS	SCHEME		1	CN
40	MMVBAK	SMENR	VIMI01	SMENR
41	MMVBAK	SPART	TVTA	SPART	REF	1	CN
42	MMVBAK	STCEG_L	T005	LAND1		C	CN
43	MMVBAK	STWAE	TCURC	WAERS	REF	C	CN
44	MMVBAK	SWENR	VIOB01	SWENR
45	MMVBAK	VBELN	VBUK	VBELN	KEY	1	C
46	MMVBAK	VGBEL	VBUK	VBELN	REF	C	CN
47	MMVBAK	VKBUR	TVKBZ	VKBUR	REF	C	CN
48	MMVBAK	VKGRP	TVBVK	VKGRP	REF	C	CN
49	MMVBAK	VKORG	TVKO	VKORG	REF	1	CN
50	MMVBAK	VSBED	TVSB	VSBED	REF	C	CN
51	MMVBAK	VTWEG	TVKOV	VTWEG	REF	1	CN
52	MMVBAK	WAERK	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in