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