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. |