SAP ABAP Table MCMSEG (Document Segment: Material)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MCB (Package) R/3 application development: Inventory Controlling
Basic Data
Table Category INTTAB    Structure 
Structure MCMSEG   Table Relationship Diagram
Short Description Document Segment: Material    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
3 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
4 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
5 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
6 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number *
7 KUNNR EKUNN KUNNR CHAR 10   0   Account number of customer *
8 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
9 WAERS HWAER WAERS CUKY 5   0   Local Currency TCURC
10 .INCLUDE       0   0   Stock Categories in Inventory Controlling  
11 XLABST XLABST XFELD CHAR 1   0   Unrestricted-use stock  
12 XINSME XINSME XFELD CHAR 1   0   Stock in Quality Inspection  
13 XKLABS XKLABS XFELD CHAR 1   0   Unrestricted-use consignment stock  
14 XKINSM XKINSM XFELD CHAR 1   0   Quality inspection stock, consignment  
15 XUMLME XUMLME XFELD CHAR 1   0   Stock in transfer at storage location level  
16 XUMLMC XUMLMC XFELD CHAR 1   0   Stock in transfer at plant level  
17 XMSQBO XMSQBO XFELD CHAR 1   0   Material provided to vendor (in quality inspection)  
18 XMEIKS XMEIKS XFELD CHAR 1   0   Blocked sales order stock  
19 XMEIKQ XMEIKQ XFELD CHAR 1   0   Sales order stock in quality inspection  
20 XKSPEM XKSPEM XFELD CHAR 1   0   Blocked consignment stock  
21 XSPEME XSPEME XFELD CHAR 1   0   Blocked Stock  
22 XMKQKL XMKQKL XFELD CHAR 1   0   Customer returnable packaging in quality inspection  
23 XMKQKK XMKQKK XFELD CHAR 1   0   Consignment (at customer) in quality inspection  
24 XMSLBO XMSLBO XFELD CHAR 1   0   Stock of material provided to vendor  
25 XMEIKL XMEIKL XFELD CHAR 1   0   Sales order stock  
26 XMKUBL XMKUBL XFELD CHAR 1   0   Stock of Material Provided by Customer  
27 XMKLKL XMKLKL XFELD CHAR 1   0   Returnable packaging with customer  
28 XMKLKK XMKLKK XFELD CHAR 1   0   Customer consignment  
29 XRETME XRETME XFELD CHAR 1   0   Blocked Stock Returns  
30 XTRAME XTRAME XFELD CHAR 1   0   Stock in transit  
31 XMSPRL XMSPRL XFELD CHAR 1   0   Project stock, unrestricted-use  
32 XMSPRQ XMSPRQ XFELD CHAR 1   0   Project stock in quality inspection  
33 XMSPRS XMSPRS XFELD CHAR 1   0   Project stock, blocked  
34 XEINME XEINME XFELD CHAR 1   0   Restricted-use stock  
35 XMTVLA XMTVLA XFELD CHAR 1   0   Returnable transport packaging, unrestricted-use stock  
36 XMTVQU XMTVQU XFELD CHAR 1   0   Returnable transport packaging, in QI  
37 XMTVSP XMTVSP XFELD CHAR 1   0   Returnable transport packaging, blocked stock  
38 XMTVEI XMTVEI XFELD CHAR 1   0   Returnable transport packaging, restricted-use stock  
39 XMSPRE XMSPRE XFELD CHAR 1   0   Project stock, restricted-use  
40 XMEIKE XMEIKE XFELD CHAR 1   0   Sales order, restricted-use stock  
41 XMKEKK XMKEKK XFELD CHAR 1   0   Consignment at customer, restricted-use stock  
42 XMKEKL XMKEKL XFELD CHAR 1   0   Returnable packaging at customer, restricted-use stock  
43 XMSEBO XMSEBO XFELD CHAR 1   0   Material provided to vendor, restricted-use stock  
44 XKEINM XKEINM XFELD CHAR 1   0   Consignment, restricted-use stock  
45 XGLGMG XGLGMG XFELD CHAR 1   0   Tied Empties Stock  
46 BSTTYP BSTTYP BSTTYP CHAR 1   0   Stock categories in the Logistics Information System  
47 BSTAUS BSTAUS BSTAUS CHAR 1   0   Stock Values in the Logistics Information System  
48 XSATRA XTRAME XFELD CHAR 1   0   Stock in transit  
49 XSQTRA XTRAME XFELD CHAR 1   0   Stock in transit  
50 XBWESB XBWESB XFELD CHAR 1   0   Valuated Goods Receipt Blocked Stock  
51 XLBUML XLBUML XFELD CHAR 1   0   Stock in Transfer for Subcontracting (Plant to Plant)  
52 XKUUML XKUUML XFELD CHAR 1   0   Stock in Transfer for Customer Consignment (Plant to Plant)  
53 XCWESB XCWESB XFELD CHAR 1   0   Valuated Goods Receipt Blocked Stock, Batch  
54 XEWESB XEWESB XFELD CHAR 1   0   Valuated Goods Received Blocked Stock, SD, Batch  
55 XQWESB XQWESB XFELD CHAR 1   0   Valuated Goods Receipt Blocked Stock, Project, Batch  
56 XSABWE XSABWE XFELD CHAR 1   0   Valuated Goods Receipt Blocked Stock Sales Order  
57 XSQBWE XSQBWE XFELD CHAR 1   0   Valuated Goods Receipt Blocked Stock Project  
58 .INCLUDE       0   0   Material Document Fields (MCPF, MSEG)  
59 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
60 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
61 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
62 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
63 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
64 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
65 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
66 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
67 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
68 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
69 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
70 MENGE MC_MENG MENGV15 QUAN 15   3   Quantity  
71 DMBTR MC_DMBTR WERT15 CURR 15   2   Amount in local currency  
72 BNBTR MC_BNBTR WERT15 CURR 15   2   Delivery costs in local currency  
73 WEMPF WEMPF WEMPF CHAR 12   0   Goods recipient  
74 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
75 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
76 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
77 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
78 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
79 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
80 ANLN2 ANLN2 ANLN2 CHAR 4   0   Asset Subnumber ANLA
81 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements *
82 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
83 KZEAR KZEAR XFELD CHAR 1   0   Final issue for this reservation  
84 WEUNB WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
85 PALAN PALAN PALAN DEC 11   0   WMS Number of pallets  
86 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
87 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
88 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
89 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object *
90 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
91 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
92 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
93 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment AUFK
94 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
95 KZZUG KZZUG KZZUG CHAR 1   0   Receipt indicator  
96 MENGU MENGU XFELD CHAR 1   0   Quantity Updating in Material Master Record  
97 WERTU WERTU XFELD CHAR 1   0   Value Updating in Material Master Record  
98 KZBEW KZBEW KZBEW CHAR 1   0   Movement Indicator  
99 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
100 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
101 SYDAT SYDATUM SYDATS DATS 8   0   System Date  
102 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
103 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
104 DMBUM DMBUM WERT7 CURR 13   2   Revaluation amount on back-posting to a previous period  
105 SHKUM SHKUM SHKZG CHAR 1   0   Debit/credit indicator in revaluation  
106 UMMAT UMMAT MATNR CHAR 18   0   Receiving/issuing material MARA
107 UMWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
108 UMLGO UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
109 UMCHA UMCHA CHARG CHAR 10   0   Receiving/issuing batch MCHA
110 VKWRT VKWRT WERT7 CURR 13   2   Value at sales prices including value-added tax  
111 AKTNR WAKTION WAKTION CHAR 10   0   Promotion *
112 XINVB XINVB XFELD CHAR 1   0   Generate physical inventory document for material doc. item  
113 VGART VGART VGART CHAR 2   0   Transaction/Event Type *
114 GRUND MB_GRUND NUMC4 NUMC 4   0   Reason for goods movment  
115 MATBF MATBF MATNR CHAR 18   0   Material in Respect of Which Stock is Managed *
116 XSTOR KZSTO KZSTO CHAR 1   0   Reversal, return delivery, or transfer posting  
117 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
118 UMMAB UMMAT MATNR CHAR 18   0   Receiving/issuing material *
119 VKMWS MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
120 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
121 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
122 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
123 .INCLUDE       0   0   Key Figures for Material Movements  
124 MGVBR GVBRM MENGV15 QUAN 15   3   Total usage quantity  
125 MUVBR UVBRM MENGV15 QUAN 15   3   Unplanned usage quantity  
126 MZUBB MZUBB MENGV15 QUAN 15   3   Valuated stock receipts quantity  
127 MZUKB MZUKB MENGV15 QUAN 15   3   Consignment stock receipts quantity  
128 MAGBB MAGBB MENGV15 QUAN 15   3   Quantity of valuated stock issues  
129 MAGKB MAGKB MENGV15 QUAN 15   3   Quantity of consignment stock that has been issued  
130 WZUBB WZUBB WERT15 CURR 15   2   Valuated stock receipts value  
131 WAGBB WAGBB WERT15 CURR 15   2   Value of valuated stock that has been issued  
132 WGVBR WGVBR WERT15 CURR 15   2   Total usage value  
133 WUVBR WUVBR WERT15 CURR 15   2   Unplanned usage value  
134 BVKON BVKON MENGV15 QUAN 15   3   Change in stock level of consignment stock  
135 BVBEW BVBEW MENGV15 QUAN 15   3   Change in valuated stock level  
136 BWERTV BWERTV WERT15 CURR 15   2   Change in value of valuated stock  
137 WAGINV WAGINV WERT15 CURR 15   2   Value of a goods issue from Invoice Verification/Revaluation  
138 WZUINV WZUINV WERT15 CURR 15   2   Value of goods receipt from invoice verification/revaluation  
139 BWERTVINV BWERTVINV WERT15 CURR 15   2   Value of a stock level change from Invoice Verification  
140 PRLABZU MC_PRLABZU MENGV15 QUAN 15   3   Receipt Quantity of Unrestricted Project Stock  
141 PRLABAG MC_PRLABAG MENGV15 QUAN 15   3   Issue Quantity of Unrestricted Project Stock  
142 PRINSZU MC_PRINSZU MENGV15 QUAN 15   3   Receipt Quantity of Project Stock in Quality Inspection  
143 PRINSAG MC_PRINSAG MENGV15 QUAN 15   3   Project Stock Issue Quantity in Quality Inspection  
144 PRSPEZU MC_PRSPEZU MENGV15 QUAN 15   3   Receipt Quantity of Blocked Project Stock  
145 PRSPEAG MC_PRSPEAG MENGV15 QUAN 15   3   Issue Quantity of Blocked Project Stock  
146 PREINZU MC_PREINZU MENGV15 QUAN 15   3   Restricted Use Project Stock Receipt  
147 PREINAG MC_PREINAG MENGV15 QUAN 15   3   Restricted Use Project Stock Issue  
148 KALABZU MC_KALABZU MENGV15 QUAN 15   3   Receipt of Available Sales Order Stock  
149 KALABAG MC_KALABAG MENGV15 QUAN 15   3   Issue of Available Sales Order Stock  
150 KAINSZU MC_KAINSZU MENGV15 QUAN 15   3   Receipt of sales order stock in quality assurance  
151 KAINSAG MC_KAINSAG MENGV15 QUAN 15   3   Issue of sales order stock in quality assurance  
152 KASPEZU MC_KASPEZU MENGV15 QUAN 15   3   Receipt of Blocked Sales Order Stock  
153 KASPEAG MC_KASPEAG MENGV15 QUAN 15   3   Issue of Blocked Sales Order Stock  
154 KAEINZU MC_KAEINZU MENGV15 QUAN 15   3   Receipt of Restricted-Use Customer Stock  
155 KAEINAG MC_KAEINAG MENGV15 QUAN 15   3   Issue of Restricted-Use Customer Stock  
156 MTV_LZU MC_MTV_LZU MENGV15 QUAN 15   3   Receipt of Unrestricted Returnable Transport Packaging  
157 MTV_LAG MC_MTV_LAG MENGV15 QUAN 15   3   Issue of Unrestricted Returnable Transport Packaging  
158 MTV_IZU MC_MTV_IZU MENGV15 QUAN 15   3   Receipt of Returnable Transport Packaging in Qty Inspection  
159 MTV_IAG MC_MTV_IAG MENGV15 QUAN 15   3   Issue of Restricted Returnable Transport Packaging in QI  
160 MTV_SZU MC_MTV_SZU MENGV15 QUAN 15   3   Receipt of Blocked Returnable Transport Packaging  
161 MTV_SAG MC_MTV_SAG MENGV15 QUAN 15   3   Issue of Blocked Returnable Transport Packaging  
162 MTV_EZU MC_MTV_EZU MENGV15 QUAN 15   3   Receipt of Restricted Returnable Transport Packaging  
163 MTV_EAG MC_MTV_EAG MENGV15 QUAN 15   3   Issue of Restricted Returnable Transport Packaging  
164 MZUPR MC_MZUPR MENGV15 QUAN 15   3   Project Stock Receipt Quantity  
165 MAGPR MC_MAGPR MENGV15 QUAN 15   3   Quantity Issued, Project Stock  
166 MZUKA MC_MZUKA MENGV15 QUAN 15   3   Receipt Quantity of Sales Order Stock  
167 MAGKA MC_MAGKA MENGV15 QUAN 15   3   Quantity Issued, Sales Order Stock  
168 MZUMTV MC_MZUMTV MENGV15 QUAN 15   3   Receipt Quantity of Returnable Transport Packaging  
169 MAGMTV MC_MAGMTV MENGV15 QUAN 15   3   Quantity Issued, Returnable Transport Packaging  
170 WZUPR MC_WZUPR WERT15 CURR 15   2   Project Stock Receipt Value  
171 WAGPR MC_WAGPR WERT15 CURR 15   2   Issue Value of Project Stock  
172 WZUKA MC_WZUKA WERT15 CURR 15   2   Receipt Value of Sales Order Stock  
173 WAGKA MC_WAGKA WERT15 CURR 15   2   Sales Order Stock Issue Value  
174 BVKA MC_BVKA MENGV15 QUAN 15   3   Change in Stock Sales Order Stock  
175 BVPR MC_BVPR MENGV15 QUAN 15   3   Stock Change Project Stock  
176 BWERTVKA MC_BWERTVKA WERT15 CURR 15   2   Value Change Sales Order Stock  
177 BWERTVPR MC_BWERTVPR WERT15 CURR 15   2   Value Change Project Stock  
178 .INCLUDE       0   0   Fields for Controlling Updating in INVCO  
179 SUPKZ SUPKZ SUPKZ CHAR 1   0   Statistics update indicator (post in/post out)  
180 UPDKZ CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
181 XSTBW XSTBW XFELD CHAR 1   0   Reversal transaction type  
182 NEUAUF_BEW NEUAUF_BEW CHAR1 CHAR 1   0   Indicator: Statistical setup - Inventory Controlling  
183 STGRP1 STGRP1 CHAR4 CHAR 4   0   Statistics group 1 for evaluating movement type in LIS  
184 STGRP2 STGRP2 CHAR4 CHAR 4   0   Statistics group 2 for evaluating movement type in LIS  
185 STGRP3 STGRP3 CHAR4 CHAR 4   0   Statistics group 3 for evaluating movement type in LIS  
186 STGRP4 STGRP4 CHAR4 CHAR 4   0   Statistics group 4 for evaluating movement type in LIS  
187 UMLKZ UMLKZ CHAR1 CHAR 1   0   Indicator: Movement type is stock transfer  
188 RETKZ RETKZ XFELD CHAR 1   0   Indicator: Return from call  
189 INVKZ INVKZ CHAR1 CHAR 1   0   Indicator: Movement type is physical inventory  
190 KORR KORR CHAR1 CHAR 1   0   Indicator: Movement type is inventory correction  
191 XUMBEW XUMBW XFELD CHAR 1   0   Revaluation  
192 XCHAR XCHAR XFELD CHAR 1   0   Batch management indicator (internal)  
193 .INCLUDE       0   0   Accounting Document Fields (BKPF, BSEG)  
194 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
195 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
196 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
197 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
198 SAKTO SAKNR SAKNR CHAR 10   0   G/L Account Number *
199 BKLAS BKLAS BKLAS CHAR 4   0   Valuation Class T025
200 KOART KOART KOART CHAR 1   0   Account type  
201 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area *
202 XRUEB XRUEB XFELD CHAR 1   0   Indicator: Document is posted to a previous period  
203 GLVOR GLVOR CHAR4 CHAR 4   0   Business Transaction  
204 .INCLUDE       0   0   IS-R Enhancements to MCMSEG  
205 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
206 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
207 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
208 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
209 EKSGB EKSGB EKSGB CHAR 4   0   Purchasing area T026
210 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group T024
211 DISPO DISPO DISPO CHAR 3   0   MRP controller T024D
212 LTSNR LTSNR LTSNR CHAR 6   0   Vendor Subrange WYT1
213 BTRKZ VLFKZ VLFKZ CHAR 1   0   Plant category  
214 ABTNR ABTNR ABTNR CHAR 4   0   Department number TSAB
215 WGRU2 MCW_WGRU2 KLASSE CHAR 18   0   Material group hierarchy 2  
216 WGRU1 MCW_WGRU1 KLASSE CHAR 18   0   Material group hierarchy 1  
217 MATKL MATKL MATKL CHAR 9   0   Material Group T023
218 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
219 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material MARA
220 MERK1 MCW_MERK1 ATWRT CHAR 30   0   Characteristic 1  
221 MERK2 MCW_MERK2 ATWRT CHAR 30   0   Characteristic 2  
222 MERK3 MCW_MERK3 ATWRT CHAR 30   0   Characteristic 3  
223 AKTYP W_AKTYP AKTTY CHAR 4   0   Promotion Category TWTY
224 AKTHE W_AKTHE THEMA CHAR 4   0   Promotion theme TWAT
225 PLGTP PLGTP PLGTP CHAR 2   0   Price band category TWPT
226 SAISO SAISO SAISO CHAR 4   0   Season Category T6WSP
227 SAISJ SAISJ CJAHR CHAR 4   0   Season Year  
228 BWVOR BWVOR BWVOR CHAR 1   0   Procurement rule T6WP1
229 BWSCL BWSCL BQSCL CHAR 1   0   Source of Supply T6WP2
230 SERVG W_SERVGRD W_SERVGRD CHAR 1   0   IS-R service level TWSG
231 BRGEW BRGEW MENG13 QUAN 13   3   Gross weight  
232 NTGEW NTGEW MENG13 QUAN 13   3   Net weight  
233 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
234 VOLUM VOLUM MENG13 QUAN 13   3   Volume  
235 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
236 LANDLF MCW_LANDLF LAND1 CHAR 3   0   Country of vendor T005
237 RLIFN MCW_RLIFN LIFNR CHAR 10   0   Account number of regular vendor LFA1
238 LAND1 MCW_LANDRL LAND1 CHAR 3   0   Country of regular vendor T005
239 RLTSNR MCW_LTSNR LTSNR CHAR 6   0   Vendor sub-range at regular vendor *
240 RIDNLF MCW_IDNLF IDNEX CHAR 35   0   Material number at regular vendor  
241 RKOLIF MCW_KOLIF LIFNR CHAR 10   0   Prior vendor of regular vendor *
242 MTART MTART MTART CHAR 4   0   Material type T134
243 WMAKG WMAK WMAK CHAR 1   0   Material type ID  
244 WRKGR2 MCW_WRKGR2 KLASSE CHAR 18   0   Plant group hierarchy 2  
245 WRKGR1 MCW_WRKGR1 KLASSE CHAR 18   0   Plant group hierarchy 1  
246 VKWRA VKWRA WERT7 CURR 13   2   Value at sales prices excluding value-added tax  
247 DPFLG MCW_DPFLAG XFELD CHAR 1   0   Indicator: duplicated record  
248 ERFME ERFME MEINS UNIT 3   0   Unit of entry T006
249 ERFMG ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
250 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
251 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
252 KOLIF KOLIF LIFNR CHAR 10   0   Prior Vendor *
253 ATINM1 MCW_ATINM1 ATINN NUMC 10   0   Internal characteristic number, characteristic 1 *
254 ATINM2 MCW_ATINM2 ATINN NUMC 10   0   Internal characteristic number, characteristic 2 *
255 ATINM3 MCW_ATINM3 ATINN NUMC 10   0   Internal characteristic number, characteristic 3 *
256 STRNR STRNR MATNR CHAR 18   0   Structured material MARA
257 WKUNNR KUNNR_WK KUNNR CHAR 10   0   Customer number of plant KNA1
258 SSTUF SSTUF SSTUF CHAR 2   0   Assortment grade TWSS
259 ZUGMNG MCW_ZUGMNG MENGV15_3 QUAN 15   3   Receipts quantity in BUn  
260 ZUGGEO MCW_ZUGGEO WERTV10 CURR 19   2   Receipts at cost  
261 ZUGGVO MCW_ZUGGVO WERTV10 CURR 19   2   Receipts at retail  
262 ZUGGVP MCW_ZUGGVP WERTV10 CURR 19   2   Receipts at retail with tax  
263 ZUGGEW MCW_ZUGGEW MENGV15_3 QUAN 15   3   Receipts weight  
264 ZUGVOL MCW_ZUGVOL MENGV15_3 QUAN 15   3   Receipts volume  
265 ABGMNG MCW_ABGMNG MENGV15_3 QUAN 15   3   Issues quantity in BUn  
266 ABGGEO MCW_ABGGEO WERTV10 CURR 19   2   Issues at cost  
267 ABGGVO MCW_ABGGVO WERTV10 CURR 19   2   Issues at retail  
268 ABGGVP MCW_ABGGVP WERTV10 CURR 19   2   Issues at retail with tax  
269 ABGGEW MCW_ABGGEW MENGV15_3 QUAN 15   3   Issues weight  
270 ABGVOL MCW_ABGVOL MENGV15_3 QUAN 15   3   Issues volume  
271 WESMNG MCW_WESMNG MENGV15_3 QUAN 15   3   Goods receipt (vendor) quantity in BUn  
272 WESGEO MCW_WESGEO WERTV10 CURR 19   2   Goods receipt (vendor) at cost  
273 WESGVO MCW_WESGVO WERTV10 CURR 19   2   Goods receipt (vendor) at retail  
274 WESGVP MCW_WESGVP WERTV10 CURR 19   2   Goods receipt (vendor) at retail with tax  
275 WESGEW MCW_WESGEW MENGV15_3 QUAN 15   3   Goods receipt (vendor) weight  
276 WESVOL MCW_WESVOL MENGV15_3 QUAN 15   3   Goods receipt (vendor) volume  
277 RTEMNG MCW_RTEMNG MENGV15_3 QUAN 15   3   Returns to vendor quantity in base unit of measure  
278 RTEGEO MCW_RTEGEO WERTV10 CURR 19   2   Returns to vendor at cost  
279 RTEGVO MCW_RTEGVO WERTV10 CURR 19   2   Returns to vendor at retail  
280 RTEGVP MCW_RTEGVP WERTV10 CURR 19   2   Returns to vendor at retail with tax  
281 RTEGEW MCW_RTEGEW MENGV15_3 QUAN 15   3   Returns to vendor weight  
282 RTEVOL MCW_RTEVOL MENGV15_3 QUAN 15   3   Returns to vendor volume  
283 ULEMNG MCW_ULEMNG MENGV15_3 QUAN 15   3   Goods clearing: receipts quantity in BUn  
284 ULEGEO MCW_ULEGEO WERTV10 CURR 19   2   Goods clearing: receipts at cost  
285 ULEGVO MCW_ULEGVO WERTV10 CURR 19   2   Goods clearing: receipts at retail  
286 ULEGVP MCW_ULEGVP WERTV10 CURR 19   2   Goods clearing: receipts at retail with tax  
287 ULEGEW MCW_ULEGEW MENGV15_3 QUAN 15   3   Goods clearing: receipts weight  
288 ULEVOL MCW_ULEVOL MENGV15_3 QUAN 15   3   Goods clearing: receipts volume  
289 ULAMNG MCW_ULAMNG MENGV15_3 QUAN 15   3   Goods clearing: issues quantity in BUn  
290 ULAGEO MCW_ULAGEO WERTV10 CURR 19   2   Goods clearing: issues at cost  
291 ULAGVO MCW_ULAGVO WERTV10 CURR 19   2   Goods clearing: issues at retail  
292 ULAGVP MCW_ULAGVP WERTV10 CURR 19   2   Goods clearing: issues at retail with tax  
293 ULAGEW MCW_ULAGEW MENGV15_3 QUAN 15   3   Goods clearing: issues weight  
294 ULAVOL MCW_ULAVOL MENGV15_3 QUAN 15   3   Goods clearing: issues volume  
295 AUEMNG MCW_AUEMNG MENGV15_3 QUAN 15   3   Material transfer: receipts quantity BUn  
296 AUEGEO MCW_AUEGEO WERTV10 CURR 19   2   Material transfer: receipts at cost  
297 AUEGVO MCW_AUEGVO WERTV10 CURR 19   2   Material transfer: receipts at retail  
298 AUEGVP MCW_AUEGVP WERTV10 CURR 19   2   Material transfer: receipts at retail with tax  
299 AUEGEW MCW_AUEGEW MENGV15_3 QUAN 15   3   Material transfer: receipts weight  
300 AUEVOL MCW_AUEVOL MENGV15_3 QUAN 15   3   Material transfer: receipts volume  
301 AUAMNG MCW_AUAMNG MENGV15_3 QUAN 15   3   Material transfer: issues quantity BUn  
302 AUAGEO MCW_AUAGEO WERTV10 CURR 19   2   Material transfer: issues at cost  
303 AUAGVO MCW_AUAGVO WERTV10 CURR 19   2   Material transfer: issues at retail  
304 AUAGVP MCW_AUAGVP WERTV10 CURR 19   2   Material transfer: issues at retail with tax  
305 AUAGEW MCW_AUAGEW MENGV15_3 QUAN 15   3   Material transfer: issues weight  
306 AUAVOL MCW_AUAVOL MENGV15_3 QUAN 15   3   Material transfer: issues volume  
307 BKGRND MCW_BKGRND MCW_CHAR01 CHAR 1   0   Stock adjustment reason  
308 BKPMNG MCW_BKPMNG MENGV15_3 QUAN 15   3   Stock adjustment plus (quantity in BUn)  
309 BKPGEO MCW_BKPGEO WERTV10 CURR 19   2   Stock adjustment plus (cost)  
310 BKPGVO MCW_BKPGVO WERTV10 CURR 19   2   Stock adjustment plus (retail)  
311 BKPGVP MCW_BKPGVP WERTV10 CURR 19   2   Stock adjustment plus (retail with tax)  
312 BKPGEW MCW_BKPGEW MENGV15_3 QUAN 15   3   Stock adjustment plus (weight)  
313 BKPVOL MCW_BKPVOL MENGV15_3 QUAN 15   3   Stock adjustment plus (volume)  
314 BKMMNG MCW_BKMMNG MENGV15_3 QUAN 15   3   Stock adjustment minus (quantity in BUn)  
315 BKMGEO MCW_BKMGEO WERTV10 CURR 19   2   Stock adjustment minus (cost)  
316 BKMGVO MCW_BKMGVO WERTV10 CURR 19   2   Stock adjustment minus (retail)  
317 BKMGVP MCW_BKMGVP WERTV10 CURR 19   2   Stock adjustment minus (retail with tax)  
318 BKMGEW MCW_BKMGEW MENGV15_3 QUAN 15   3   Stock adjustment minus (weight)  
319 BKMVOL MCW_BKMVOL MENGV15_3 QUAN 15   3   Stock adjustment minus (volume)  
320 KMEMNG MCW_KMEMNG MENGV15_3 QUAN 15   3   Goods receipt (distribution center) quantity in BUn  
321 KMEGEO MCW_KMEGEO WERTV10 CURR 19   2   Goods receipt (DC) at cost  
322 KMEGVO MCW_KMEGVO WERTV10 CURR 19   2   Goods receipt (DC) at retail  
323 KMEGVP MCW_KMEGVP WERTV10 CURR 19   2   Goods receipt (dist. center) at retail with tax  
324 KMEGEW MCW_KMEGEW MENGV15_3 QUAN 15   3   Goods receipt (DC) weight  
325 KMEVOL MCW_KMEVOL MENGV15_3 QUAN 15   3   Goods receipt (distribution center) volume  
326 KMAMNG MCW_KMAMNG MENGV15_3 QUAN 15   3   Goods issue (distribution center) quantity in BUn  
327 KMAGEO MCW_KMAGEO WERTV10 CURR 19   2   Goods issue (DC) at cost  
328 KMAGVO MCW_KMAGVO WERTV10 CURR 19   2   Goods issue (DC) at retail  
329 KMAGVP MCW_KMAGVP WERTV10 CURR 19   2   Goods issue (dist. center) at retail with tax  
330 KMAGEW MCW_KMAGEW MENGV15_3 QUAN 15   3   Goods issue (DC) weight  
331 KMAVOL MCW_KMAVOL MENGV15_3 QUAN 15   3   Goods issue (DC) volume  
332 PVGRND PV_GRUND PV_GRUND CHAR 4   0   Reason for retail price change TWBN
333 UBPEPM MCW_UBPEPM MENGV15_3 QUAN 15   3   Revaluation at cost, plus, quantity  
334 UBPGEO MCW_UBPGEO WERTV10 CURR 19   2   Revaluation at cost, plus  
335 UBMEPM MCW_UBMEPM MENGV15_3 QUAN 15   3   Revaluation at cost minus, quantity  
336 UBMGEO MCW_UBMGEO WERTV10 CURR 19   2   Revaluation at cost, minus  
337 BIWMNG MCW_BIWMNG MENGV15_3 QUAN 15   3   RIS/Reporting Server - Transfer base quantity  
338 BIWGEO MCW_BIWGEO WERTV10 CURR 19   2   RIS/Reporting Server - Transfer cost price  
339 BIWGVO MCW_BIWGVO WERTV10 CURR 19   2   RIS/Reporting Server - Transfer retail price  
340 BIWGVP MCW_BIWGVP WERTV10 CURR 19   2   RIS/Reporting Server - Transfer retail price with tax  
341 BRELEV MCW_BRELEV MCW_BRELEV CHAR 1   0   RIS/Reporting Server - stock relevance  
342 ADDMNG MCW_ADDMNG MENGV15_3 QUAN 15   3   Quantity of materials with additionals in base unit of meas.  
343 ADDANZ MCW_ADDANZ MCZAEHLINT INT4 10   0   Number of affixed additionals  
344 ADDTIM MCW_ADDTIM DEC17_5 DEC 17   5   Processing time to affix the additionals  
345 ADDKMW MCW_ADDKMW WERTV10 CURR 19   2   Material costs of additionals  
346 ADDKAL MCW_ADDKAL WERTV10 CURR 19   2   Handling costs for additionals  
347 ADDIAPPL ADDI_APPL ADDI_APPL CHAR 2   0   Application for triggering follow-up actions for additionals  
348 ADDI1 MCW_ADDI1 MATNR CHAR 18   0   Additional 1 *
349 ADDI2 MCW_ADDI2 MATNR CHAR 18   0   Additional 2 *
350 ADDI3 MCW_ADDI3 MATNR CHAR 18   0   Additional 3 *
351 BWVORG MCW_BWVORG NUM3 NUMC 3   0   SAP BW transaction key  
352 .INCLUDE       0   0   IS-R Enhancements to MCMSEG: Additional MAC Fields  
353 .INCLUDE       0   0   Characteristic Enhancement for MAC (all Comm. Structures)  
354 FILGRP WISP_FILGRP WISP_FILGRP NUMC 2   0   Store Group TWISPC_FILGRP
355 PSWAE WISP_PSWAE WAERS CUKY 5   0   Database Currency for Planning Data in a Planning Scenario TCURC
356 PLMHT WISP_PLMHT MEINS UNIT 3   0   Planned Unit of Measure T006
357 ASORT ASORT ASORT CHAR 10   0   Assortment WRS1
358 .INCLUDE       0   0   User Structure: Document Segment for Material  
359 DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
360 .INCLU--AP       0   0   REA Material Movement: Derivation of Qty for Dep. UoM  
361 J7LMENG1 J_7LMENG1 MENG13 QUAN 13   3   Quantity in Derived Unit of Measure 1 REA  
362 J7LMENG2 J_7LMENG2 MENG13 QUAN 13   3   Quantity in Derived Unit of Measure 2 REA  
363 J7LMENG3 J_7LMENG3 MENG13 QUAN 13   3   Quantity in Derived Unit of Measure 3 REA  
364 J7LMENG4 J_7LMENG4 MENG13 QUAN 13   3   Quantity in Derived Unit of Measure 4 REA  
365 J7LMNGP1 J_7LMNGP1 J_7LDEC DEC 17   6   Proportional Quantity in Derived Unit of Measure 1 REA  
366 J7LMNGP2 J_7LMNGP2 J_7LDEC DEC 17   6   Proportional Quantity in Derived Unit of Measure 2 REA  
367 J7LMNGP3 J_7LMNGP3 J_7LDEC DEC 17   6   Proportional Quantity in Derived Unit of Measure 3 REA  
368 J7LMNGP4 J_7LMNGP4 J_7LDEC DEC 17   6   Proportional Quantity in Derived Unit of Measure 4 REA  
369 J7LME1 J_7LME1 MEINS UNIT 3   0   REA Unit of Measure 1 *
370 J7LME2 J_7LME2 MEINS UNIT 3   0   REA Unit of Measure 2 *
371 J7LME3 J_7LME3 MEINS UNIT 3   0   REA Unit of Measure 3 *
372 J7LME4 J_7LME4 MEINS UNIT 3   0   REA Unit of Measure 4 *
373 .INCLU--AP       0   0   Append for BW Transfer  
374 .INCLUDE       0   0   Enhancement MCMSEG for BW Transfer  
375 BWAPPLNM RSAPPLNM RSAPPLNM CHAR 30   0   Application Component  
376 BWMNG MCBW_MNG MENGV15_3 QUAN 15   3   BW: Quantity in Base Unit of Measure  
377 BWGEO MCBW_GEO WERTV10 CURR 19   2   BW: Cost Value in Local Currency  
378 BWGVO MCBW_GVO WERTV10 CURR 19   2   BW: Retail Value in Local Currency  
379 BWGVP MCBW_GVP WERTV10 CURR 19   2   BW: Retail Value with Tax in Local Currency  
380 BWBREL MCBW_BREL MCBW_BREL CHAR 1   0   BW: Stock Relevance  
381 BWSWITCH MCBW_SWITCH AKTKN CHAR 1   0   Internal Usage: Rotate Values Yes = 'X', No ' '.  
382 BWCOUNTER MCBW_COUNTER MCBW_COUNTER NUMC 6   0   BW: Unique Identification of Line Item  
383 BWPSPEX PS_PSPEX PS_PSPEX CHAR 24   0   Work Breakdown Structure Element (External)  
384 .INCLU--AP       0   0   Append for Defense Forces & Public Security  
385 RELOC_ID /ISDFPS/RELOC_ID /ISDFPS/RELOC_ID CHAR 10   0   Relocation ID *
386 RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID CHAR 4   0   Relocation Step ID *
387 OBJID HROBJID HROBJID NUMC 8   0   Object ID *
388 MPO_MATNR MATNR MATNR CHAR 18   0   Material Number *
389 RIC /ISDFPS/RICODE /ISDFPS/RICODE CHAR 6   0   Reportable Item Code *
390 BANFN BANFN BANFN CHAR 10   0   Purchase requisition number  
391 BNFPO BNFPO BNFPO NUMC 5   0   Item number of purchase requisition *
392 OPERATION_ID /ISDFPS/OPERATION_ID HROBJID NUMC 8   0   Operation/Exercise ID *
393 CON_ID /ISDFPS/CON_ID /ISDFPS/CON_ID CHAR 5   0   Contingent Key  
394 OBJID_COM HROBJID HROBJID NUMC 8   0   Object ID *
395 PROVIDER_MAT HROBJID HROBJID NUMC 8   0   Object ID *
396 PROVIDER_PER HROBJID HROBJID NUMC 8   0   Object ID *
397 PLANNING_GUID /ISDFPS/PLANNING_GUID SYSUUID_C CHAR 32   0   Planning GUID  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MCMSEG ABTNR TSAB ABTNR    
2 MCMSEG AKTHE TWAT AKTHE    
3 MCMSEG AKTYP TWTY AKTYP    
4 MCMSEG ANLN1 ANLH ANLN1    
5 MCMSEG ANLN2 ANLA ANLN2    
6 MCMSEG ASORT WRS1 ASORT    
7 MCMSEG AUFNR AUFK AUFNR    
8 MCMSEG BKLAS T025 BKLAS    
9 MCMSEG BUKRS T001 BUKRS    
10 MCMSEG BWART T156 BWART    
11 MCMSEG BWSCL T6WP2 BWSCL    
12 MCMSEG BWTAR T149D BWTAR    
13 MCMSEG BWVOR T6WP1 BWVOR    
14 MCMSEG BZIRK T171 BZIRK    
15 MCMSEG CHARG MCHA CHARG    
16 MCMSEG DISPO T024D DISPO    
17 MCMSEG EBELP EKPO EBELP    
18 MCMSEG EKGRP T024 EKGRP    
19 MCMSEG EKORG T024E EKORG    
20 MCMSEG EKSGB T026 EKSGB    
21 MCMSEG ERFME T006 MSEHI    
22 MCMSEG FILGRP TWISPC_FILGRP FILGRP    
23 MCMSEG GEWEI T006 MSEHI    
24 MCMSEG GSBER TGSB GSBER    
25 MCMSEG KDAUF VBUK VBELN    
26 MCMSEG KOKRS TKA01 KOKRS    
27 MCMSEG KOSTL CSKS KOSTL    
28 MCMSEG LAND1 T005 LAND1    
29 MCMSEG LANDLF T005 LAND1    
30 MCMSEG LGNUM T300 LGNUM    
31 MCMSEG LGORT T001L LGORT    
32 MCMSEG LGPLA LAGP LGPLA    
33 MCMSEG LGTYP T301 LGTYP    
34 MCMSEG LTSNR WYT1 LTSNR    
35 MCMSEG MANDT T000 MANDT    
36 MCMSEG MATKL T023 MATKL    
37 MCMSEG MATNR MARA MATNR    
38 MCMSEG MEINS T006 MSEHI    
39 MCMSEG MTART T134 MTART    
40 MCMSEG NPLNR AUFK AUFNR    
41 MCMSEG PLGTP TWPT PLGTP    
42 MCMSEG PLMHT T006 MSEHI    
43 MCMSEG PRDHA T179 PRODH    
44 MCMSEG PSWAE TCURC WAERS    
45 MCMSEG PVGRND TWBN PV_GRUND    
46 MCMSEG RLIFN LFA1 LIFNR    
47 MCMSEG SAISO T6WSP SAISO    
48 MCMSEG SATNR MARA MATNR    
49 MCMSEG SERVG TWSG SERVG    
50 MCMSEG SOBKZ T148 SOBKZ    
51 MCMSEG SSTUF TWSS SSTUF    
52 MCMSEG STRNR MARA MATNR    
53 MCMSEG UMCHA MCHA CHARG    
54 MCMSEG UMLGO T001L LGORT    
55 MCMSEG UMMAT MARA MATNR    
56 MCMSEG UMWRK T001W WERKS    
57 MCMSEG VKORG TVKO VKORG    
58 MCMSEG VOLEH T006 MSEHI    
59 MCMSEG VTWEG TVTW VTWEG    
60 MCMSEG WAERS TCURC WAERS    
61 MCMSEG WERKS T001W WERKS    
62 MCMSEG WKUNNR KNA1 KUNNR    
History
Last changed by/on SAP  20130529 
SAP Release Created in