SAP S/4Hana table F0MMIM_MATSTVAL stores Generated Table for Viewdata

  

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.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana F0MMIM_MATSTVAL dictionary attributes

Object Name: F0MMIM_MATSTVAL
Dictionary Type: Table view
Description: Generated Table for View


Field list for F0MMIM_MATSTVAL table on an S/4 SAP system

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) ClientMANDTTEST
MATERIALMATBFCHAR40(0) Material in Respect of Which Stock is ManagedMATNR
PLANTWERKS_DCHAR4(0) PlantWERKSWRKKCH_T001W_CWERKS
STORAGELOCATIONLGORT_DCHAR4(0) Storage locationLGORTLAGMG
BATCHCHARG_DCHAR10(0) Batch NumberCHARGCHAMG
SUPPLIERMD_SUPPLIERCHAR10(0) SupplierLIFNR
SDDOCUMENTMAT_KDAUFCHAR10(0) Sales order number of valuated sales order stockVBELNAUNMD
SDDOCUMENTITEMMAT_KDPOSNUMC6(0) Sales Order Item of Valuated Sales Order StockNUM06KPOMD
WBSELEMENTINTERNALIDMAT_PSPNRNUMC8(0) Valuated Sales Order Stock WBS ElementPS_POSNR
CUSTOMERKUNNRCHAR10(0) Customer NumberKUNNRKUNVC_KUNNRKUNNR
INVENTORYSPECIALSTOCKTYPESOBKZCHAR1(0) Special Stock IndicatorSOBKZMG
COMPANYCODEBUKRSCHAR4(0) Company CodeBUKRSBUKFBC_T001BUKRS
MATERIALBASEUNITMEINSUNIT3(0) Base Unit of MeasureMEINSMG
CURRENCYWAERSCUKY5(0) TCURCCurrency KeyWAERSFWSFB
DISPLAYCURRENCYVDM_V_DISPLAY_CURRENCYCUKY5(0) Display CurrencyWAERS
INVENTORYVALUATIONTYPEBWTAR_DCHAR10(0) Valuation TypeBWTARBWTMG
WBSELEMENTEXTERNALIDPS_POSID_EDITCHAR24(0) Work Breakdown Structure Element (WBS Element) EditedPS_POSID_EDIT
WAREHOUSESTORAGEBINLGPBECHAR10(0) Storage BinCHAR10MG
MATERIALNAMEMAKTXCHAR40(0) Material descriptionTEXT40MG
MATERIALGROUPMATKLCHAR9(0) T023Material GroupMATKLMKLMGS_WBWGMATKL
MATERIALGROUPNAMEPRODUCTGROUPDESCRIPTIONCHAR20(0) Product Group DescriptionTEXT20MG
PLANTNAMEWERKS_NAMECHAR30(0) Plant NameTEXT30
STORAGELOCATIONNAMELGORT_NAMECHAR16(0) Storage Location NameTEXT16
INVENTORYSPECIALSTOCKTYPENAMESOTXT_DCHAR20(0) Description of special stockTEXT20MG
CUSTOMERNAMENAME1_GPCHAR35(0) Name 1NAMEVP
SUPPLIERNAMENAME1_GPCHAR35(0) Name 1NAMEVP
SHELFLIFEEXPIRATIONDATEVFDATDATS8(0) Shelf Life Expiration or Best-Before DateDATUMMG
MANUFACTUREDATEHSDATDATS8(0) Date of ManufactureDATUM
CURRENTSTOCKDEC21(3)
QUALITYINSPECTIONSTOCKQUANTITYDEC21(3)
RETURNSBLOCKEDSTOCKQUANTITYDEC21(3)
TRANSFERSTOCKSTORAGELOCQTYDEC21(3)
TRANSFERSTOCKPLANTQUANTITYDEC21(3)
STOCKINTRANSITQUANTITYDEC21(3)
BLOCKEDSTOCKQUANTITYDEC21(3)
RESTRICTEDSTOCKQUANTITYDEC21(3)
TIEDEMPTIESSTOCKQUANTITYDEC21(3)
GOODSRECEIPTBLOCKEDSTOCKQTYDEC21(3)
CURRENTSTOCKVALUECURR23(2)
QUALITYINSPECTIONSTOCKVALUECURR23(2)
RETURNSBLOCKEDSTOCKVALUECURR23(2)
TRANSFERSTOCKSTORAGELOCVALUECURR23(2)
TRANSFERSTOCKPLANTVALUECURR23(2)
STOCKINTRANSITVALUECURR23(2)
BLOCKEDSTOCKVALUECURR23(2)
RESTRICTEDSTOCKVALUECURR23(2)
TIEDEMPTIESSTOCKVALUECURR23(2)
GOODSRECEIPTBLOCKEDSTOCKVALUECURR23(2)
CURRENTSTOCKVALUEINDCMMIM_CURRENTSTOCKVALINDCCURR23(2) Current Stock Currency Value in Display Currency
QUALITYINSPSTOCKVALUEINDCMMIM_QUALITYINSPSTOCKVALINDCCURR23(2) Quality Inspection Stock Currency Value in Display Currency
RETURNSBLOCKEDSTOCKVALUEINDCMMIM_RETURNSBLOSTOCKVALINDCCURR23(2) Returns Blocked Stock Currency Value in Display Currency
TRANSFERSTOCKSTORLOCVALUEINDCMMIM_TRANSSTSTORLOCVALINDCCURR23(2) Transfer Stock Storage Location Currency Value in Disp. Cur.
TRANSFERSTOCKPLANTVALUEINDCMMIM_TRANSSTOCKPLTVALINDCCURR23(2) Transfer Stock Plant Currency Value in Display Currency
STOCKINTRANSITVALUEINDCMMIM_STOCKINTRANSITVALINDCCURR23(2) Stock in Transit Currency Value in Display Currency
BLOCKEDSTOCKVALUEINDCMMIM_BLOCKEDSTOCKVALINDCCURR23(2) Blocked Stock Currency Value in Display Currency
RESTRICTEDSTOCKVALUEINDCMMIM_RESTRICTEDSTOCKVALINDCCURR23(2) Restricted Stock Currency Value in Display Currency
TIEDEMPTIESSTOCKVALUEINDCMMIM_TIEDEMPTIESSTOCKVALINDCCURR23(2) Tied Empties Stock Currency Value in Display Currency
GRBLOCKEDSTOCKVALUEINDCMMIM_GRBLOCKSTOCKVALINDCCURR23(2) Goods Receipt Blocked Stock Currency Value in Display Cur.
CURRENTSTOCKCURVALCURR23(2)
QUALITYINSPECTIONSTOCKCURVALCURR23(2)
RETURNSBLOCKEDSTOCKCURVALCURR23(2)
TRANSFERSTOCKSTORAGELOCCURVALCURR23(2)
TRANSFERSTOCKPLANTCURVALCURR23(2)
STOCKINTRANSITCURVALCURR23(2)
BLOCKEDSTOCKCURVALCURR23(2)
RESTRICTEDSTOCKCURVALCURR23(2)
TIEDEMPTIESSTOCKCURVALCURR23(2)
GOODSRECEIPTBLOCKEDSTOCKCURVALCURR23(2)
CURRENTSTOCKCURVALINDCMMIM_CURRENTSTOCKCURVALINDCCURR23(2) Current Stock Currency Value in Display Currency
QUALITYINSPSTOCKCURVALINDCMMIM_QUALITYINSPSTOCKVALINDCCURR23(2) Quality Inspection Stock Currency Value in Display Currency
RETURNSBLOCKEDSTOCKCURVALINDCMMIM_RETURNSBLOSTCURVALINDCCURR23(2) Returns Blocked Stock Currency Value in Display Currency
TRANSFERSTOCKSTORLOCCURVALINDCMMIM_TRANSSTSTORLOCCURVALINDCCURR23(2) Transfer Stock Storage Location Currency Value in Disp. Cur.
TRANSFERSTOCKPLANTCURVALINDCMMIM_TRANSSTOCKPLTCURVALINDCCURR23(2) Transfer Stock Plant Currency Value in Display Currency
STOCKINTRANSITCURVALINDCMMIM_STOCKINTRANSITCURVALINDCCURR23(2) Stock in Transit Currency Value in Display Currency
BLOCKEDSTOCKCURVALINDCMMIM_BLOCKEDSTOCKCURVALINDCCURR23(2) Blocked Stock Currency Value in Display Currency
RESTRICTEDSTOCKCURVALINDCMMIM_RESTRICTEDSTCURVALINDCCURR23(2) Restricted Stock Currency Value in Display Currency
TIEDEMPTIESSTOCKCURVALINDCMMIM_TIEDEMPTSTOCKCURVALINDCCURR23(2) Tied Empties Stock Currency Value in Display Currency
GRBLOCKEDSTOCKCURVALINDCMMIM_GRBLOCKSTOCKCURVALINDCCURR23(2) Goods Receipt Blocked Stock Currency Value in Display Cur.


View list of all S4 Hana tables