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