SAP ABAP Table MCVBAPB (Reference Structure from MCVBAP 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 MCVBAPB   Table Relationship Diagram
Short Description Reference Structure from MCVBAP 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: Item Data  
4 .INCLUDE       0   0   Sales Document: Item Data  
5 MANDT MANDT MANDT CLNT 3   0   Client T000
6 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
7 POSNR POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
8 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
9 MATWA MATWA MATNR CHAR 18   0   Material entered MARA
10 PMATN PMATN MATNR CHAR 18   0   Pricing Reference Material MARA
11 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
12 MATKL MATKL MATKL CHAR 9   0   Material Group T023
13 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
14 PSTYV PSTYV PSTYV CHAR 4   0   Sales document item category TVPT
15 POSAR POSAR POSAR CHAR 1   0   Item type  
16 LFREL LFREL_AP XFELD CHAR 1   0   Item is relevant for delivery  
17 FKREL FKREL FKREL CHAR 1   0   Relevant for Billing  
18 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures VBUP
19 GRPOS GRPOS GRPOS NUMC 6   0   Item for which this item is an alternative  
20 ABGRU ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders TVAG
21 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
22 ZWERT DZWERT WERT7 CURR 13   2   Target value for outline agreement in document currency  
23 ZMENG DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
24 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM T006
25 UMZIZ UMZIZ UMBSZ DEC 5   0   Factor for converting sales units to base units (target qty)  
26 UMZIN UMZIN UMBSN DEC 5   0   Factor for converting sales units to base units (target qty)  
27 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
28 SMENG SMENG MENG13 QUAN 13   3   Scale quantity in base unit of measure  
29 ABLFZ ABLFZ ABLFZ QUAN 13   3   Rounding quantity for delivery  
30 ABDAT ABDAT DATUM DATS 8   0   Reconciliation date for agreed cumulative quantity  
31 ABSFZ ABSFZ MENG13 QUAN 13   3   Allowed deviation in quantity (absolute)  
32 POSEX POSEX POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
33 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
34 KBVER KBVER PACK2 DEC 3   0   Allowed deviation in quantity (in percent)  
35 KEVER KEVER PACK2 DEC 3   0   Days by which the quantity can be shifted  
36 VKGRU VKGRU RMA_VORGA CHAR 3   0   Repair processing: Classify items TVRMAVK
37 VKAUS ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
38 GRKOR GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
39 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
40 UEBTK UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
41 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
42 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
43 FAKSP FAKSP_AP FAKSP CHAR 2   0   Billing block for item TVFS
44 ATPKZ ATPKZ ATPKZ CHAR 1   0   Replacement part  
45 RKFKF RKFKF RKFKF CHAR 1   0   Form of Billing for CO/PPC Orders  
46 SPART SPART SPART CHAR 2   0   Division TSPA
47 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
48 NETWR NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
49 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
50 ANTLF ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
51 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
52 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
53 KWMENG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
54 LSMENG LSMENG MENG15 QUAN 15   3   Cumulative Target Delivery Qty (all dlv-relev.sched.lines)  
55 KBMENG KBMENG MENG15 QUAN 15   3   Cumulative confirmed quantity in sales unit  
56 KLMENG KLMENG MENG15 QUAN 15   3   Cumulative Confirmed Quantity in Base Unit of Measure  
57 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
58 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
59 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
60 BRGEW BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
61 NTGEW NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
62 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
63 VOLUM VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
64 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
65 VBELV VBELV VBELN CHAR 10   0   Originating document VBUK
66 POSNV POSNV POSNR NUMC 6   0   Originating item VBUP
67 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
68 VGPOS VGPOS POSNR NUMC 6   0   Item number of the reference item VBUP
69 VOREF VOREF XFELD CHAR 1   0   Complete reference indicator  
70 UPFLU UPFLV UPFLV CHAR 1   0   Update indicator for sales document document flow  
71 ERLRE ERLRE ERLRE CHAR 1   0   Completion rule for quotation / contract  
72 LPRIO LPRIO LPRIO NUMC 2   0   Delivery priority TPRIO
73 WERKS WERKS_EXT WERKS CHAR 4   0   Plant (Own or External) T001W
74 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
75 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
76 ROUTE ROUTE ROUTE CHAR 6   0   Route TVRO
77 STKEY STKEY STKEY CHAR 1   0   Origin of the bill of material  
78 STDAT STDAT DATUM DATS 8   0   Date of Bill of Material  
79 STLNR STNUM STNUM CHAR 8   0   Bill of Material  
80 STPOS STPOS_VBAP STPOS_VBAP DEC 5   0   Bill of material item number VBAP not used  
81 AWAHR AWAHR AWAHR NUMC 3   0   Order probability of the item  
82 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
83 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
84 ERZET ERZET UZEIT TIMS 6   0   Entry time  
85 TAXM1 TAXMT TAXKD CHAR 1   0   Tax classification material *
86 TAXM2 TAXMT TAXKD CHAR 1   0   Tax classification material *
87 TAXM3 TAXMT TAXKD CHAR 1   0   Tax classification material *
88 TAXM4 TAXMT TAXKD CHAR 1   0   Tax classification material *
89 TAXM5 TAXMT TAXKD CHAR 1   0   Tax classification material *
90 TAXM6 TAXMT TAXKD CHAR 1   0   Tax classification material *
91 TAXM7 TAXMT TAXKD CHAR 1   0   Tax classification material *
92 TAXM8 TAXMT TAXKD CHAR 1   0   Tax classification material *
93 TAXM9 TAXMT TAXKD CHAR 1   0   Tax classification material *
94 VBEAF VBEAF DEC3_2 DEC 5   2   Fixed shipping processing time in days (= setup time)  
95 VBEAV VBEAV DEC3_2 DEC 5   2   Variable shipping processing time in days  
96 VGREF VGREF XFELD CHAR 1   0   Preceding document has resulted from reference  
97 NETPR NETPR WERTV6 CURR 11   2   Net price  
98 KPEIN KPEIN KPEIN DEC 5   0   Condition pricing unit  
99 KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
100 SHKZG SHKZG_VA XFELD CHAR 1   0   Returns Item  
101 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
102 MTVFP MTVFP MTVFP CHAR 2   0   Checking Group for Availability Check TMVF
103 SUMBD SUMBD SUMBD CHAR 1   0   Summing up of requirements  
104 KONDM KONDM KONDM CHAR 2   0   Material Pricing Group T178
105 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material TVKM
106 BONUS BONUS BONUS CHAR 2   0   Volume rebate group TVBO
107 PROVG PROVG PROVG CHAR 2   0   Commission group TVPR
108 EANNR EANNR CHAR13 CHAR 13   0   European Article Number (EAN) - obsolete!!!!!  
109 PRSOK PRSOK XFELD CHAR 1   0   Pricing is OK  
110 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
111 BWTEX BWTEX XFELD CHAR 1   0   Indicator: Separate valuation  
112 XCHPF XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
113 XCHAR XCHAR XFELD CHAR 1   0   Batch management indicator (internal)  
114 LFMNG MINLF MENG13 QUAN 13   3   Minimum delivery quantity in delivery note processing  
115 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
116 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
117 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
118 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
119 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
120 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
121 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
122 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
123 STCUR STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
124 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
125 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
126 FIXMG FIXMG XFELD CHAR 1   0   Delivery date and quantity fixed  
127 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
128 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
129 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
130 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
131 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
132 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
133 KMPMG KMPMG MENGV13 QUAN 13   3   Component Quantity  
134 SUGRD SUGRD SUGRD CHAR 4   0   Reason for material substitution TVSU
135 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
136 VPZUO VPZUO ZUVKZ CHAR 1   0   Allocation Indicator  
137 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
138 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
139 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
140 VPMAT VPMAT MATNR CHAR 18   0   Planning material MARA
141 VPWRK VPWRK WERKS CHAR 4   0   Planning plant T001W
142 PRBME PRBME MEINS UNIT 3   0   Base unit of measure for product group T006
143 UMREF UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
144 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
145 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
146 SERNR SERNR SERNR CHAR 8   0   BOM explosion number SNUM
147 OBJNR OBJPO J_OBJNR CHAR 22   0   Object number at item level ONR00
148 ABGRS ABGR_SCHL ABGR_SCHL CHAR 6   0   Results Analysis Key TKKAA
149 BEDAE BEDAE BEDAE CHAR 4   0   Requirements type T459A
150 CMPRE CMPRE WERTV6 CURR 11   2   Item credit price  
151 CMTFG CMTFG XFELD CHAR 1   0   ID for partial release of order item, credit block  
152 CMPNT CMPNT XFELD CHAR 1   0   ID: Item with active credit function / relevant for credit  
153 CMKUA CMKUA KURRF DEC 9   5   Credit data exchange rate for requested delivery date  
154 CUOBJ CUOBJ_VA CUOBJ NUMC 18   0   Configuration  
155 CUOBJ_CH CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
156 CEPOK CEPOK CEPOK CHAR 1   0   Status expected price  
157 KOUPD KOUPD XFELD CHAR 1   0   Condition update  
158 SERAIL SERAIL SERAIL CHAR 4   0   Serial Number Profile T377P
159 ANZSN ANZSN INT4 INT4 10   0   Number of serial numbers  
160 NACHL NACHL XFELD CHAR 1   0   Customer has not posted goods receipt  
161 MAGRV MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials TVEGR
162 MPROK MPROK MPROK CHAR 1   0   Status manual price change  
163 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
164 PROSA PROSA PROSA CHAR 1   0   ID for material selection - active  
165 UEPVW UEPVW UEPVW CHAR 1   0   ID for higher-level item usage  
166 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure *
167 KLVAR CK_KLVAR KLVAR CHAR 4   0   Costing Variant *
168 SPOSN SPOSN SPOSN CHAR 4   0   BOM Item Number  
169 KOWRR KOWRR KOWRR CHAR 1   0   Statistical values  
170 STADAT STADAT DATUM DATS 8   0   Statistics date  
171 EXART EXART EXART CHAR 2   0   Business Transaction Type for Foreign Trade T605
172 PREFE PREFE PREFE CHAR 1   0   Preference indicator in export/import  
173 KNUMH KNUMH_CH KNUMB CHAR 10   0   Number of condition record from batch determination  
174 CLINT CLINT CLINT NUMC 10   0   Internal Class Number KLAH
175 CHMVS CHMVS NUM3 NUMC 3   0   Batches: Exit to quantity proposal  
176 STLTY STLTY STLTY CHAR 1   0   BOM Category  
177 STLKN STLKN KNTNR NUMC 8   0   BOM Item Node Number  
178 STPOZ CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
179 STMAN CUINK XFELD CHAR 1   0   Inconsistent configuration  
180 ZSCHL_K AUFZSCHL CHAR6 CHAR 6   0   Overhead key  
181 KALSM_K AUFKALSM KALSM CHAR 6   0   Costing Sheet T683
182 KALVAR CK_KLVAR KLVAR CHAR 4   0   Costing Variant TCK03
183 KOSCH KOSCH KOSCH CHAR 18   0   Product allocation determination procedure T190S
184 UPMAT UPMAT MATNR CHAR 18   0   Pricing reference material of main item MARA
185 UKONM UKONM KONDM CHAR 2   0   Material pricing group of main item T178
186 MFRGR MFRGR MFRGR CHAR 8   0   Material freight group TMFG
187 PLAVO PLAVO PLAVO CHAR 4   0   Planning Release Regulation TVZP
188 KANNR KANNR CHAR35 CHAR 35   0   KANBAN/sequence number  
189 CMPRE_FLT CMPRE_FLT FLTP FLTP 16   16   Item credit price  
190 ABFOR ABSFORM_CM ABSFORM_CM CHAR 2   0   Form of payment guarantee T691K
191 ABGES ABGES_CM FLTP FLTP 16   16   Guaranteed (factor between 0 and 1)  
192 J_1BCFOP J_1BCFOP J_1BCFOP CHAR 10   0   CFOP code and extension J_1BAG
193 J_1BTAXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
194 J_1BTAXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI J_1BATL2
195 J_1BTXSDC J_1BTXSDC_ J_1BTXSDC CHAR 2   0   SD tax code J_1BTXSDC
196 WKTNR WKTNR VBELN CHAR 10   0   Value contract no. VBUK
197 WKTPS WKTPS POSNR NUMC 6   0   Value contract item VBUP
198 SKOPF W_SORTK WSORTK CHAR 18   0   Assortment Module WSOH
199 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
200 WGRU1 WGRU_HIE1 KLASSE CHAR 18   0   Material group hierarchy 1  
201 WGRU2 WGRU_HIE2 KLASSE CHAR 18   0   Material group hierarchy 2  
202 KNUMA_PI KNUMA_PI KNUMA CHAR 10   0   Promotion KONA
203 KNUMA_AG KNUMA_AG KNUMA CHAR 10   0   Sales deal KONA
204 KZFME KZFME KZFME CHAR 1   0   ID: Leading unit of measure for completing a transaction  
205 LSTANR LSTANR STATVNR CHAR 1   0   Free goods delivery control  
206 TECHS TECHS TECHS CHAR 12   0   Parameter Variant/Standard Variant  
207 MWSBP MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
208 BERID BERID BERID CHAR 10   0   MRP Area *
209 PCTRF PCTRF PRCTR CHAR 10   0   Profit Center for Billing *
210 LOGSYS_EXT LOGSYS LOGSYS CHAR 10   0   Logical system *
211 J_1BTAXLW3 J_1BTAXLW3 J_1BTAXLW3 CHAR 3   0   Tax law: ISS J_1BATL3
212 J_1BTAXLW4 J_1BTAXLW4 J_1BTAXLW4 CHAR 3   0   COFINS Tax Law J_1BATL4A
213 J_1BTAXLW5 J_1BTAXLW5 J_1BTAXLW5 CHAR 3   0   PIS Tax Law J_1BATL5
214 STOCKLOC STOCKLOC LOCNR CHAR 20   0   First Inventory-Managing Location  
215 SLOCTYPE SLOCTYPE LOCTYP CHAR 4   0   Type of First Inventory-Managing Location  
216 MSR_RET_REASON MSR_RETURNS_REASON MSR_RETURNS_REASON CHAR 3   0   Return Reason MSR_C_RET_REASON
217 MSR_REFUND_CODE MSR_RETURNS_REFUND_CODE MSR_RETURNS_REFUND_CODE CHAR 3   0   Returns Refund Code MSR_C_RET_REFUND
218 MSR_APPROV_BLOCK MSR_APPROVAL_BLOCK MSR_APPROVAL_BLOCK CHAR 1   0   Approval Block  
219 NRAB_KNUMH KNUMH KNUMB CHAR 10   0   Condition record number  
220 TRMRISK_RELEVANT SLS_TRM_RISK_RELEVANCY LOGTRM_RISK_RELEVANCY CHAR 2   0   Risk Relevancy in Sales  
221 .INCLUDE       0   0   Structure: Handover of Goods at Agreed Location  
222 HANDOVERLOC HANDOVER_LOC HANDOVER_LOC CHAR 10   0   Location for a physical handover of goods  
223 .INCLUDE       0   0   Structure: Date for Handover of Goods at Agreed Location  
224 HANDOVERDATE HANDOVER_DATE HANDOVER_DATE DATS 8   0   Handover Date at the Handover Location  
225 HANDOVERTIME HANDOVER_TIME HANDOVER_TIME TIMS 6   0   Handover time at the handover location  
226 .INCLUDE       0   0    
227 .INCLUDE       0   0   SD Tax Code determination  
228 TC_AUT_DET J_1BTC_AUT_DET MWSKZ CHAR 2   0   Tax Code Automatically Determined *
229 MANUAL_TC_REASON J_1BMANUAL_TC_REASON J_1BMANUAL_TC_REASON CHAR 2   0   Manual Tax Code Reason *
230 FISCAL_INCENTIVE J_1BFISCAL_INCENTIVE_CODE J_1BFISCAL_INCENTIVE_CODE CHAR 4   0   Tax Incentive Type *
231 TAX_SUBJECT_ST J_1BTC_TAX_SUBJECT_ST J_1BYES_NO CHAR 1   0   Tax Subject to Substituição Tributária  
232 FISCAL_INCENTIVE_ID J_1BFISCAL_INCENTIVE_ID_SD J_1BFISCAL_INCENTIVE_ID_SD CHAR 4   0   Incentive ID *
233 SPCSTO J_1BSPCSTO_SD J_1BSPCSTO_SD NUMC 2   0   Nota Fiscal Special Case for CFOP Determination *
234 .INCLU--AP       0   0   Append to VBAP for Customer Returns  
235 .INCLUDE       0   0   Include for Append for VBAP for Customers Returns  
236 /BEV1/SRFUND /BEV1/SRBEFUND ABGRU_VA CHAR 2   0   Analysis/Reason for Rejection *
237 .INCLU--AP       0   0   OLC: Operation internal identifier fields  
238 AUFPL_OLC CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
239 APLZL_OLC CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
240 .INCLU--AP       0   0   Append structure for Regulatory Reporting  
241 FERC_IND FE_IND FE_IND CHAR 4   0   Regulatory indicator FERC_C7
242 .INCLU--AP       0   0   Grants Mgmt: additional components to VBAP  
243 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
244 FONDS BP_GEBER BP_GEBER CHAR 10   0   Fund *
245 FISTL FISTL FISTL CHAR 16   0   Funds Center *
246 FKBER FKBER FKBER CHAR 16   0   Functional Area *
247 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
248 .INCLU--AP       0   0   IUID fields  
249 IUID_RELEVANT IUID_RELEVANT_CUST UID_RELEVANT CHAR 1   0   IUID Relevant for Customer  
250 .INCLU--AP       0   0   Engagement mgmt:VBAP Append structure  
251 .INCLUDE       0   0   Engagement mgmt: VBAP extension  
252 PRS_OBJNR PRS_OBJNR CHAR22 CHAR 22   0   Engagement mgmt: Object number  
253 .INCLU--AP       0   0   Commercial Project Inception & Lean Staffing appending VBAP  
254 PRS_SD_SPSNR PRS_SD_SPSNR PS_SPSNR NUMC 8   0   Standard WBS Element for Project Inception via SD *
255 PRS_WORK_PERIOD PRS_WORK_PERIOD PRS_WORK_PERIOD NUMC 7   0   Work Period (Internal Representation)  
256 .INCLU--AP       0   0   Enhancement for RRICB / DP93  
257 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
258 .INCLU--AP       0   0   Append for Operation level costing  
259 AUFPL_OAA CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
260 APLZL_OAA CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
261 .INCLUDE       0   0   Additional Specification: Sales Document - Item Data  
262 VDATU MC_VDATUM DATUM DATS 8   0   Date of update for statistics updating  
263 OAUME MC_OAUME MENGV15_3 QUAN 15   3   Open orders quantity in base unit of measure  
264 OAUWE MC_OAUWE WERTV10 CURR 19   2   Open net value of orders  
265 OLIME MC_OLIME MENGV15_3 QUAN 15   3   Open delivery quantity  
266 OLIKW MC_OLIKW_F FLTP FLTP 16   16   Open delivery credit value  
267 OLIMEAU MC_OLIMEAU MENGV15_3 QUAN 15   3   Open delivery quantity from sales order  
268 OLIKWGES MC_OLIKWGF FLTP FLTP 16   16   Total open delivery credit value (without guarantee)  
269 OLIKWAU MC_OLIKWAF FLTP FLTP 16   16   Open delivery credit value from sales order  
270 WEBUK BUKRS BUKRS CHAR 4   0   Company Code *
271 ABSTP ABSTYP_CM ABSTYP_CM CHAR 1   0   Payment guarantee category  
272 PERIV_LF PERIV PERIV CHAR 2   0   Fiscal Year Variant *
273 OLIKWAA MC_OLIKWFA FLTP FLTP 16   16   Guaranteed open delivery value  
274 OLIKWAUAA MC_OLIKFAA FLTP FLTP 16   16   Guaranteed open delivery value from order  
275 OLIKWAUGES MC_OLIKWFG FLTP FLTP 16   16   Open delivery credit value from order (without guarantee)  
276 KFKIV KFKIV XFELD CHAR 1   0   Condition for Inter-Company Billing  
277 KWMENG_ORG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
278 NETWR_VME NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
279 NETWR_B NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
280 KWMENG_B KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
281 OLINWAU MC_OLINWAF FLTP FLTP 16   16   Open Net Delivery Value from Order  
282 .INCLUDE       0   0   Partner Field String from VBPA  
283 PKUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
284 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
285 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
286 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
287 PSPDNR SPDNR LIFNR CHAR 10   0   Carrier *
288 PVRTNR VRTNR PERNR NUMC 8   0   Sales employee  
289 PLAAG PLAAG LAND1 CHAR 3   0   Country of the sold-to party *
290 PLAWE PLAWE LAND1 CHAR 3   0   Country of ship-to party *
291 PLARE PLARE LAND1 CHAR 3   0   Country of the bill-to party *
292 PLARG PLARG LAND1 CHAR 3   0   Country of the payer *
293 PLASP PLASP LAND1 CHAR 3   0   Country of the carrier *
294 PLAVE PLAVE LAND1 CHAR 3   0   Country of the representative *
295 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
296 PZONE PZONE ZONE CHAR 10   0   Transportation zone of the ship-to party *
297 .INCLUDE       0   0   User Section: Additional Partner(s) from VBPA  
298 PDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
299 PZPERS DZPERS PERNR NUMC 8   0   Person responsible  
300 PLAZM PLAZM LAND1 CHAR 3   0   Country of Employee Responsible *
301 .INCLUDE       0   0   IS-R Enhancements to MCVBAP  
302 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
303 EKSGB EKSGB EKSGB CHAR 4   0   Purchasing area T026
304 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
305 DISPO DISPO DISPO CHAR 3   0   MRP controller T024D
306 LIFNR MCW_RLIFN LIFNR CHAR 10   0   Account number of regular vendor LFA1
307 LTSNR LTSNR LTSNR CHAR 6   0   Vendor Subrange WYT1
308 BTRKZ VLFKZ VLFKZ CHAR 1   0   Plant category  
309 ABTNR ABTNR ABTNR CHAR 4   0   Department number TSAB
310 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material MARA
311 SWGRU1 MCW_WGRU1 KLASSE CHAR 18   0   Material group hierarchy 1  
312 SWGRU2 MCW_WGRU2 KLASSE CHAR 18   0   Material group hierarchy 2  
313 MERK1 MCW_MERK1 ATWRT CHAR 30   0   Characteristic 1  
314 MERK2 MCW_MERK2 ATWRT CHAR 30   0   Characteristic 2  
315 MERK3 MCW_MERK3 ATWRT CHAR 30   0   Characteristic 3  
316 AKTYP W_AKTYP AKTTY CHAR 4   0   Promotion Category TWTY
317 AKTHE W_AKTHE THEMA CHAR 4   0   Promotion theme TWAT
318 PLGTP PLGTP PLGTP CHAR 2   0   Price band category TWPT
319 SAISO SAISO SAISO CHAR 4   0   Season Category T6WSP
320 SAISJ SAISJ CJAHR CHAR 4   0   Season Year  
321 BWVOR BWVOR BWVOR CHAR 1   0   Procurement rule T6WP1
322 BWSCL BWSCL BQSCL CHAR 1   0   Source of Supply TMBW1
323 SERVG W_SERVGRD W_SERVGRD CHAR 1   0   IS-R service level TWSG
324 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
325 LAND1 MCW_LANDRL LAND1 CHAR 3   0   Country of regular vendor T005
326 WRKGR2 MCW_WRKGR2 KLASSE CHAR 18   0   Plant group hierarchy 2  
327 WRKGR1 MCW_WRKGR1 KLASSE CHAR 18   0   Plant group hierarchy 1  
328 MTART MTART MTART CHAR 4   0   Material type T134
329 WMAKG WMAK WMAK CHAR 1   0   Material type ID  
330 ASCAR ASORT ASORT CHAR 10   0   Assortment *
331 SVKORG MCW_SVKORG VKORG CHAR 4   0   Master data: sales organization (Retail) TVKO
332 SVTWEG MCW_SVTWEG VTWEG CHAR 2   0   Master data: distribution channel (Retail) TVTW
333 SBZIRK MCW_SBZIRK BZIRK CHAR 6   0   Master data: customer district (Retail) T171
334 SMATKL MCW_SMATKL MATKL CHAR 9   0   Master data: material group (Retail) T023
335 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
336 KOLIF KOLIF LIFNR CHAR 10   0   Prior Vendor *
337 ATINM1 MCW_ATINM1 ATINN NUMC 10   0   Internal characteristic number, characteristic 1 *
338 ATINM2 MCW_ATINM2 ATINN NUMC 10   0   Internal characteristic number, characteristic 2 *
339 ATINM3 MCW_ATINM3 ATINN NUMC 10   0   Internal characteristic number, characteristic 3 *
340 STRNR STRNR MATNR CHAR 18   0   Structured material MARA
341 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
342 SEAN11 SEAN11 EAN11 CHAR 18   0   European article number (master data)  
343 KAVMNG MCW_KAVMNG MENGV15_3 QUAN 15   3   Sales order volume quantity  
344 KAVGEO MCW_KAVGEO WERTV10 CURR 19   2   Sales order volume at cost  
345 KAVGVO MCW_KAVGVO WERTV10 CURR 19   2   Sales order volume at retail  
346 KAVGVP MCW_KAVGVP WERTV10 CURR 19   2   Sales order volume at retail with tax  
347 KAVGEW MCW_KAVGEW MENGV15_3 QUAN 15   3   Sales order volume weight  
348 KAVVOL MCW_KAVVOL MENGV15_3 QUAN 15   3   Sales order volume volume  
349 WKUNNR KUNNR_WK KUNNR CHAR 10   0   Customer number of plant KNA1
350 RPLREL WRPL_RELEV BOOLE CHAR 1   0   ID: relevant for Replenishment?  
351 BIWMNG MCW_BIWMNG MENGV15_3 QUAN 15   3   RIS/Reporting Server - Transfer base quantity  
352 BIWMVE MCW_BIWMVE MENGV15_3 QUAN 15   3   RIS/Reporting Server - Transfer quantity sold  
353 BIWGEO MCW_BIWGEO WERTV10 CURR 19   2   RIS/Reporting Server - Transfer cost price  
354 BIWGVO MCW_BIWGVO WERTV10 CURR 19   2   RIS/Reporting Server - Transfer retail price  
355 BIWGVP MCW_BIWGVP WERTV10 CURR 19   2   RIS/Reporting Server - Transfer retail price with tax  
356 BWVORG MCW_BWVORG NUM3 NUMC 3   0   SAP BW transaction key  
357 ADDMNG MCW_ADDMNG MENGV15_3 QUAN 15   3   Quantity of materials with additionals in base unit of meas.  
358 ADDANZ MCW_ADDANZ MCZAEHLINT INT4 10   0   Number of affixed additionals  
359 ADDTIM MCW_ADDTIM DEC17_5 DEC 17   5   Processing time to affix the additionals  
360 ADDKMW MCW_ADDKMW WERTV10 CURR 19   2   Material costs of additionals  
361 ADDKAL MCW_ADDKAL WERTV10 CURR 19   2   Handling costs for additionals  
362 ADDIAPPL ADDI_APPL ADDI_APPL CHAR 2   0   Application for triggering follow-up actions for additionals  
363 ADDI1 MCW_ADDI1 MATNR CHAR 18   0   Additional 1 *
364 ADDI2 MCW_ADDI2 MATNR CHAR 18   0   Additional 2 *
365 ADDI3 MCW_ADDI3 MATNR CHAR 18   0   Additional 3 *
366 HSUPKZ MCW_SUPKZ SUPKZ CHAR 1   0   Auxiliary statistics update indicator  
367 HERZET ERZET UZEIT TIMS 6   0   Entry time  
368 .INCLUDE       0   0   W&S: Enhancement MCVBAP  
369 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
370 .INCLUDE       0   0   W&S: Picking Waves and Workload Estimate - Characteristics 1  
371 METYP METYP MEITY CHAR 1   0   Unit-of-measure load category according to workload criteria *
372 WARTYP MCL_WARTYP MCL_WARTYP CHAR 1   0   Goods category (promotional goods or normal goods)  
373 BELTYP MCL_BELTYP MCL_BELTYP CHAR 3   0   Document category: rough workload estimate  
374 VZTTG MCL_VZTTG MCL_VZTTG CHAR 1   0   Warehouse process  
375 VHARTL MCL_VHARTL TRATY CHAR 4   0   Packaging Material Type Rough Workload Estimate TVTY
376 TIMEL MCL_TIMEL KAPTPROG CHAR 4   0   Time slot: Rough workload forecast TC37A
377 .INCLUDE       0   0   W&S: Picking Waves and Workload Estimate - Characteristics 2  
378 PLGTYP MCL_PLGTYP LGTYP CHAR 3   0   Planned picking storage type T301
379 PKOBER MCL_PKOBER KOBER CHAR 3   0   Planned picking area *
380 GEWEHL MCL_GEWEH MEINS UNIT 3   0   Weight unit: Rough Workload Estimate and picking waves T006
381 VOLEHL MCL_VOLEH MEINS UNIT 3   0   Volume unit: Rough Workload Estimate and picking waves T006
382 .INCLUDE       0   0   W&S: Picking Waves and Workload Estimate - Key Figures 1  
383 BZEIT_E MCL_BZEITE DEC17_5 DEC 17   5   Processing time+ for quantity in hours  
384 VHART_E MCL_VHARTE DEC15_3 DEC 15   3   Packaging Materials for Packaging Material Type +  
385 .INCLUDE       0   0   User Structure: Sales Document - Item Data  
386 DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
387 .INCLUDE       0   0   Root fields to allocate contract/quoation item + order item  
388 ROOT_HEAD TDD_ROOT_HEAD VBELN CHAR 10   0   Document Number of the Root Header *
389 ROOT_ITEM TDD_ROOT_ITEM POSNR NUMC 6   0   Item Number of the Root Item *
390 ROOT_DATE TDD_ROOT_DATE DATUM DATS 8   0   Date of the Root Item  
391 .INCLU--AP       0   0   Append for MCVBAP for Transfer to BW  
392 .INCLUDE       0   0   Enhancement for MCVBAP for BW Transfer  
393 BWMVE MCBW_MVE MENGV15_3 QUAN 15   3   BW: Quantity in Sales Unit  
394 BWGEOD MCBW_GEOD WERTV10 CURR 19   2   BW: Cost Value in Document Currency  
395 BWGVOD MCBW_GVOD WERTV10 CURR 19   2   BW: Retail Value in Document Currency  
396 BWGVPD MCBW_GVPD WERTV10 CURR 19   2   BW: Retail Value with Tax in Document Currency  
397 BWPNLD MCBW_PNLD WERTV10 CURR 19   2   BW: Price Reduction in Document Currency  
398 BWAPPLNM RSAPPLNM RSAPPLNM CHAR 30   0   Application Component  
399 BWSUPKZ MCBW_SUPKZ SUPKZ CHAR 1   0   Auxiliary statistics update indicator  
400 BWERZET ERZET UZEIT TIMS 6   0   Entry time  
401 BWDUMMY MCBW_DUMMY DUMMY CHAR 1   0   Dummy Function for Extraction SAPBW  
402 .INCLUDE       0   0   Activity Indicator for System Updates: LIS  
403 MCBONUS MC_BONUS STAFO CHAR 6   0   LIS Link to Rebates: Update Group *
404 MCFINANZ MC_FINANZ STAFO CHAR 6   0   LIS link to cash management and forecast: update group *
405 MCPROJEKT MC_PROJEKT STAFO CHAR 6   0   LIS link to CO/Projects: update group *
406 MCKREDIT MC_KREDIT STAFO CHAR 6   0   LIS link to credit limits: update group *
407 MCCAS MC_CAS STAFO CHAR 6   0   LIS link to Sales Support (CAS): update group *
408 MCKOUPD MC_KOUPD STAFO CHAR 6   0   LIS link condition update: update group *
409 MCLIPLAN MC_LIPLAN STAFO CHAR 6   0   LIS interface to scheduling agreement: update group *
410 MCWERTKON MC_WERTKON STAFO CHAR 6   0   LIS link to value contract: Update group *
411 MCBIW MC_BIW STAFO CHAR 6   0   LIS connection BIW export SD documents: update group *
412 .INCLUDE       0   0   Table for Update Indicators  
413 UPDKZ UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MCVBAPB ABFOR T691K ABSFO REF C CN
2 MCVBAPB ABGRS TKKAA ABGSL    
3 MCVBAPB ABGRU TVAG ABGRU    
4 MCVBAPB ABTNR TSAB ABTNR    
5 MCVBAPB AKTHE TWAT AKTHE    
6 MCVBAPB AKTYP TWTY AKTYP    
7 MCVBAPB AUFNR AUFK AUFNR    
8 MCVBAPB BEDAE T459A BEDAE    
9 MCVBAPB BONUS TVBO BONUS    
10 MCVBAPB BWSCL TMBW1 BWSCL    
11 MCVBAPB BWTAR T149D BWTAR    
12 MCVBAPB BWVOR T6WP1 BWVOR    
13 MCVBAPB CHARG MCHA CHARG    
14 MCVBAPB CLINT KLAH CLINT KEY 1 CN
15 MCVBAPB DISPO T024D DISPO    
16 MCVBAPB EKGRP T024 EKGRP    
17 MCVBAPB EKORG T024E EKORG    
18 MCVBAPB EKSGB T026 EKSGB    
19 MCVBAPB EXART T605 EXART REF 1 CN
20 MCVBAPB FAKSP TVFS FAKSP    
21 MCVBAPB FERC_IND FERC_C7 IND REF    
22 MCVBAPB GEWEHL T006 MSEHI    
23 MCVBAPB GEWEI T006 MSEHI    
24 MCVBAPB GSBER TGSB GSBER    
25 MCVBAPB J_1BCFOP J_1BAG CFOP KEY 1 CN
26 MCVBAPB J_1BTAXLW1 J_1BATL1 TAXLAW C CN
27 MCVBAPB J_1BTAXLW2 J_1BATL2 TAXLAW C CN
28 MCVBAPB J_1BTAXLW3 J_1BATL3 TAXLAW C CN
29 MCVBAPB J_1BTAXLW4 J_1BATL4A TAXLAW KEY 1 CN
30 MCVBAPB J_1BTAXLW5 J_1BATL5 TAXLAW KEY 1 CN
31 MCVBAPB J_1BTXSDC J_1BTXSDC TAXCODE C CN
32 MCVBAPB KALSM_K T683 KALSM 1 CN
33 MCVBAPB KALVAR TCK03 KLVAR REF 1 CN
34 MCVBAPB KMEIN T006 MSEHI    
35 MCVBAPB KNTTP T163K KNTTP    
36 MCVBAPB KNUMA_AG KONA KNUMA C CN
37 MCVBAPB KNUMA_PI KONA KNUMA C CN
38 MCVBAPB KONDM T178 KONDM    
39 MCVBAPB KOSCH T190S KOSCH KEY 1 CN
40 MCVBAPB KTGRM TVKM KTGRM    
41 MCVBAPB LAND1 T005 LAND1    
42 MCVBAPB LGNUM T300 LGNUM    
43 MCVBAPB LGORT T001L LGORT    
44 MCVBAPB LIFNR LFA1 LIFNR    
45 MCVBAPB LPRIO TPRIO LPRIO    
46 MCVBAPB LTSNR WYT1 LTSNR    
47 MCVBAPB MAGRV TVEGR MAGRV    
48 MCVBAPB MANDT T000 MANDT    
49 MCVBAPB MATKL T023 MATKL    
50 MCVBAPB MATNR MARA MATNR    
51 MCVBAPB MATWA MARA MATNR    
52 MCVBAPB MEINS T006 MSEHI    
53 MCVBAPB MFRGR TMFG MFRGR KEY 1 CN
54 MCVBAPB MSR_REFUND_CODE MSR_C_RET_REFUND RETURNS_REFUND 1 CN
55 MCVBAPB MSR_RET_REASON MSR_C_RET_REASON RET_REASON 1 CN
56 MCVBAPB MTART T134 MTART    
57 MCVBAPB MTVFP TMVF MTVFP    
58 MCVBAPB MVGR1 TVM1 MVGR1    
59 MCVBAPB MVGR2 TVM2 MVGR2    
60 MCVBAPB MVGR3 TVM3 MVGR3    
61 MCVBAPB MVGR4 TVM4 MVGR4    
62 MCVBAPB MVGR5 TVM5 MVGR5    
63 MCVBAPB OBJNR ONR00 OBJNR    
64 MCVBAPB PLAVO TVZP PLAVO KEY 1 CN
65 MCVBAPB PLGTP TWPT PLGTP    
66 MCVBAPB PLGTYP T301 LGTYP    
67 MCVBAPB PMATN MARA MATNR    
68 MCVBAPB POSNR VBUP POSNR    
69 MCVBAPB POSNV VBUP POSNR    
70 MCVBAPB PRBME T006 MSEHI    
71 MCVBAPB PRDHA T179 PRODH    
72 MCVBAPB PRODH T179 PRODH    
73 MCVBAPB PROVG TVPR PROVG    
74 MCVBAPB PSTYV TVPT PSTYV    
75 MCVBAPB PS_PSP_PNR PRPS PSPNR REF C CN
76 MCVBAPB ROUTE TVRO ROUTE    
77 MCVBAPB SAISO T6WSP SAISO    
78 MCVBAPB SATNR MARA MATNR    
79 MCVBAPB SBZIRK T171 BZIRK    
80 MCVBAPB SERAIL T377P SERAIL    
81 MCVBAPB SERNR SNUM SERNR    
82 MCVBAPB SERVG TWSG SERVG    
83 MCVBAPB SKOPF WSOH SKOPF REF C CN
84 MCVBAPB SMATKL T023 MATKL    
85 MCVBAPB SOBKZ T148 SOBKZ    
86 MCVBAPB SPART TSPA SPART    
87 MCVBAPB STRNR MARA MATNR    
88 MCVBAPB SUGRD TVSU SUGRD    
89 MCVBAPB SVKORG TVKO VKORG    
90 MCVBAPB SVTWEG TVTW VTWEG    
91 MCVBAPB TIMEL TC37A KAPTPROG    
92 MCVBAPB UEPOS VBUP POSNR    
93 MCVBAPB UKONM T178 KONDM REF C CN
94 MCVBAPB UPMAT MARA MATNR REF C CN
95 MCVBAPB VBELN VBUK VBELN    
96 MCVBAPB VBELV VBUK VBELN    
97 MCVBAPB VGBEL VBUK VBELN    
98 MCVBAPB VGPOS VBUP POSNR    
99 MCVBAPB VHARTL TVTY TRATY    
100 MCVBAPB VKAUS TVLV ABRVW C CN
101 MCVBAPB VKGRU TVRMAVK VORGA KEY 1 CN
102 MCVBAPB VOLEH T006 MSEHI    
103 MCVBAPB VOLEHL T006 MSEHI    
104 MCVBAPB VPMAT MARA MATNR    
105 MCVBAPB VPWRK T001W WERKS    
106 MCVBAPB VRKME T006 MSEHI    
107 MCVBAPB VSTEL TVST VSTEL    
108 MCVBAPB WAERK TCURC WAERS    
109 MCVBAPB WERKS T001W WERKS    
110 MCVBAPB WKTNR VBUK VBELN REF C CN
111 MCVBAPB WKTPS VBUP POSNR REF C CN
112 MCVBAPB WKUNNR KNA1 KUNNR    
113 MCVBAPB ZIEME T006 MSEHI    
History
Last changed by/on SAP  20140121 
SAP Release Created in