SAP table MCMSEG (Document Segment: Material)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
LIFNR Vendor's account number CHAR 10 0 ELIFN
KUNNR Account number of customer CHAR 10 0 EKUNN
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
WAERS Local Currency CUKY 5 0 TCURC HWAER
XLABST Unrestricted-use stock CHAR 1 0 XLABST
XINSME Stock in Quality Inspection CHAR 1 0 XINSME
XKLABS Unrestricted-use consignment stock CHAR 1 0 XKLABS
XKINSM Quality inspection stock, consignment CHAR 1 0 XKINSM
XUMLME Stock in transfer at storage location level CHAR 1 0 XUMLME
XUMLMC Stock in transfer at plant level CHAR 1 0 XUMLMC
XMSQBO Material provided to vendor (in quality inspection) CHAR 1 0 XMSQBO
XMEIKS Blocked sales order stock CHAR 1 0 XMEIKS
XMEIKQ Sales order stock in quality inspection CHAR 1 0 XMEIKQ
XKSPEM Blocked consignment stock CHAR 1 0 XKSPEM
XSPEME Blocked Stock CHAR 1 0 XSPEME
XMKQKL Customer returnable packaging in quality inspection CHAR 1 0 XMKQKL
XMKQKK Consignment (at customer) in quality inspection CHAR 1 0 XMKQKK
XMSLBO Stock of material provided to vendor CHAR 1 0 XMSLBO
XMEIKL Sales order stock CHAR 1 0 XMEIKL
XMKUBL Stock of Material Provided by Customer CHAR 1 0 XMKUBL
XMKLKL Returnable packaging with customer CHAR 1 0 XMKLKL
XMKLKK Customer consignment CHAR 1 0 XMKLKK
XRETME Blocked Stock Returns CHAR 1 0 XRETME
XTRAME Stock in transit CHAR 1 0 XTRAME
XMSPRL Project stock, unrestricted-use CHAR 1 0 XMSPRL
XMSPRQ Project stock in quality inspection CHAR 1 0 XMSPRQ
XMSPRS Project stock, blocked CHAR 1 0 XMSPRS
XEINME Restricted-use stock CHAR 1 0 XEINME
XMTVLA Returnable transport packaging, unrestricted-use stock CHAR 1 0 XMTVLA
XMTVQU Returnable transport packaging, in QI CHAR 1 0 XMTVQU
XMTVSP Returnable transport packaging, blocked stock CHAR 1 0 XMTVSP
XMTVEI Returnable transport packaging, restricted-use stock CHAR 1 0 XMTVEI
XMSPRE Project stock, restricted-use CHAR 1 0 XMSPRE
XMEIKE Sales order, restricted-use stock CHAR 1 0 XMEIKE
XMKEKK Consignment at customer, restricted-use stock CHAR 1 0 XMKEKK
XMKEKL Returnable packaging at customer, restricted-use stock CHAR 1 0 XMKEKL
XMSEBO Material provided to vendor, restricted-use stock CHAR 1 0 XMSEBO
XKEINM Consignment, restricted-use stock CHAR 1 0 XKEINM
XGLGMG Tied Empties Stock CHAR 1 0 XGLGMG
BSTTYP Stock categories in the Logistics Information System CHAR 1 0 BSTTYP
Valuated Stock
B Customer Stock
E Sales Order Stock
K Vendor Consignment
M Returnable Transport Packaging
Q Project Stock
R Blocked Stock Returns
T Issuing Stock in Transit
U Non-Valuated Stock
V Consumption
BSTAUS Stock Values in the Logistics Information System CHAR 1 0 BSTAUS
Not Defined
A Unrestricted Use
B Quality Inspection
C Blocked Stock Returns
D Blocked Stock
E Restricted-Use
F Stock Transfer
G Material Provided By Customer
H Transit
K Customer Consignment, Unrestricted Use
L Customer Consignment in Quality Inspection
M Customer Consignment, Restricted Use
N Customer Returnable Packaging, Unrestricted Use
O Customer Returnable Packaging in Quality Inspection
P Customer Returnable Packaging, Restricted Use
Q Unrestricted-Use Material(s) Provided to Vendor
R Materials Provided to Vendor in Quality Inspection
S Stock of Material Provided to Vendor, Restricted Use
T Tied Empties
U Stock in Transfer for Subcontracting (Plant to Plant)
V Consumption
W Valuated Goods Receipt Blocked Stock
X Stock in Transfer for Customer Consignment (Plant to Plant)
XSATRA Stock in transit CHAR 1 0 XTRAME
XSQTRA Stock in transit CHAR 1 0 XTRAME
XBWESB Valuated Goods Receipt Blocked Stock CHAR 1 0 XBWESB
XLBUML Stock in Transfer for Subcontracting (Plant to Plant) CHAR 1 0 XLBUML
XKUUML Stock in Transfer for Customer Consignment (Plant to Plant) CHAR 1 0 XKUUML
XCWESB Valuated Goods Receipt Blocked Stock, Batch CHAR 1 0 XCWESB
XEWESB Valuated Goods Received Blocked Stock, SD, Batch CHAR 1 0 XEWESB
XQWESB Valuated Goods Receipt Blocked Stock, Project, Batch CHAR 1 0 XQWESB
XSABWE Valuated Goods Receipt Blocked Stock Sales Order CHAR 1 0 XSABWE
XSQBWE Valuated Goods Receipt Blocked Stock Project CHAR 1 0 XSQBWE
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
KDAUF Sales Order Number CHAR 10 0 VBUK KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
MENGE Quantity QUAN 15 3 MC_MENG
DMBTR Amount in local currency CURR 15 2 MC_DMBTR
BNBTR Delivery costs in local currency CURR 15 2 MC_BNBTR
WEMPF Goods Recipient CHAR 12 0 WEMPF
ABLAD Unloading Point CHAR 25 0 ABLAD
GSBER Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
RSNUM Number of reservation/dependent requirements NUMC 10 0 * RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
PALAN WMS Number of pallets DEC 11 0 PALAN
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
KSTRG Cost Object CHAR 12 0 * KSTRG
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
KZZUG Receipt Indicator CHAR 1 0 KZZUG
Normal receipt
L Tied empties
X Stock transport order
MENGU Quantity Updating in Material Master Record CHAR 1 0 MENGU
WERTU Value Updating in Material Master Record CHAR 1 0 WERTU
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
SYDAT System Date DATS 8 0 SYDATUM
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
DMBUM Revaluation amount on back-posting to a previous period CURR 13 2 DMBUM
SHKUM Debit/credit indicator in revaluation CHAR 1 0 SHKUM
UMMAT Receiving/Issuing Material CHAR 40 0 MARA UMMAT
UMWRK Receiving plant/issuing plant CHAR 4 0 T001W UMWRK
UMLGO Receiving/issuing storage location CHAR 4 0 T001L UMLGO
UMCHA Receiving/Issuing Batch CHAR 10 0 MCHA UMCHA
VKWRT Value at Sales Prices Including Value-Added Tax CURR 13 2 VKWRT
AKTNR Promotion CHAR 10 0 * WAKTION
XINVB Generate physical inventory document for material doc. item CHAR 1 0 XINVB
VGART Transaction/Event Type CHAR 2 0 * VGART
GRUND Reason for goods movment NUMC 4 0 MB_GRUND
MATBF Material in Respect of Which Stock is Managed CHAR 40 0 * MATBF
XSTOR Reversal, return delivery, or transfer posting CHAR 1 0 KZSTO
Neither return delivery nor reversal
1 Return deliv.(qty can be entered; no gener.of matchcode)
2 Reversal(qty cannot be entered; gener.of matchcode)
3 Transfer posting (qty can be entered; no gener.of matchcode)
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
UMMAB Receiving/Issuing Material CHAR 40 0 * UMMAT
VKMWS Tax on sales/purchases code CHAR 2 0 * MWSKZ
SGTXT Item Text CHAR 50 0 SGTXT
APLZL Internal counter NUMC 8 0 CIM_COUNT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
MGVBR Total usage quantity QUAN 15 3 GVBRM
MUVBR Unplanned usage quantity QUAN 15 3 UVBRM
MZUBB Valuated stock receipts quantity QUAN 15 3 MZUBB
MZUKB Consignment stock receipts quantity QUAN 15 3 MZUKB
MAGBB Quantity of valuated stock issues QUAN 15 3 MAGBB
MAGKB Quantity of consignment stock that has been issued QUAN 15 3 MAGKB
WZUBB Valuated stock receipts value CURR 15 2 WZUBB
WAGBB Value of valuated stock that has been issued CURR 15 2 WAGBB
WGVBR Total usage value CURR 15 2 WGVBR
WUVBR Unplanned usage value CURR 15 2 WUVBR
BVKON Change in stock level of consignment stock QUAN 15 3 BVKON
BVBEW Change in valuated stock level QUAN 15 3 BVBEW
BWERTV Change in value of valuated stock CURR 15 2 BWERTV
WAGINV Value of a goods issue from Invoice Verification/Revaluation CURR 15 2 WAGINV
WZUINV Value of goods receipt from invoice verification/revaluation CURR 15 2 WZUINV
BWERTVINV Value of a stock level change from Invoice Verification CURR 15 2 BWERTVINV
PRLABZU Receipt Quantity of Unrestricted Project Stock QUAN 15 3 MC_PRLABZU
PRLABAG Issue Quantity of Unrestricted Project Stock QUAN 15 3 MC_PRLABAG
PRINSZU Receipt Quantity of Project Stock in Quality Inspection QUAN 15 3 MC_PRINSZU
PRINSAG Project Stock Issue Quantity in Quality Inspection QUAN 15 3 MC_PRINSAG
PRSPEZU Receipt Quantity of Blocked Project Stock QUAN 15 3 MC_PRSPEZU
PRSPEAG Issue Quantity of Blocked Project Stock QUAN 15 3 MC_PRSPEAG
PREINZU Restricted Use Project Stock Receipt QUAN 15 3 MC_PREINZU
PREINAG Restricted Use Project Stock Issue QUAN 15 3 MC_PREINAG
KALABZU Receipt of Available Sales Order Stock QUAN 15 3 MC_KALABZU
KALABAG Issue of Available Sales Order Stock QUAN 15 3 MC_KALABAG
KAINSZU Receipt of sales order stock in quality assurance QUAN 15 3 MC_KAINSZU
KAINSAG Issue of sales order stock in quality assurance QUAN 15 3 MC_KAINSAG
KASPEZU Receipt of Blocked Sales Order Stock QUAN 15 3 MC_KASPEZU
KASPEAG Issue of Blocked Sales Order Stock QUAN 15 3 MC_KASPEAG
KAEINZU Receipt of Restricted-Use Customer Stock QUAN 15 3 MC_KAEINZU
KAEINAG Issue of Restricted-Use Customer Stock QUAN 15 3 MC_KAEINAG
MTV_LZU Receipt of Unrestricted Returnable Transport Packaging QUAN 15 3 MC_MTV_LZU
MTV_LAG Issue of Unrestricted Returnable Transport Packaging QUAN 15 3 MC_MTV_LAG
MTV_IZU Receipt of Returnable Transport Packaging in Qty Inspection QUAN 15 3 MC_MTV_IZU
MTV_IAG Issue of Restricted Returnable Transport Packaging in QI QUAN 15 3 MC_MTV_IAG
MTV_SZU Receipt of Blocked Returnable Transport Packaging QUAN 15 3 MC_MTV_SZU
MTV_SAG Issue of Blocked Returnable Transport Packaging QUAN 15 3 MC_MTV_SAG
MTV_EZU Receipt of Restricted Returnable Transport Packaging QUAN 15 3 MC_MTV_EZU
MTV_EAG Issue of Restricted Returnable Transport Packaging QUAN 15 3 MC_MTV_EAG
MZUPR Project Stock Receipt Quantity QUAN 15 3 MC_MZUPR
MAGPR Quantity Issued, Project Stock QUAN 15 3 MC_MAGPR
MZUKA Receipt Quantity of Sales Order Stock QUAN 15 3 MC_MZUKA
MAGKA Quantity Issued, Sales Order Stock QUAN 15 3 MC_MAGKA
MZUMTV Receipt Quantity of Returnable Transport Packaging QUAN 15 3 MC_MZUMTV
MAGMTV Quantity Issued, Returnable Transport Packaging QUAN 15 3 MC_MAGMTV
WZUPR Project Stock Receipt Value CURR 15 2 MC_WZUPR
WAGPR Issue Value of Project Stock CURR 15 2 MC_WAGPR
WZUKA Receipt Value of Sales Order Stock CURR 15 2 MC_WZUKA
WAGKA Sales Order Stock Issue Value CURR 15 2 MC_WAGKA
BVKA Change in Stock Sales Order Stock QUAN 15 3 MC_BVKA
BVPR Stock Change Project Stock QUAN 15 3 MC_BVPR
BWERTVKA Value Change Sales Order Stock CURR 15 2 MC_BWERTVKA
BWERTVPR Value Change Project Stock CURR 15 2 MC_BWERTVPR
SUPKZ Statistics update indicator (post in/post out) CHAR 1 0 SUPKZ
0 Returns item in standard order (SD only)
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
UPDKZ Single-Character Flag CHAR 1 0 CHAR1
XSTBW Reversal movement type CHAR 1 0 XSTBW
NEUAUF_BEW Indicator: Statistical setup - Inventory Controlling CHAR 1 0 NEUAUF_BEW
STGRP1 Statistics group 1 for evaluating movement type in LIS CHAR 4 0 STGRP1
STGRP2 Statistics group 2 for evaluating movement type in LIS CHAR 4 0 STGRP2
STGRP3 Statistics group 3 for evaluating movement type in LIS CHAR 4 0 STGRP3
STGRP4 Statistics group 4 for evaluating movement type in LIS CHAR 4 0 STGRP4
UMLKZ Indicator: Movement type is stock transfer CHAR 1 0 UMLKZ
RETKZ Indicator: Return from call CHAR 1 0 RETKZ
INVKZ Indicator: Movement type is physical inventory CHAR 1 0 INVKZ
KORR Indicator: Movement type is inventory correction CHAR 1 0 KORR
XUMBEW Revaluation CHAR 1 0 XUMBW
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
GJAHR Fiscal Year NUMC 4 0 GJAHR
SAKTO G/L Account Number CHAR 10 0 SAKNR
BKLAS Valuation Class CHAR 4 0 T025 BKLAS
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BWKEY Valuation area CHAR 4 0 * BWKEY
XRUEB Indicator: Document Is Posted to a Previous Period CHAR 1 0 XRUEB
GLVOR Business Transaction CHAR 4 0 GLVOR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
BZIRK Sales District CHAR 6 0 T171 BZIRK
EKSGB Purchasing area CHAR 4 0 T026 EKSGB
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
DISPO MRP Controller CHAR 3 0 T024D DISPO
LTSNR Supplier Subrange CHAR 6 0 WYT1 LTSNR
BTRKZ Plant category CHAR 1 0 VLFKZ
A Store
B Distribution Center
ABTNR Department number CHAR 4 0 TSAB ABTNR
WGRU2 Material group hierarchy 2 CHAR 18 0 MCW_WGRU2
WGRU1 Material group hierarchy 1 CHAR 18 0 MCW_WGRU1
MATKL Material Group CHAR 9 0 T023 MATKL
PRDHA Product hierarchy CHAR 18 0 T179 PRODH_D
SATNR Cross-Plant Configurable Material CHAR 40 0 MARA SATNR
MERK1 Characteristic 1 CHAR 70 0 MCW_MERK1
MERK2 Characteristic 2 CHAR 70 0 MCW_MERK2
MERK3 Characteristic 3 CHAR 70 0 MCW_MERK3
AKTYP Promotion Category CHAR 4 0 TWTY W_AKTYP
AKTHE Promotion theme CHAR 4 0 TWAT W_AKTHE
PLGTP Price Band Category CHAR 2 0 TWPT PLGTP
SAISO Season Category CHAR 4 0 T6WSP SAISO
SAISJ Season Year CHAR 4 0 SAISJ
BWVOR Procurement rule CHAR 1 0 T6WP1 BWVOR
BWSCL Source of Supply CHAR 1 0 T6WP2 BWSCL
SERVG IS-R service level CHAR 1 0 TWSG W_SERVGRD
BRGEW Gross weight QUAN 13 3 BRGEW
NTGEW Net weight QUAN 13 3 NTGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 T006 VOLEH
LANDLF Country/Region of vendor CHAR 3 0 T005 MCW_LANDLF
RLIFN Account number of regular vendor CHAR 10 0 LFA1 MCW_RLIFN
LAND1 Country/Region of regular vendor CHAR 3 0 T005 MCW_LANDRL
RLTSNR Vendor sub-range at regular vendor CHAR 6 0 * MCW_LTSNR
RIDNLF Material number at regular vendor CHAR 35 0 MCW_IDNLF
RKOLIF Prior vendor of regular vendor CHAR 10 0 * MCW_KOLIF
MTART Material type CHAR 4 0 T134 MTART
WMAKG Material Type ID CHAR 1 0 WMAK
General material type
1 Material type for value-only materials
2 Material type for empties
3 Material type for catalog variants
4 Material type for perishables
5 Material type for additionals
6 Material type for coupons
WRKGR2 Plant group hierarchy 2 CHAR 18 0 MCW_WRKGR2
WRKGR1 Plant group hierarchy 1 CHAR 18 0 MCW_WRKGR1
VKWRA Value at Sales Prices Excluding Value Added Tax CURR 13 2 VKWRA
DPFLG Indicator: duplicated record CHAR 1 0 MCW_DPFLAG
ERFME Unit of entry UNIT 3 0 T006 ERFME
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
IDNLF Material Number Used by Supplier CHAR 35 0 IDNLF
KOLIF Prior Supplier CHAR 10 0 * KOLIF
ATINM1 Internal characteristic number, characteristic 1 NUMC 10 0 * MCW_ATINM1
ATINM2 Internal characteristic number, characteristic 2 NUMC 10 0 * MCW_ATINM2
ATINM3 Internal characteristic number, characteristic 3 NUMC 10 0 * MCW_ATINM3
STRNR Structured material CHAR 40 0 MARA STRNR
WKUNNR Customer Number of Plant CHAR 10 0 KNA1 KUNNR_WK
SSTUF Assortment grade CHAR 2 0 TWSS SSTUF
ZUGMNG Receipts quantity in BUn QUAN 15 3 MCW_ZUGMNG
ZUGGEO Receipts at cost CURR 19 2 MCW_ZUGGEO
ZUGGVO Receipts at retail CURR 19 2 MCW_ZUGGVO
ZUGGVP Receipts at retail with tax CURR 19 2 MCW_ZUGGVP
ZUGGEW Receipts weight QUAN 15 3 MCW_ZUGGEW
ZUGVOL Receipts volume QUAN 15 3 MCW_ZUGVOL
ABGMNG Issues quantity in BUn QUAN 15 3 MCW_ABGMNG
ABGGEO Issues at cost CURR 19 2 MCW_ABGGEO
ABGGVO Issues at retail CURR 19 2 MCW_ABGGVO
ABGGVP Issues at retail with tax CURR 19 2 MCW_ABGGVP
ABGGEW Issues weight QUAN 15 3 MCW_ABGGEW
ABGVOL Issues volume QUAN 15 3 MCW_ABGVOL
WESMNG Goods receipt (vendor) quantity in BUn QUAN 15 3 MCW_WESMNG
WESGEO Goods receipt (vendor) at cost CURR 19 2 MCW_WESGEO
WESGVO Goods receipt (vendor) at retail CURR 19 2 MCW_WESGVO
WESGVP Goods receipt (vendor) at retail with tax CURR 19 2 MCW_WESGVP
WESGEW Goods receipt (vendor) weight QUAN 15 3 MCW_WESGEW
WESVOL Goods receipt (vendor) volume QUAN 15 3 MCW_WESVOL
RTEMNG Returns to vendor quantity in base unit of measure QUAN 15 3 MCW_RTEMNG
RTEGEO Returns to vendor at cost CURR 19 2 MCW_RTEGEO
RTEGVO Returns to vendor at retail CURR 19 2 MCW_RTEGVO
RTEGVP Returns to vendor at retail with tax CURR 19 2 MCW_RTEGVP
RTEGEW Returns to vendor weight QUAN 15 3 MCW_RTEGEW
RTEVOL Returns to vendor volume QUAN 15 3 MCW_RTEVOL
ULEMNG Goods clearing: receipts quantity in BUn QUAN 15 3 MCW_ULEMNG
ULEGEO Goods clearing: receipts at cost CURR 19 2 MCW_ULEGEO
ULEGVO Goods clearing: receipts at retail CURR 19 2 MCW_ULEGVO
ULEGVP Goods clearing: receipts at retail with tax CURR 19 2 MCW_ULEGVP
ULEGEW Goods clearing: receipts weight QUAN 15 3 MCW_ULEGEW
ULEVOL Goods clearing: receipts volume QUAN 15 3 MCW_ULEVOL
ULAMNG Goods clearing: issues quantity in BUn QUAN 15 3 MCW_ULAMNG
ULAGEO Goods clearing: issues at cost CURR 19 2 MCW_ULAGEO
ULAGVO Goods clearing: issues at retail CURR 19 2 MCW_ULAGVO
ULAGVP Goods clearing: issues at retail with tax CURR 19 2 MCW_ULAGVP
ULAGEW Goods clearing: issues weight QUAN 15 3 MCW_ULAGEW
ULAVOL Goods clearing: issues volume QUAN 15 3 MCW_ULAVOL
AUEMNG Material transfer: receipts quantity BUn QUAN 15 3 MCW_AUEMNG
AUEGEO Material transfer: receipts at cost CURR 19 2 MCW_AUEGEO
AUEGVO Material transfer: receipts at retail CURR 19 2 MCW_AUEGVO
AUEGVP Material transfer: receipts at retail with tax CURR 19 2 MCW_AUEGVP
AUEGEW Material transfer: receipts weight QUAN 15 3 MCW_AUEGEW
AUEVOL Material transfer: receipts volume QUAN 15 3 MCW_AUEVOL
AUAMNG Material transfer: issues quantity BUn QUAN 15 3 MCW_AUAMNG
AUAGEO Material transfer: issues at cost CURR 19 2 MCW_AUAGEO
AUAGVO Material transfer: issues at retail CURR 19 2 MCW_AUAGVO
AUAGVP Material transfer: issues at retail with tax CURR 19 2 MCW_AUAGVP
AUAGEW Material transfer: issues weight QUAN 15 3 MCW_AUAGEW
AUAVOL Material transfer: issues volume QUAN 15 3 MCW_AUAVOL
BKGRND Stock adjustment reason CHAR 1 0 MCW_BKGRND
BKPMNG Stock adjustment plus (quantity in BUn) QUAN 15 3 MCW_BKPMNG
BKPGEO Stock adjustment plus (cost) CURR 19 2 MCW_BKPGEO
BKPGVO Stock adjustment plus (retail) CURR 19 2 MCW_BKPGVO
BKPGVP Stock adjustment plus (retail with tax) CURR 19 2 MCW_BKPGVP
BKPGEW Stock adjustment plus (weight) QUAN 15 3 MCW_BKPGEW
BKPVOL Stock adjustment plus (volume) QUAN 15 3 MCW_BKPVOL
BKMMNG Stock adjustment minus (quantity in BUn) QUAN 15 3 MCW_BKMMNG
BKMGEO Stock adjustment minus (cost) CURR 19 2 MCW_BKMGEO
BKMGVO Stock adjustment minus (retail) CURR 19 2 MCW_BKMGVO
BKMGVP Stock adjustment minus (retail with tax) CURR 19 2 MCW_BKMGVP
BKMGEW Stock adjustment minus (weight) QUAN 15 3 MCW_BKMGEW
BKMVOL Stock adjustment minus (volume) QUAN 15 3 MCW_BKMVOL
KMEMNG Goods receipt (distribution center) quantity in BUn QUAN 15 3 MCW_KMEMNG
KMEGEO Goods receipt (DC) at cost CURR 19 2 MCW_KMEGEO
KMEGVO Goods receipt (DC) at retail CURR 19 2 MCW_KMEGVO
KMEGVP Goods receipt (dist. center) at retail with tax CURR 19 2 MCW_KMEGVP
KMEGEW Goods receipt (DC) weight QUAN 15 3 MCW_KMEGEW
KMEVOL Goods receipt (distribution center) volume QUAN 15 3 MCW_KMEVOL
KMAMNG Goods issue (distribution center) quantity in BUn QUAN 15 3 MCW_KMAMNG
KMAGEO Goods issue (DC) at cost CURR 19 2 MCW_KMAGEO
KMAGVO Goods issue (DC) at retail CURR 19 2 MCW_KMAGVO
KMAGVP Goods issue (dist. center) at retail with tax CURR 19 2 MCW_KMAGVP
KMAGEW Goods issue (DC) weight QUAN 15 3 MCW_KMAGEW
KMAVOL Goods issue (DC) volume QUAN 15 3 MCW_KMAVOL
PVGRND Reason for retail price change CHAR 4 0 TWBN PV_GRUND
UBPEPM Revaluation at cost, plus, quantity QUAN 15 3 MCW_UBPEPM
UBPGEO Revaluation at cost, plus CURR 19 2 MCW_UBPGEO
UBMEPM Revaluation at cost minus, quantity QUAN 15 3 MCW_UBMEPM
UBMGEO Revaluation at cost, minus CURR 19 2 MCW_UBMGEO
BIWMNG RIS/Reporting Server - Transfer base quantity QUAN 15 3 MCW_BIWMNG
BIWGEO RIS/Reporting Server - Transfer cost price CURR 19 2 MCW_BIWGEO
BIWGVO RIS/Reporting Server - Transfer retail price CURR 19 2 MCW_BIWGVO
BIWGVP RIS/Reporting Server - Transfer retail price with tax CURR 19 2 MCW_BIWGVP
BRELEV RIS/Reporting Server - stock relevance CHAR 1 0 MCW_BRELEV
1 Yes
2 No
ADDMNG Quantity of materials with additionals in base unit of meas. QUAN 15 3 MCW_ADDMNG
ADDANZ Number of affixed additionals INT4 10 0 MCW_ADDANZ
ADDTIM Processing time to affix the additionals DEC 17 5 MCW_ADDTIM
ADDKMW Material costs of additionals CURR 19 2 MCW_ADDKMW
ADDKAL Handling costs for additionals CURR 19 2 MCW_ADDKAL
ADDIAPPL Application for triggering follow-up actions for additionals CHAR 2 0 ADDI_APPL
01 Goods movement
02 Purchasing/purchase orders
03 Delivery
04 Sales order
09 Transport request
77 SAP Retail Store workbench
I1 Promotion (internal use only)
I2 Assortment list (internal use only)
I3 Change message (central printing; internal only)
I4 Manual request (internal use only)
I5 Automatic POs for additionals (internal use only)
I6 Request by BAPI
I7 IDoc request from deliveries transaction (VL71)
I8 Additionals monitor
I9 Retail pricing
ADDI1 Additional 1 CHAR 40 0 * MCW_ADDI1
ADDI2 Additional 2 CHAR 40 0 * MCW_ADDI2
ADDI3 Additional 3 CHAR 40 0 * MCW_ADDI3
BWVORG SAP BW transaction key NUMC 3 0 MCW_BWVORG
FILGRP Store Group NUMC 2 0 TWISPC_FILGRP WISP_FILGRP
PSWAE Database Currency for Planning Data in a Planning Scenario CUKY 5 0 TCURC WISP_PSWAE
PLMHT Planned Unit of Measure UNIT 3 0 T006 WISP_PLMHT
ASORT Assortment CHAR 10 0 WRS1 ASORT
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
/CWM/ERFMG Quantity in Parallel Unit of Entry QUAN 13 3 /CWM/ERFMG
/CWM/ERFME PUoM Entry Unit of Measure UNIT 3 0 * /CWM/ERFME
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_UMSEA_YR Receiving/Issuing Season Year CHAR 4 0 FSH_UMSEA_YR
FSH_UMSEA Receiving/Issuing Season CHAR 10 0 FSH_UMSEA
FSH_UMCOLL Receiving/Issuing Collection CHAR 10 0 * FSH_UMCOLL
FSH_UMTHEME Receiving/Issuing Theme CHAR 10 0 FSH_UMTHEME
FSH_DEALLOC_QTY ARun Allocated Quantity QUAN 13 3 FSH_ALLOC_QTY
J7LMENG1 Quantity in Derived Unit of Measure 1 REA QUAN 13 3 J_7LMENG1
J7LMENG2 Quantity in Derived Unit of Measure 2 REA QUAN 13 3 J_7LMENG2
J7LMENG3 Quantity in Derived Unit of Measure 3 REA QUAN 13 3 J_7LMENG3
J7LMENG4 Quantity in Derived Unit of Measure 4 REA QUAN 13 3 J_7LMENG4
J7LMNGP1 Proportional Quantity in Derived Unit of Measure 1 REA DEC 17 6 J_7LMNGP1
J7LMNGP2 Proportional Quantity in Derived Unit of Measure 2 REA DEC 17 6 J_7LMNGP2
J7LMNGP3 Proportional Quantity in Derived Unit of Measure 3 REA DEC 17 6 J_7LMNGP3
J7LMNGP4 Proportional Quantity in Derived Unit of Measure 4 REA DEC 17 6 J_7LMNGP4
J7LME1 REA Unit of Measure 1 UNIT 3 0 * J_7LME1
J7LME2 REA Unit of Measure 2 UNIT 3 0 * J_7LME2
J7LME3 REA Unit of Measure 3 UNIT 3 0 * J_7LME3
J7LME4 REA Unit of Measure 4 UNIT 3 0 * J_7LME4
BWAPPLNM Application Component CHAR 30 0 RSAPPLNM
BWMNG BW: Quantity in Base Unit of Measure QUAN 15 3 MCBW_MNG
BWGEO BW: Cost Value in Local Currency CURR 19 2 MCBW_GEO
BWGVO BW: Retail Value in Local Currency CURR 19 2 MCBW_GVO
BWGVP BW: Retail Value with Tax in Local Currency CURR 19 2 MCBW_GVP
BWBREL BW: Stock Relevance CHAR 1 0 MCBW_BREL
BWSWITCH Internal Usage: Rotate Values Yes = 'X', No ' '. CHAR 1 0 MCBW_SWITCH
BWCOUNTER BW: Unique Identification of Line Item NUMC 6 0 MCBW_COUNTER
BWPSPEX Work Breakdown Structure Element (External) CHAR 24 0 PS_PSPEX
IMATN FFF class CHAR 40 0 * IMATN
RELOC_ID Relocation ID CHAR 10 0 * /ISDFPS/RELOC_ID
RELOC_SEQ_ID Relocation Step ID CHAR 4 0 * /ISDFPS/RELOC_SEQ_ID
OBJID Object ID NUMC 8 0 * HROBJID
MPO_MATNR Material Number CHAR 40 0 MATNR
RIC Reportable Item Code CHAR 6 0 * /ISDFPS/RICODE
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BNFPO Item number of purchase requisition NUMC 5 0 * BNFPO
OPERATION_ID Operation/Exercise ID NUMC 8 0 * /ISDFPS/OPERATION_ID
CON_ID Contingent Key CHAR 5 0 /ISDFPS/CON_ID
OBJID_COM Object ID NUMC 8 0 * HROBJID
PROVIDER_MAT Object ID NUMC 8 0 * HROBJID
PROVIDER_PER Object ID NUMC 8 0 * HROBJID
PLANNING_GUID Planning GUID CHAR 32 0 /ISDFPS/PLANNING_GUID
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
SGT_UMSCAT Receiving/Issuing Stock Segment CHAR 40 0 SGT_UMSCAT
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
RMA_BWEXT_REL Relevant Valuation Method CHAR 1 0 WRMA_BWEXT_REL
All Valuation Methods
C Valuation at Cost Price
R Traditional Retail Valuation Method
RMA_LINKP Item from Corresponding Stock Removal NUMC 4 0 WRMA_LINKP
RMA_XCC Flag: Cross-Company Code Stock Transfer CHAR 1 0 WRMA_XCC
INVART Physical Inventory Type CHAR 1 0 INVART
Other Types of Physical Inventory
1 Cycle Count

MCMSEG foreign key relationships

Table Field Check Table Check Field
0 MCMSEG ABTNR TSAB Contact persons: standard departments MANDT
0 MCMSEG ABTNR TSAB Contact persons: standard departments ABTNR
1 MCMSEG AKTHE TWAT Promotion themes, IS-R MANDT
1 MCMSEG AKTHE TWAT Promotion themes, IS-R AKTHE
0 MCMSEG AKTYP TWTY Promotion category, IS-R MANDT
0 MCMSEG AKTYP TWTY Promotion category, IS-R AKTYP
1 MCMSEG ANLN1 ANLH Main asset number BUKRS
1 MCMSEG ANLN1 ANLH Main asset number ANLN1
0 MCMSEG ANLN2 ANLA Asset Master Record Segment BUKRS
0 MCMSEG ANLN2 ANLA Asset Master Record Segment ANLN1
0 MCMSEG ANLN2 ANLA Asset Master Record Segment ANLN2
1 MCMSEG ASORT WRS1 Assortment MANDT
1 MCMSEG ASORT WRS1 Assortment ASORT
0 MCMSEG AUFNR AUFK Order master data AUFNR
1 MCMSEG BKLAS T025 Valuation Classes MANDT
1 MCMSEG BKLAS T025 Valuation Classes BKLAS
0 MCMSEG BUKRS T001 Company Codes BUKRS
1 MCMSEG BWART T156 Movement Type MANDT
1 MCMSEG BWART T156 Movement Type BWART
0 MCMSEG BWSCL T6WP2 Check table, supply source keys (no longer used) MANDT
0 MCMSEG BWSCL T6WP2 Check table, supply source keys (no longer used) BWSCL
1 MCMSEG BWTAR T149D Global Valuation Types MANDT
1 MCMSEG BWTAR T149D Global Valuation Types BWTAR
0 MCMSEG BWVOR T6WP1 Check table, supply source entry MANDT
1 MCMSEG BZIRK T171 Customers: Sales Districts MANDT
1 MCMSEG BZIRK T171 Customers: Sales Districts BZIRK
0 MCMSEG CHARG MCHA Batches MANDT
0 MCMSEG CHARG MCHA Batches WERKS
0 MCMSEG CHARG MCHA Batches CHARG
1 MCMSEG DISPO T024D MRP Controllers MANDT
1 MCMSEG DISPO T024D MRP Controllers WERKS
1 MCMSEG DISPO T024D MRP Controllers DISPO
0 MCMSEG EBELP EKPO Purchasing Document Item MANDT
0 MCMSEG EBELP EKPO Purchasing Document Item EBELN
1 MCMSEG EKGRP T024 Purchasing Groups EKGRP
0 MCMSEG EKORG T024E Purchasing Organizations EKORG
1 MCMSEG EKSGB T026 Purchasing Area EKSGB
0 MCMSEG ERFME T006 Units of Measurement MANDT
1 MCMSEG FILGRP TWISPC_FILGRP Store Groups MANDT
0 MCMSEG GEWEI T006 Units of Measurement MANDT
0 MCMSEG GEWEI T006 Units of Measurement MSEHI
1 MCMSEG GSBER TGSB Business Areas MANDT
1 MCMSEG GSBER TGSB Business Areas GSBER
0 MCMSEG KDAUF VBUK Sales Document: Header Status and Administrative Data MANDT
0 MCMSEG KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
1 MCMSEG KOKRS TKA01 Controlling Areas MANDT
0 MCMSEG KOSTL CSKS Cost Center Master Record MANDT
0 MCMSEG KOSTL CSKS Cost Center Master Record KOKRS
0 MCMSEG KOSTL CSKS Cost Center Master Record KOSTL
0 MCMSEG KOSTL CSKS Cost Center Master Record DATBI
1 MCMSEG LAND1 T005 Countries MANDT
1 MCMSEG LAND1 T005 Countries LAND1
0 MCMSEG LANDLF T005 Countries MANDT
0 MCMSEG LANDLF T005 Countries LAND1
1 MCMSEG LGNUM T300 WM Warehouse Numbers MANDT
1 MCMSEG LGNUM T300 WM Warehouse Numbers LGNUM
0 MCMSEG LGORT T001L Storage Locations MANDT
0 MCMSEG LGORT T001L Storage Locations WERKS
1 MCMSEG LGPLA LAGP Storage bins MANDT
1 MCMSEG LGPLA LAGP Storage bins LGNUM
1 MCMSEG LGPLA LAGP Storage bins LGPLA
0 MCMSEG LGTYP T301 WM Storage Types MANDT
0 MCMSEG LGTYP T301 WM Storage Types LGNUM
0 MCMSEG LGTYP T301 WM Storage Types LGTYP
1 MCMSEG LTSNR WYT1 Vendor Subrange MANDT
1 MCMSEG LTSNR WYT1 Vendor Subrange LIFNR
1 MCMSEG LTSNR WYT1 Vendor Subrange LTSNR
0 MCMSEG MANDT T000 Clients MANDT
1 MCMSEG MATKL T023 Material Groups MATKL
0 MCMSEG MATNR MARA General Material Data MANDT
0 MCMSEG MATNR MARA General Material Data MATNR
1 MCMSEG MEINS T006 Units of Measurement MANDT
1 MCMSEG MEINS T006 Units of Measurement MSEHI
0 MCMSEG MTART T134 Material Types MANDT
0 MCMSEG MTART T134 Material Types MTART
1 MCMSEG NPLNR AUFK Order master data AUFNR
0 MCMSEG PLGTP TWPT Price band categories MANDT
0 MCMSEG PLGTP TWPT Price band categories PLGTP
1 MCMSEG PLMHT T006 Units of Measurement MANDT
1 MCMSEG PLMHT T006 Units of Measurement MSEHI
0 MCMSEG PRDHA T179 Materials: Product Hierarchies PRODH
1 MCMSEG PSWAE TCURC Currency Codes MANDT
1 MCMSEG PSWAE TCURC Currency Codes WAERS
0 MCMSEG PVGRND TWBN Reason for Price Change MANDT
0 MCMSEG PVGRND TWBN Reason for Price Change PV_GRUND
1 MCMSEG RLIFN LFA1 Supplier Master (General Section) MANDT
1 MCMSEG RLIFN LFA1 Supplier Master (General Section) LIFNR
0 MCMSEG SAISO T6WSP Check Table for Season Indicator MANDT
0 MCMSEG SAISO T6WSP Check Table for Season Indicator SAISO
1 MCMSEG SATNR MARA General Material Data MATNR
0 MCMSEG SERVG TWSG Service level IS-R (Info for assortment list) MANDT
1 MCMSEG SOBKZ T148 Special Stock Indicator MANDT
1 MCMSEG SOBKZ T148 Special Stock Indicator SOBKZ
0 MCMSEG SSTUF TWSS Assortment grade IS-R MANDT
0 MCMSEG SSTUF TWSS Assortment grade IS-R SSTUF
1 MCMSEG STRNR MARA General Material Data MANDT
1 MCMSEG STRNR MARA General Material Data MATNR
0 MCMSEG UMCHA MCHA Batches MANDT
0 MCMSEG UMCHA MCHA Batches WERKS
0 MCMSEG UMCHA MCHA Batches CHARG
1 MCMSEG UMLGO T001L Storage Locations MANDT
1 MCMSEG UMLGO T001L Storage Locations WERKS
0 MCMSEG UMMAT MARA General Material Data MANDT
0 MCMSEG UMMAT MARA General Material Data MATNR
1 MCMSEG UMWRK T001W Plants/Branches WERKS
0 MCMSEG VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 MCMSEG VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 MCMSEG VOLEH T006 Units of Measurement MANDT
1 MCMSEG VOLEH T006 Units of Measurement MSEHI
0 MCMSEG VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 MCMSEG VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 MCMSEG WAERS TCURC Currency Codes MANDT
1 MCMSEG WAERS TCURC Currency Codes WAERS
0 MCMSEG WERKS T001W Plants/Branches MANDT
0 MCMSEG WERKS T001W Plants/Branches WERKS
1 MCMSEG WKUNNR KNA1 General Data in Customer Master MANDT
1 MCMSEG WKUNNR KNA1 General Data in Customer Master KUNNR