So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like F0MMIM_MATSTVAL look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.
Object Name: F0MMIM_MATSTVAL
Dictionary Type: Table view
Description: Generated Table for View
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | Client | MANDT | TEST | ||||||
| MATERIAL | MATBF | CHAR | 40(0) | Material in Respect of Which Stock is Managed | MATNR | |||||||
| PLANT | WERKS_D | CHAR | 4(0) | Plant | WERKS | WRK | KC | H_T001W_C | WERKS | |||
| STORAGELOCATION | LGORT_D | CHAR | 4(0) | Storage location | LGORT | LAG | MG | |||||
| BATCH | CHARG_D | CHAR | 10(0) | Batch Number | CHARG | CHA | MG | |||||
| SUPPLIER | MD_SUPPLIER | CHAR | 10(0) | Supplier | LIFNR | |||||||
| SDDOCUMENT | MAT_KDAUF | CHAR | 10(0) | Sales order number of valuated sales order stock | VBELN | AUN | MD | |||||
| SDDOCUMENTITEM | MAT_KDPOS | NUMC | 6(0) | Sales Order Item of Valuated Sales Order Stock | NUM06 | KPO | MD | |||||
| WBSELEMENTINTERNALID | MAT_PSPNR | NUMC | 8(0) | Valuated Sales Order Stock WBS Element | PS_POSNR | |||||||
| CUSTOMER | KUNNR | CHAR | 10(0) | Customer Number | KUNNR | KUN | V | C_KUNNR | KUNNR | |||
| INVENTORYSPECIALSTOCKTYPE | SOBKZ | CHAR | 1(0) | Special Stock Indicator | SOBKZ | MG | ||||||
| COMPANYCODE | BUKRS | CHAR | 4(0) | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | |||
| MATERIALBASEUNIT | MEINS | UNIT | 3(0) | Base Unit of Measure | MEINS | MG | ||||||
| CURRENCY | WAERS | CUKY | 5(0) | TCURC | Currency Key | WAERS | FWS | FB | ||||
| DISPLAYCURRENCY | VDM_V_DISPLAY_CURRENCY | CUKY | 5(0) | Display Currency | WAERS | |||||||
| INVENTORYVALUATIONTYPE | BWTAR_D | CHAR | 10(0) | Valuation Type | BWTAR | BWT | MG | |||||
| WBSELEMENTEXTERNALID | PS_POSID_EDIT | CHAR | 24(0) | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |||||||
| WAREHOUSESTORAGEBIN | LGPBE | CHAR | 10(0) | Storage Bin | CHAR10 | MG | ||||||
| MATERIALNAME | MAKTX | CHAR | 40(0) | Material description | TEXT40 | MG | ||||||
| MATERIALGROUP | MATKL | CHAR | 9(0) | T023 | Material Group | MATKL | MKL | MG | S_WBWG | MATKL | ||
| MATERIALGROUPNAME | PRODUCTGROUPDESCRIPTION | CHAR | 20(0) | Product Group Description | TEXT20 | MG | ||||||
| PLANTNAME | WERKS_NAME | CHAR | 30(0) | Plant Name | TEXT30 | |||||||
| STORAGELOCATIONNAME | LGORT_NAME | CHAR | 16(0) | Storage Location Name | TEXT16 | |||||||
| INVENTORYSPECIALSTOCKTYPENAME | SOTXT_D | CHAR | 20(0) | Description of special stock | TEXT20 | MG | ||||||
| CUSTOMERNAME | NAME1_GP | CHAR | 35(0) | Name 1 | NAME | VP | ||||||
| SUPPLIERNAME | NAME1_GP | CHAR | 35(0) | Name 1 | NAME | VP | ||||||
| SHELFLIFEEXPIRATIONDATE | VFDAT | DATS | 8(0) | Shelf Life Expiration or Best-Before Date | DATUM | MG | ||||||
| MANUFACTUREDATE | HSDAT | DATS | 8(0) | Date of Manufacture | 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 | MMIM_CURRENTSTOCKVALINDC | CURR | 23(2) | Current Stock Currency Value in Display Currency | ||||||||
| QUALITYINSPSTOCKVALUEINDC | MMIM_QUALITYINSPSTOCKVALINDC | CURR | 23(2) | Quality Inspection Stock Currency Value in Display Currency | ||||||||
| RETURNSBLOCKEDSTOCKVALUEINDC | MMIM_RETURNSBLOSTOCKVALINDC | CURR | 23(2) | Returns Blocked Stock Currency Value in Display Currency | ||||||||
| TRANSFERSTOCKSTORLOCVALUEINDC | MMIM_TRANSSTSTORLOCVALINDC | CURR | 23(2) | Transfer Stock Storage Location Currency Value in Disp. Cur. | ||||||||
| TRANSFERSTOCKPLANTVALUEINDC | MMIM_TRANSSTOCKPLTVALINDC | CURR | 23(2) | Transfer Stock Plant Currency Value in Display Currency | ||||||||
| STOCKINTRANSITVALUEINDC | MMIM_STOCKINTRANSITVALINDC | CURR | 23(2) | Stock in Transit Currency Value in Display Currency | ||||||||
| BLOCKEDSTOCKVALUEINDC | MMIM_BLOCKEDSTOCKVALINDC | CURR | 23(2) | Blocked Stock Currency Value in Display Currency | ||||||||
| RESTRICTEDSTOCKVALUEINDC | MMIM_RESTRICTEDSTOCKVALINDC | CURR | 23(2) | Restricted Stock Currency Value in Display Currency | ||||||||
| TIEDEMPTIESSTOCKVALUEINDC | MMIM_TIEDEMPTIESSTOCKVALINDC | CURR | 23(2) | Tied Empties Stock Currency Value in Display Currency | ||||||||
| GRBLOCKEDSTOCKVALUEINDC | MMIM_GRBLOCKSTOCKVALINDC | CURR | 23(2) | Goods Receipt Blocked Stock Currency Value in Display Cur. | ||||||||
| 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 | MMIM_CURRENTSTOCKCURVALINDC | CURR | 23(2) | Current Stock Currency Value in Display Currency | ||||||||
| QUALITYINSPSTOCKCURVALINDC | MMIM_QUALITYINSPSTOCKVALINDC | CURR | 23(2) | Quality Inspection Stock Currency Value in Display Currency | ||||||||
| RETURNSBLOCKEDSTOCKCURVALINDC | MMIM_RETURNSBLOSTCURVALINDC | CURR | 23(2) | Returns Blocked Stock Currency Value in Display Currency | ||||||||
| TRANSFERSTOCKSTORLOCCURVALINDC | MMIM_TRANSSTSTORLOCCURVALINDC | CURR | 23(2) | Transfer Stock Storage Location Currency Value in Disp. Cur. | ||||||||
| TRANSFERSTOCKPLANTCURVALINDC | MMIM_TRANSSTOCKPLTCURVALINDC | CURR | 23(2) | Transfer Stock Plant Currency Value in Display Currency | ||||||||
| STOCKINTRANSITCURVALINDC | MMIM_STOCKINTRANSITCURVALINDC | CURR | 23(2) | Stock in Transit Currency Value in Display Currency | ||||||||
| BLOCKEDSTOCKCURVALINDC | MMIM_BLOCKEDSTOCKCURVALINDC | CURR | 23(2) | Blocked Stock Currency Value in Display Currency | ||||||||
| RESTRICTEDSTOCKCURVALINDC | MMIM_RESTRICTEDSTCURVALINDC | CURR | 23(2) | Restricted Stock Currency Value in Display Currency | ||||||||
| TIEDEMPTIESSTOCKCURVALINDC | MMIM_TIEDEMPTSTOCKCURVALINDC | CURR | 23(2) | Tied Empties Stock Currency Value in Display Currency | ||||||||
| GRBLOCKEDSTOCKCURVALINDC | MMIM_GRBLOCKSTOCKCURVALINDC | CURR | 23(2) | Goods Receipt Blocked Stock Currency Value in Display Cur. |