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
⤷ 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
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |