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