SAP table RM03M (Help Fields for Material Master Data Maintenance)

Field Description Data Type Length Decimals Checktable Data Element
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
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
MTART Material type CHAR 4 0 T134 MTART
MBRSH Industry Sector CHAR 1 0 T137 MBRSH
REF_MATNR Reference Material CHAR 40 0 MARA REF_MATNR
REF_WERKS Reference plant CHAR 4 0 T001W REF_WERKS
REF_LGORT Reference Storage Location CHAR 4 0 T001L REF_LGORT
REF_BWKEY Reference valuation area CHAR 4 0 T001K REF_BWKEY
REF_BWTAR Reference valuation type CHAR 10 0 T149D REF_BWTAR
REF_VKORG Reference sales organization CHAR 4 0 TVKO REF_VKORG
REF_VTWEG Reference distribution channel CHAR 2 0 TVTW REF_VTWEG
REF_LGNUM Reference warehouse number CHAR 3 0 T300 REF_LGNUM
REF_LGTYP Reference storage type CHAR 3 0 T301 REF_LGTYP
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
DISPR Material: MRP profile CHAR 4 0 MDIP DISPR
LVORM Deletion Indicator CHAR 1 0 LVORM
DYTX1 Screen description CHAR 20 0 DYTXT
DYTX2 Screen description CHAR 20 0 DYTXT
DYTX3 Screen description CHAR 20 0 DYTXT
VCTX1 Description of the change code CHAR 16 0 VCTXT_D
VCTX2 Description of the change code CHAR 16 0 VCTXT_D
VCTX3 Description of the change code CHAR 16 0 VCTXT_D
KZAU1 Selection indicator CHAR 1 0 KZSEL
KZAU2 Selection indicator CHAR 1 0 KZSEL
KZSE1 Selection indicator CHAR 1 0 KZSEL
KZSE2 Selection indicator CHAR 1 0 KZSEL
KZSE3 Selection indicator CHAR 1 0 KZSEL
KORFA Correction factor DEC 4 2 KORFA
PEINH Price unit DEC 5 0 PEINH
ANZ_WERKS1 Plant CHAR 4 0 T001W WERKS_D
ANZ_WERKS2 Plant CHAR 4 0 T001W WERKS_D
ANZ_LGORT1 Storage location CHAR 4 0 T001L LGORT_D
ANZ_LGORT2 Storage location CHAR 4 0 T001L LGORT_D
ANZ_BWKEY1 Valuation area CHAR 4 0 T001K BWKEY
ANZ_BWKEY2 Valuation area CHAR 4 0 T001K BWKEY
ANZ_BWTAR1 Valuation Type CHAR 10 0 T149D BWTAR_D
ANZ_BWTAR2 Valuation Type CHAR 10 0 T149D BWTAR_D
ANZ_VKORG1 Sales Organization CHAR 4 0 TVKO VKORG
ANZ_VKORG2 Sales Organization CHAR 4 0 TVKO VKORG
ANZ_VTWEG1 Distribution Channel CHAR 2 0 TVTW VTWEG
ANZ_VTWEG2 Distribution Channel CHAR 2 0 TVTW VTWEG
ANZ_LGNUM1 Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
ANZ_LGNUM2 Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
ANZ_LGTYP1 Storage Type CHAR 3 0 T301 LGTYP
ANZ_LGTYP2 Storage Type CHAR 3 0 T301 LGTYP
PSTAT1 Maintenance status CHAR 15 0 PSTAT_D
PSTAT2 Maintenance status CHAR 15 0 PSTAT_D
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
VMGJA Fiscal year of previous period NUMC 4 0 VMGJA
VMMON Month of previous period NUMC 2 0 VMMON
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
MEINH Base Unit of Measure UNIT 3 0 T006 MEINS
LFLAG List All Existing Storage Locations (Collective Entry) CHAR 1 0 LFLAG
NFLAG List Extendable Storage Locations Only (Collective Entry) CHAR 1 0 NFLAG
RLGOR Ref. Storage Location w/ Collective Entry of Stor. Locations CHAR 4 0 T001L RLGOR
DISKZ Storage location MRP indicator CHAR 1 0 DISKZ
Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
LSOBS Special procurement type at storage location level CHAR 2 0 T460A LSOBS
LMINB Reorder Point QUAN 13 3 MINBE
LBSTF Fixed lot size QUAN 13 3 BSTFE
LGPBE Storage Bin CHAR 10 0 LGPBE
VTLAG Indicator: distribution warehouse CHAR 1 0 VTLAG
TEXT1 Text CHAR 50 0 TEXT1
TEXT2 Text CHAR 50 0 TEXT1
SPRAS Language Key LANG 1 0 T002 SPRAS
LTEX1 Long Text CHAR 40 0 LTEXT
LTEX2 Long Text CHAR 40 0 LTEXT
LTEX3 Long Text CHAR 40 0 LTEXT
LTEX4 Long Text CHAR 40 0 LTEXT
LTEX5 Long Text CHAR 40 0 LTEXT
LTEX6 Long Text CHAR 40 0 LTEXT
LTEX7 Long Text CHAR 40 0 LTEXT
LTEX8 Long Text CHAR 40 0 LTEXT
LTEX9 Long Text CHAR 40 0 LTEXT
FORM1 Tag column CHAR 2 0 TDFORMAT
FORM2 Tag column CHAR 2 0 TDFORMAT
FORM3 Tag column CHAR 2 0 TDFORMAT
FORM4 Tag column CHAR 2 0 TDFORMAT
WRK_LABST Valuated Unrestricted-Use Stock QUAN 13 3 LABST
WRK_UNBST Non-Valuated Stock QUAN 13 3 UNBST
WRK_INSME Stock in Quality Inspection QUAN 13 3 INSME
WRK_EINME Total Stock of All Restricted Batches QUAN 13 3 EINME
WRK_SPEME Blocked Stock QUAN 13 3 SPEME
WRK_RETME Blocked Stock Returns QUAN 13 3 RETME
WRK_UMLME Stock in transfer (from one storage location to another) QUAN 13 3 UMLMD
WRK_LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
WRK_LFMON Current period (posting period) NUMC 2 0 LFMON
WRK_VMLAB Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
WRK_VMINS Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
WRK_VMEIN Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
WRK_VMSPE Blocked stock of previous period QUAN 13 3 VMSPE
WRK_VMRET Blocked Stock Returns in Previous Period QUAN 13 3 VMRET
WRK_VMUML Stock in Transfer in Previous Period QUAN 13 3 VMUML
WRK_VVLAB Valuated, unrestricted-use stock in period before last QUAN 13 3 VVLAB
WRK_KLABS Unrestricted-Use Consignment Stock QUAN 13 3 KLABS
WRK_KINSM Consignment Stock in Quality Inspection QUAN 13 3 KINSM
WRK_KEINM Restricted-Use Consignment Stock QUAN 13 3 KEINM
WRK_KSPEM Blocked Consignment Stock QUAN 13 3 KSPEM
BWTTY Valuation Category CHAR 1 0 T149C BWTTY_D
KZLTX Indicator: More long text exists CHAR 1 0 KZLTX
SANTW Response for save pop-up CHAR 1 0 SANTW
A Cancel
N Not save
Y Save
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
AAUSW Indicator: view selection only on request CHAR 1 0 AAUSW
ASCHL Indicator: org. levels/profiles only on request CHAR 1 0 ASCHL
ABRSH Indicator: hide industry sector on initial screen CHAR 1 0 ABRSH
TEXT3 Text (20 Characters) CHAR 20 0 TEXT20
PROPR Forecast profile CHAR 4 0 MPRP PROPR
PRIOD Period for consumption or forecast values CHAR 10 0 PRIOD
PRWRT Forecast value QUAN 13 3 PRWRT
KOPRW Corrected value for forecast QUAN 13 3 KOPRW
ANTEI Ratio of the corrected value to the original value (CV:OV) DEC 4 2 ANTEL
SAIIN Seasonal index DEC 6 2 SAIIN
FIXKZ Indicator: consumption value is fixed CHAR 1 0 FIXKZ
FAKTO Correction factor for consumption/forecast values DEC 4 2 FAKTO
APERI From period CHAR 10 0 APERI
VBWRT Consumption value QUAN 13 3 VBWRT
KOVBW Corrected consumption value QUAN 13 3 KOVBW
VBTX1 Total consumption/unplanned consumption (heading) CHAR 20 0 VBTX1
VBTX2 Corr. total consumption/unplanned consumption (heading) CHAR 20 0 VBTX2
TAXKM Tax classification material CHAR 1 0 * TAXKM
NAME1 Name CHAR 30 0 NAME1
TEXPR Text for Pricing Reference Material CHAR 30 0 TEXPR
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
XLIFO LIFO/FIFO-Relevant CHAR 1 0 XLIFO
MYPOL Pool number for LIFO valuation CHAR 4 0 * MYPOOL
BUKRS Company Code CHAR 4 0 T001 BUKRS
REF_BUKRS Reference Company Code CHAR 4 0 T001 REF_BUKRS
WERK280 Plant CHAR 4 0 T001W WERKS_D
NAME280 Name CHAR 30 0 NAME1
KZTLB Technical Delivery Terms Exist CHAR 1 0 KZTLB
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOATY Cost element category CHAR 2 0 KATYP
01 Primary costs/cost-reducing revenues
03 Accrual/deferral per surcharge
04 Accrual/deferral per debit = actual
11 Revenues
12 Sales deduction
21 Internal settlement
22 External settlement
31 Order/project results analysis
41 Overhead Rates
42 Assessment
43 Internal activity allocation
50 Project-related incoming orders: Sales revenue
51 Project-related incoming orders: Other revenues
52 Project-related incoming orders: Costs
61 Earned value
66 Reporting Cost Element CO-PA
90 Statistical cost element for balance sheet account
DOKAR Document Type CHAR 3 0 TDWA DOKAR
DOKNR Document number CHAR 25 0 DRAW DOKNR
DOKTL Document Part CHAR 3 0 DOKTL_D
DOKVR Document Version CHAR 2 0 DOKVR
CVHIE Document is in Hierarchy CHAR 1 0 CVHIER
DATXT Description of Document Type CHAR 20 0 DARTXT
DKTXT Document Description CHAR 40 0 DKTXT
MDZUO Several documents exist for design drawing CHAR 1 0 MDZUO
VPMAT Planning material CHAR 40 0 MARA VPMAT
VPWRK Planning plant CHAR 4 0 MARC VPWRK
VPREF Conv. factor f. plng material CHAR 10 0 VPREF
VPBME Base unit of measure of the planning material UNIT 3 0 T006 VPBME
MDZTX Status field for linking to documents in doc. mgmt system CHAR 22 0 MDZTX
REVLV Revision Level CHAR 2 0 REVLV
AWOBA Variances: Object Type CHAR 2 0 * AWOBA
D0580 Dialog box for general plant data CHAR 1 0 D0580
DMAEX Dialog box for foreign trade data CHAR 1 0 DMAEX_D
DMAPE Dialog box for customs tariff preference data CHAR 1 0 DMAPE_D
STDPD Configurable material CHAR 40 0 * STDPD
KALST Description of material status from costing view CHAR 50 0 KALST
XLTYP Material Is a Variant CHAR 1 0 XLTYP
XVPLB Planning Variant CHAR 1 0 XVPLB
TAXIM Tax indicator for material (Purchasing) CHAR 1 0 TMKM1 TAXIM1
STEXT Description and from-date for the material status CHAR 50 0 STATUS_MAT

RM03M foreign key relationships

Table Field Check Table Check Field
0 RM03M ANZ_BWTAR1 T149D Global Valuation Types MANDT
0 RM03M ANZ_BWTAR1 T149D Global Valuation Types BWTAR
1 RM03M ANZ_BWTAR2 T149D Global Valuation Types MANDT
1 RM03M ANZ_BWTAR2 T149D Global Valuation Types BWTAR
0 RM03M ANZ_LGNUM1 T300 WM Warehouse Numbers MANDT
0 RM03M ANZ_LGNUM1 T300 WM Warehouse Numbers LGNUM
1 RM03M ANZ_LGNUM2 T300 WM Warehouse Numbers MANDT
1 RM03M ANZ_LGNUM2 T300 WM Warehouse Numbers LGNUM
0 RM03M ANZ_LGORT1 T001L Storage Locations MANDT
0 RM03M ANZ_LGORT1 T001L Storage Locations WERKS
1 RM03M ANZ_LGORT2 T001L Storage Locations MANDT
1 RM03M ANZ_LGORT2 T001L Storage Locations WERKS
0 RM03M ANZ_LGTYP1 T301 WM Storage Types MANDT
0 RM03M ANZ_LGTYP1 T301 WM Storage Types LGNUM
0 RM03M ANZ_LGTYP1 T301 WM Storage Types LGTYP
1 RM03M ANZ_LGTYP2 T301 WM Storage Types MANDT
1 RM03M ANZ_LGTYP2 T301 WM Storage Types LGNUM
1 RM03M ANZ_LGTYP2 T301 WM Storage Types LGTYP
0 RM03M ANZ_VKORG1 TVKO Organizational Unit: Sales Organizations MANDT
0 RM03M ANZ_VKORG1 TVKO Organizational Unit: Sales Organizations VKORG
1 RM03M ANZ_VKORG2 TVKO Organizational Unit: Sales Organizations MANDT
1 RM03M ANZ_VKORG2 TVKO Organizational Unit: Sales Organizations VKORG
0 RM03M ANZ_VTWEG1 TVTW Organizational Unit: Distribution Channels MANDT
0 RM03M ANZ_VTWEG1 TVTW Organizational Unit: Distribution Channels VTWEG
1 RM03M ANZ_VTWEG2 TVTW Organizational Unit: Distribution Channels MANDT
1 RM03M ANZ_VTWEG2 TVTW Organizational Unit: Distribution Channels VTWEG
0 RM03M ANZ_WERKS1 T001W Plants/Branches MANDT
0 RM03M ANZ_WERKS1 T001W Plants/Branches WERKS
1 RM03M ANZ_WERKS2 T001W Plants/Branches MANDT
1 RM03M ANZ_WERKS2 T001W Plants/Branches WERKS
0 RM03M BUKRS T001 Company Codes BUKRS
1 RM03M BWTAR T149D Global Valuation Types MANDT
1 RM03M BWTAR T149D Global Valuation Types BWTAR
0 RM03M BWTTY T149C Global Valuation Categories BWTTY
1 RM03M DISPR MDIP Material: MRP Profiles (Field Contents) MANDT
0 RM03M DOKAR TDWA Document Types MANDT
0 RM03M DOKAR TDWA Document Types DOKAR
1 RM03M DOKNR DRAW Document Info Record DOKNR
1 RM03M DOKNR DRAW Document Info Record DOKVR
1 RM03M DOKNR DRAW Document Info Record DOKTL
0 RM03M EKGRP T024 Purchasing Groups EKGRP
1 RM03M KOKRS TKA01 Controlling Areas MANDT
0 RM03M LGNUM T300 WM Warehouse Numbers MANDT
0 RM03M LGNUM T300 WM Warehouse Numbers LGNUM
1 RM03M LGORT T001L Storage Locations MANDT
1 RM03M LGORT T001L Storage Locations WERKS
0 RM03M LGTYP T301 WM Storage Types MANDT
0 RM03M LGTYP T301 WM Storage Types LGNUM
0 RM03M LGTYP T301 WM Storage Types LGTYP
1 RM03M LSOBS T460A Special procurement key MANDT
1 RM03M LSOBS T460A Special procurement key WERKS
1 RM03M LSOBS T460A Special procurement key SOBSL
0 RM03M MATNR MARA General Material Data MANDT
0 RM03M MATNR MARA General Material Data MATNR
1 RM03M MBRSH T137 Industries for materials MANDT
0 RM03M MEINH T006 Units of Measurement MANDT
0 RM03M MEINH T006 Units of Measurement MSEHI
1 RM03M MEINS T006 Units of Measurement MANDT
1 RM03M MEINS T006 Units of Measurement MSEHI
0 RM03M MTART T134 Material Types MANDT
0 RM03M MTART T134 Material Types MTART
1 RM03M PROPR MPRP Forecast Profiles MANDT
1 RM03M PROPR MPRP Forecast Profiles PROPR
0 RM03M REF_BUKRS T001 Company Codes BUKRS
1 RM03M REF_BWTAR T149D Global Valuation Types MANDT
1 RM03M REF_BWTAR T149D Global Valuation Types BWTAR
0 RM03M REF_LGNUM T300 WM Warehouse Numbers MANDT
0 RM03M REF_LGNUM T300 WM Warehouse Numbers LGNUM
1 RM03M REF_LGORT T001L Storage Locations MANDT
1 RM03M REF_LGORT T001L Storage Locations WERKS
0 RM03M REF_LGTYP T301 WM Storage Types MANDT
0 RM03M REF_LGTYP T301 WM Storage Types LGNUM
0 RM03M REF_LGTYP T301 WM Storage Types LGTYP
1 RM03M REF_MATNR MARA General Material Data MANDT
1 RM03M REF_MATNR MARA General Material Data MATNR
0 RM03M REF_VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 RM03M REF_VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 RM03M REF_VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 RM03M REF_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 RM03M REF_WERKS T001W Plants/Branches MANDT
0 RM03M REF_WERKS T001W Plants/Branches WERKS
1 RM03M RLGOR T001L Storage Locations MANDT
1 RM03M RLGOR T001L Storage Locations WERKS
0 RM03M SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 RM03M TAXIM TMKM1 Taxes: Materials (Purchasing) MANDT
1 RM03M TAXIM TMKM1 Taxes: Materials (Purchasing) LAND1
1 RM03M TAXIM TMKM1 Taxes: Materials (Purchasing) TAXIM
0 RM03M VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 RM03M VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 RM03M VPBME T006 Units of Measurement MANDT
0 RM03M VPMAT MARA General Material Data MANDT
0 RM03M VPMAT MARA General Material Data MATNR
1 RM03M VPWRK MARC Plant Data for Material MANDT
1 RM03M VPWRK MARC Plant Data for Material MATNR
1 RM03M VPWRK MARC Plant Data for Material WERKS
0 RM03M VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 RM03M VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 RM03M WERK280 T001W Plants/Branches MANDT
1 RM03M WERK280 T001W Plants/Branches WERKS
0 RM03M WERKS T001W Plants/Branches MANDT
0 RM03M WERKS T001W Plants/Branches WERKS