SAP ABAP Table MCVBAK (Sales Document: Header Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCV (Package) R/3 application development: Sales Information System

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in