SAP F0MMIM_MATSTVAL Table in S/4 HANA - Generated Table for View
F0MMIM_MATSTVAL is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP F0MMIM_MATSTVAL table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: F0MMIM_MATSTVAL
F0MMIM_MATSTVAL table structure field list
Below is the full F0MMIM_MATSTVAL field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| MATERIAL | Material in Respect of Which Stock is Managed | MATBF | CHAR | 40(0) | MATN1 | MATNR | ||||
| PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
| STORAGELOCATION | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
| BATCH | Batch Number | CHARG_D | CHAR | 10(0) | CHARG | CHA | ||||
| SUPPLIER | Supplier | MD_SUPPLIER | CHAR | 10(0) | ALPHA | LIFNR | ||||
| SDDOCUMENT | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
| SDDOCUMENTITEM | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
| WBSELEMENTINTERNALID | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
| CUSTOMER | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
| INVENTORYSPECIALSTOCKTYPE | Special Stock Indicator | SOBKZ | CHAR | 1(0) | SOBKZ | |||||
| COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
| MATERIALBASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
| CURRENCY | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
| DISPLAYCURRENCY | Display Currency | VDM_V_DISPLAY_CURRENCY | CUKY | 5(0) | WAERS | |||||
| INVENTORYVALUATIONTYPE | Valuation Type | BWTAR_D | CHAR | 10(0) | BWTAR | BWT | ||||
| WBSELEMENTEXTERNALID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | CHAR | 24(0) | PS_POSID_EDIT | |||||
| WAREHOUSESTORAGEBIN | Storage Bin | LGPBE | CHAR | 10(0) | CHAR10 | |||||
| MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
| MATERIALGROUP | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
| MATERIALGROUPNAME | Product Group Description | PRODUCTGROUPDESCRIPTION | CHAR | 20(0) | TEXT20 | |||||
| PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
| STORAGELOCATIONNAME | Storage Location Name | LGORT_NAME | CHAR | 16(0) | TEXT16 | |||||
| INVENTORYSPECIALSTOCKTYPENAME | Description of special stock | SOTXT_D | CHAR | 20(0) | TEXT20 | |||||
| CUSTOMERNAME | Name 1 | NAME1_GP | CHAR | 35(0) | NAME | |||||
| SUPPLIERNAME | Name 1 | NAME1_GP | CHAR | 35(0) | NAME | |||||
| SHELFLIFEEXPIRATIONDATE | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8(0) | DATUM | |||||
| MANUFACTUREDATE | Date of Manufacture | HSDAT | DATS | 8(0) | DATUM | |||||
| CURRENTSTOCK | DEC | 21(3) | ||||||||
| QUALITYINSPECTIONSTOCKQUANTITY | DEC | 21(3) | ||||||||
| RETURNSBLOCKEDSTOCKQUANTITY | DEC | 21(3) | ||||||||
| TRANSFERSTOCKSTORAGELOCQTY | DEC | 21(3) | ||||||||
| TRANSFERSTOCKPLANTQUANTITY | DEC | 21(3) | ||||||||
| STOCKINTRANSITQUANTITY | DEC | 21(3) | ||||||||
| BLOCKEDSTOCKQUANTITY | DEC | 21(3) | ||||||||
| RESTRICTEDSTOCKQUANTITY | DEC | 21(3) | ||||||||
| TIEDEMPTIESSTOCKQUANTITY | DEC | 21(3) | ||||||||
| GOODSRECEIPTBLOCKEDSTOCKQTY | DEC | 21(3) | ||||||||
| CURRENTSTOCKVALUE | CURR | 23(2) | ||||||||
| QUALITYINSPECTIONSTOCKVALUE | CURR | 23(2) | ||||||||
| RETURNSBLOCKEDSTOCKVALUE | CURR | 23(2) | ||||||||
| TRANSFERSTOCKSTORAGELOCVALUE | CURR | 23(2) | ||||||||
| TRANSFERSTOCKPLANTVALUE | CURR | 23(2) | ||||||||
| STOCKINTRANSITVALUE | CURR | 23(2) | ||||||||
| BLOCKEDSTOCKVALUE | CURR | 23(2) | ||||||||
| RESTRICTEDSTOCKVALUE | CURR | 23(2) | ||||||||
| TIEDEMPTIESSTOCKVALUE | CURR | 23(2) | ||||||||
| GOODSRECEIPTBLOCKEDSTOCKVALUE | CURR | 23(2) | ||||||||
| CURRENTSTOCKVALUEINDC | Current Stock Currency Value in Display Currency | MMIM_CURRENTSTOCKVALINDC | CURR | 23(2) | ||||||
| QUALITYINSPSTOCKVALUEINDC | Quality Inspection Stock Currency Value in Display Currency | MMIM_QUALITYINSPSTOCKVALINDC | CURR | 23(2) | ||||||
| RETURNSBLOCKEDSTOCKVALUEINDC | Returns Blocked Stock Currency Value in Display Currency | MMIM_RETURNSBLOSTOCKVALINDC | CURR | 23(2) | ||||||
| TRANSFERSTOCKSTORLOCVALUEINDC | Transfer Stock Storage Location Currency Value in Disp. Cur. | MMIM_TRANSSTSTORLOCVALINDC | CURR | 23(2) | ||||||
| TRANSFERSTOCKPLANTVALUEINDC | Transfer Stock Plant Currency Value in Display Currency | MMIM_TRANSSTOCKPLTVALINDC | CURR | 23(2) | ||||||
| STOCKINTRANSITVALUEINDC | Stock in Transit Currency Value in Display Currency | MMIM_STOCKINTRANSITVALINDC | CURR | 23(2) | ||||||
| BLOCKEDSTOCKVALUEINDC | Blocked Stock Currency Value in Display Currency | MMIM_BLOCKEDSTOCKVALINDC | CURR | 23(2) | ||||||
| RESTRICTEDSTOCKVALUEINDC | Restricted Stock Currency Value in Display Currency | MMIM_RESTRICTEDSTOCKVALINDC | CURR | 23(2) | ||||||
| TIEDEMPTIESSTOCKVALUEINDC | Tied Empties Stock Currency Value in Display Currency | MMIM_TIEDEMPTIESSTOCKVALINDC | CURR | 23(2) | ||||||
| GRBLOCKEDSTOCKVALUEINDC | Goods Receipt Blocked Stock Currency Value in Display Cur. | MMIM_GRBLOCKSTOCKVALINDC | CURR | 23(2) | ||||||
| CURRENTSTOCKCURVAL | CURR | 23(2) | ||||||||
| QUALITYINSPECTIONSTOCKCURVAL | CURR | 23(2) | ||||||||
| RETURNSBLOCKEDSTOCKCURVAL | CURR | 23(2) | ||||||||
| TRANSFERSTOCKSTORAGELOCCURVAL | CURR | 23(2) | ||||||||
| TRANSFERSTOCKPLANTCURVAL | CURR | 23(2) | ||||||||
| STOCKINTRANSITCURVAL | CURR | 23(2) | ||||||||
| BLOCKEDSTOCKCURVAL | CURR | 23(2) | ||||||||
| RESTRICTEDSTOCKCURVAL | CURR | 23(2) | ||||||||
| TIEDEMPTIESSTOCKCURVAL | CURR | 23(2) | ||||||||
| GOODSRECEIPTBLOCKEDSTOCKCURVAL | CURR | 23(2) | ||||||||
| CURRENTSTOCKCURVALINDC | Current Stock Currency Value in Display Currency | MMIM_CURRENTSTOCKCURVALINDC | CURR | 23(2) | ||||||
| QUALITYINSPSTOCKCURVALINDC | Quality Inspection Stock Currency Value in Display Currency | MMIM_QUALITYINSPSTOCKVALINDC | CURR | 23(2) | ||||||
| RETURNSBLOCKEDSTOCKCURVALINDC | Returns Blocked Stock Currency Value in Display Currency | MMIM_RETURNSBLOSTCURVALINDC | CURR | 23(2) | ||||||
| TRANSFERSTOCKSTORLOCCURVALINDC | Transfer Stock Storage Location Currency Value in Disp. Cur. | MMIM_TRANSSTSTORLOCCURVALINDC | CURR | 23(2) | ||||||
| TRANSFERSTOCKPLANTCURVALINDC | Transfer Stock Plant Currency Value in Display Currency | MMIM_TRANSSTOCKPLTCURVALINDC | CURR | 23(2) | ||||||
| STOCKINTRANSITCURVALINDC | Stock in Transit Currency Value in Display Currency | MMIM_STOCKINTRANSITCURVALINDC | CURR | 23(2) | ||||||
| BLOCKEDSTOCKCURVALINDC | Blocked Stock Currency Value in Display Currency | MMIM_BLOCKEDSTOCKCURVALINDC | CURR | 23(2) | ||||||
| RESTRICTEDSTOCKCURVALINDC | Restricted Stock Currency Value in Display Currency | MMIM_RESTRICTEDSTCURVALINDC | CURR | 23(2) | ||||||
| TIEDEMPTIESSTOCKCURVALINDC | Tied Empties Stock Currency Value in Display Currency | MMIM_TIEDEMPTSTOCKCURVALINDC | CURR | 23(2) | ||||||
| GRBLOCKEDSTOCKCURVALINDC | Goods Receipt Blocked Stock Currency Value in Display Cur. | MMIM_GRBLOCKSTOCKCURVALINDC | CURR | 23(2) |
Search for further information about these or an SAP related objects