SAP Table RM03M_DB
Help Fields for Material Master Data Maintenance
RM03M_DB (Help Fields for Material Master Data Maintenance) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link RM03M_DB to other SAP tables.
RM03M_DB table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||
BERID | MRP Area | BERID | CHAR | 10 | 0 | |||||||||||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
DISPR | Material: MRP profile | DISPR | MDIP | CHAR | 4 | 0 | ||||||||||||
LVORM | Deletion Indicator | LVORM | CHAR | 1 | 0 |
Possible values
|
||||||||||||
DYTX1 | Screen description | DYTXT | CHAR | 20 | 0 | |||||||||||||
DYTX2 | Screen description | DYTXT | CHAR | 20 | 0 | |||||||||||||
DYTX3 | Screen description | DYTXT | CHAR | 20 | 0 | |||||||||||||
VCTX1 | Description of the change code | VCTXT_D | CHAR | 16 | 0 | |||||||||||||
VCTX2 | Description of the change code | VCTXT_D | CHAR | 16 | 0 | |||||||||||||
VCTX3 | Description of the change code | VCTXT_D | CHAR | 16 | 0 | |||||||||||||
KZAU1 | Selection indicator | KZSEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
KZAU2 | Selection indicator | KZSEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
KZSE1 | Selection indicator | KZSEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
KZSE2 | Selection indicator | KZSEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
KZSE3 | Selection indicator | KZSEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
KORFA | Correction factor | KORFA | DEC | 4 | 2 | |||||||||||||
PERKZ | Period Indicator | PERKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
MEINH | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
LMINB | Reorder Point | MINBE | QUAN | 13 | 3 | |||||||||||||
LBSTF | Fixed lot size | BSTFE | QUAN | 13 | 3 | |||||||||||||
TEXT1 | Text | TEXT1 | CHAR | 50 | 0 | |||||||||||||
TEXT2 | Text | TEXT1 | CHAR | 50 | 0 | |||||||||||||
SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||||
LTEX1 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX2 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX3 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX4 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX5 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX6 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX7 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX8 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
LTEX9 | Long Text | LTEXT | CHAR | 40 | 0 | |||||||||||||
FORM1 | Tag column | TDFORMAT | CHAR | 2 | 0 | |||||||||||||
FORM2 | Tag column | TDFORMAT | CHAR | 2 | 0 | |||||||||||||
FORM3 | Tag column | TDFORMAT | CHAR | 2 | 0 | |||||||||||||
FORM4 | Tag column | TDFORMAT | CHAR | 2 | 0 | |||||||||||||
WRK_LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | 0 | |||||||||||||
WRK_LFMON | Current period (posting period) | LFMON | NUMC | 2 | 0 | |||||||||||||
TEXT3 | Text (20 Characters) | TEXT20 | CHAR | 20 | 0 | |||||||||||||
PROPR | Forecast profile | PROPR | MPRP | CHAR | 4 | 0 | ||||||||||||
PRIOD | Period for consumption or forecast values | PRIOD | CHAR | 10 | 0 | |||||||||||||
PRWRT | Forecast value | PRWRT | QUAN | 13 | 3 | |||||||||||||
KOPRW | Corrected value for forecast | KOPRW | QUAN | 13 | 3 | |||||||||||||
ANTEI | Ratio of the corrected value to the original value (CV:OV) | ANTEL | DEC | 4 | 2 | |||||||||||||
SAIIN | Seasonal index | SAIIN | DEC | 6 | 2 | |||||||||||||
FIXKZ | Indicator: consumption value is fixed | FIXKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
FAKTO | Correction factor for consumption/forecast values | FAKTO | DEC | 4 | 2 | |||||||||||||
APERI | From period | APERI | CHAR | 10 | 0 | |||||||||||||
VBWRT | Consumption value | VBWRT | QUAN | 13 | 3 | |||||||||||||
KOVBW | Corrected consumption value | KOVBW | QUAN | 13 | 3 | |||||||||||||
VBTX1 | Total consumption/unplanned consumption (heading) | VBTX1 | CHAR | 20 | 0 | |||||||||||||
VBTX2 | Corr. total consumption/unplanned consumption (heading) | VBTX2 | CHAR | 20 | 0 | |||||||||||||
TAXKM | Tax classification material | TAXKM | CHAR | 1 | 0 | |||||||||||||
NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||||||||||||
TEXPR | Text for Pricing Reference Material | TEXPR | CHAR | 30 | 0 | |||||||||||||
MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||
XLIFO | LIFO/FIFO-Relevant | XLIFO | CHAR | 1 | 0 |
Possible values
|
||||||||||||
MYPOL | Pool number for LIFO valuation | MYPOOL | CHAR | 4 | 0 | |||||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||
REF_BUKRS | Reference Company Code | REF_BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||
WERK280 | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||
NAME280 | Name | NAME1 | CHAR | 30 | 0 | |||||||||||||
KZTLB | Indicator: Technical delivery terms exist | KZTLB | CHAR | 1 | 0 |
Possible values
|
RM03M_DB foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
RM03M_DB | BUKRS | SYST | MANDT | T001 | Company Codes | MANDT |
RM03M_DB | BUKRS | RM03M_DB | BUKRS | T001 | Company Codes | BUKRS |
RM03M_DB | DISPR | SYST | MANDT | MDIP | Material: MRP Profiles (Field Contents) | MANDT |
RM03M_DB | DISPR | RM03M_DB | DISPR | MDIP | Material: MRP Profiles (Field Contents) | DISPR |
RM03M_DB | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
RM03M_DB | MATNR | RM03M_DB | MATNR | MARA | General Material Data | MATNR |
RM03M_DB | MEINH | SYST | MANDT | T006 | Units of Measurement | MANDT |
RM03M_DB | MEINH | RM03M_DB | MEINH | T006 | Units of Measurement | MSEHI |
RM03M_DB | MEINS | SYST | MANDT | T006 | Units of Measurement | MANDT |
RM03M_DB | MEINS | RM03M_DB | MEINS | T006 | Units of Measurement | MSEHI |
RM03M_DB | PROPR | SYST | MANDT | MPRP | Forecast Profiles | MANDT |
RM03M_DB | PROPR | RM03M_DB | PROPR | MPRP | Forecast Profiles | PROPR |
RM03M_DB | REF_BUKRS | SYST | MANDT | T001 | Company Codes | MANDT |
RM03M_DB | REF_BUKRS | RM03M_DB | REF_BUKRS | T001 | Company Codes | BUKRS |
RM03M_DB | SPRAS | RM03M_DB | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
RM03M_DB | WERK280 | SYST | MANDT | T001W | Plants/Branches | MANDT |
RM03M_DB | WERK280 | RM03M_DB | WERK280 | T001W | Plants/Branches | WERKS |