Table/Structure Field list used by SAP ABAP Program LMGMLFSW (SQL Commands for Retail-Specific Material Master Tables)
SAP ABAP Program
LMGMLFSW (SQL Commands for Retail-Specific Material Master Tables) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | EMARA - MEINS | Base Unit of Measure | ||
| 2 | EMARA - ATTYP | Material Category | ||
| 3 | KLAH - KLART | Class Type | ||
| 4 | KLAH - CLASS | Class number | ||
| 5 | MABW - BWKEY | Valuation area | ||
| 6 | MABW - BWTAR | Valuation type | ||
| 7 | MABW - LGNUM | Warehouse Number / Warehouse Complex | ||
| 8 | MABW - LGORT | Storage location | ||
| 9 | MABW - LGTYP | Storage Type | ||
| 10 | MABW - MATNR | Material Number | ||
| 11 | MABW - VKORG | Sales Organization | ||
| 12 | MABW - VTWEG | Distribution Channel | ||
| 13 | MABW - WERKS | Plant | ||
| 14 | MARA - ATTYP | Material Category | ||
| 15 | MARA - MATNR | Material Number | ||
| 16 | MARA - MEINS | Base Unit of Measure | ||
| 17 | MARC - MATNR | Material Number | ||
| 18 | MARC - WERKS | Plant | ||
| 19 | MREFPLANT - WERKS | Plant | ||
| 20 | MTCOM - KZRFB | Indicator: reset buffer for Material_Pre_Fetch | ||
| 21 | MTCOM - MAXTZ | Maximum number of table lines | ||
| 22 | PRE01 - MATNR | Material Number | ||
| 23 | PRE01 - WERKS | Plant | ||
| 24 | PRE03 - MATNR | Material Number | ||
| 25 | PRE04 - BWKEY | Valuation area | ||
| 26 | PRE04 - MATNR | Material Number | ||
| 27 | PRE14 - MATNR | Material Number | ||
| 28 | PRE14 - MYKEY | LIFO valuation level | ||
| 29 | PRE15 - WERKS | Plant | ||
| 30 | PRE17 - BWKEY | Valuation area | ||
| 31 | PRE17 - MATNR | Material Number | ||
| 32 | RMCLF - OBJEK | Key of object to be classified | ||
| 33 | RMMG08_012 - MSGTYP | For message type conversion | ||
| 34 | RMMG1 - VTWEG | Distribution Channel | ||
| 35 | RMMG1 - MTART | Material type | ||
| 36 | RMMG1 - MATNR | Material Number | ||
| 37 | RMMG1 - VKORG | Sales Organization | ||
| 38 | RMMW2 - ATTYP | Material Category | ||
| 39 | RMMW2 - BTWRK | Retail plant | ||
| 40 | RMMW2 - CHANGE_VAR | Change Variant by Data Transfer | ||
| 41 | RMMW2 - CLASS | Class number | ||
| 42 | RMMW2 - EKORG | Purchasing organization | ||
| 43 | RMMW2 - EKWRK | Plant | ||
| 44 | RMMW2 - KLTYP | Merchandize management system class type | ||
| 45 | RMMW2 - LIFNR | Vendor's account number | ||
| 46 | RMMW2 - ONLY_VAR | Only with Variant of a Generic Material in Transactions | ||
| 47 | RMMW2 - SATNR | Cross-Plant Configurable Material | ||
| 48 | RMMW2 - VARNR | Variant number | ||
| 49 | RMMW3 - AKTVSTA_RT | Retail maintenance status | ||
| 50 | SPTAP - TBNAM | Table name | ||
| 51 | SVARTAB - VARNR | Variant number | ||
| 52 | SVARTAB - SATNR | Cross-Plant Configurable Material | ||
| 53 | SYST - DATAR | ABAP System Field: Highlighted Input in Dynpro Field | ||
| 54 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 55 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 56 | T001K - BUKRS | Company Code | ||
| 57 | T001W - BWKEY | Valuation area | ||
| 58 | T001W - WERKS | Plant | ||
| 59 | T130F - KZREF | Propose Field Content from the Reference | ||
| 60 | T130M - AKTYP | Activity category in SAP transaction | ||
| 61 | T130R - TBHER | Origin indicator for table | ||
| 62 | T130S - SLOCK | Shared Lock in Material Master (Only Tables MBEW and MARC) | ||
| 63 | T134 - MTART | Material type | ||
| 64 | TCLA - OBTAB | Name of database table for object | ||
| 65 | TCURM - BWKRS_CUS | Valuation area setting | ||
| 66 | TCURM - MYKEY_CUS | Balance Sheet Valuation Level | ||
| 67 | TCURM - MYMP_CUS | Actual valuation area, tables MYMP, MYMP1, and MYMS | ||
| 68 | TVGVI - SPERA | Type of block (shared, exclusive) |