SAP S/4Hana table M61DM stores Material Master: MRPdata

  

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 M61DM 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 M61DM dictionary attributes

Object Name: M61DM
Dictionary Type: Structure
Description: Material Master: MRP


Field list for M61DM 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
MATNRMATNRCHAR40(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
WERKSWERKS_DCHAR4(0) T001WPlantWERKSWRKKCH_T001W_CWERKS
LVORMLVORMCHAR1(0) Deletion IndicatorXFELDMG
MAKTXMAKTXCHAR40(0) Material descriptionTEXT40MG
MTARTMTARTCHAR4(0) T134Material typeMTARTMTAMG
MATKLMATKLCHAR9(0) T023Material GroupMATKLMKLMGS_WBWGMATKL
MEINSMEINSUNIT3(0) T006Base Unit of MeasureMEINSMG
MMSTAMMSTACHAR2(0) T141Plant-Specific Material StatusMMSTAMG
DISMMDISMMCHAR2(0) T438AMRP TypeDISMMMG
BESKZBESKZCHAR1(0) Procurement TypeBESKZMBSMD
SOBSLSOBSLCHAR2(0) T460ASpecial procurement typeSOBSLMG
MISKZMISKZCHAR1(0) Mixed MRP indicatorMISKZMG
DISSTDISSTCHAR3(0) Low-Level CodeDISSTMD
SBDKZSBDKZCHAR1(0) Dependent requirements ind. for individual and coll. reqmtsSBDKZMG
KZBEDKZBEDCHAR1(0) Indicator for Requirements GroupingKZBEDMG
DISPODISPOCHAR3(0) T024DMRP ControllerDISPODGRMGHS_T024DDISPO
EKGRPEKGRPCHAR3(0) T024Purchasing GroupEKGRPEKGMG
KZDIEKZDIECHAR1(0) Indicator: MRP controller is buyer (deactivated)XFELDMG
DZEITDZEITDEC3(0) In-house production timeDEC3MG
BEARZBEARZDEC5(2) Processing timeDEC3_2MG
RUEZTRUEZTDEC5(2) Setup and teardown timeDEC3_2MG
TRANZTRANZDEC5(2) Interoperation timeDEC3_2MG
BASMGBASMGQUAN13(3) Base quantityMENG13MG
FHORIFHORICHAR3(0) T436AScheduling Margin Key for FloatsFHORIMG
PLIFZPLIFZDEC3(0) Planned Delivery Time in DaysDEC3MG
WEBAZWEBAZDEC3(0) Goods receipt processing time in daysDEC3MG
WZEITWZEITDEC3(0) Total replenishment lead time (in workdays)DEC3MG
PFREIPFREICHAR1(0) Indicator: automatic fixing of planned ordersXFELDMG
DISLSDISLSCHAR2(0) T439ALot Sizing Procedure within Materials PlanningDISLSMG
BSTFEBSTFEQUAN13(3) Fixed lot sizeMENG13MG
BSTMIBSTMIQUAN13(3) Minimum Lot SizeMENG13MG
BSTMABSTMAQUAN13(3) Maximum Lot SizeMENG13MG
BSTRFBSTRFQUAN13(3) Rounding value for purchase order quantityMENG13MG
MABSTMABSTQUAN13(3) Maximum Stock LevelMENG13MG
AUSSSAUSSSDEC5(2) Assembly scrap in percentDEC3_2MG
EISBEEISBEQUAN13(3) Safety stockMENG13MG
MINBEMINBEQUAN13(3) Reorder PointMENG13MG
LOSFXLOSFXCURR11(2) Lot-Size-Independent CostsWERT11MG
LAGPRLAGPRCHAR1(0) T439LStorage Costs Percentage CodeLAGPRMG
PROKZPROKZCHAR1(0) Forecast indicatorPROKZMG
PERKZPERKZCHAR1(0) Period IndicatorPERKZPKZMP
AUFTLAUFTLCHAR1(0) T439PSplitting IndicatorAUFTLMG
KZAUSKZAUSCHAR1(0) Discontinuation indicatorKZAUSMG
AUSDTAUSDTDATS8(0) Effective-Out DateDATUMMG
NFMATNFMATCHAR40(0) MARAFollow-Up MaterialMATNRMATMG
ALTSLALTSLCHAR1(0) Method for Selecting Alternative Bills of MaterialALTSLMG
BKLASBKLASCHAR4(0) T025Valuation ClassBKLASMG
VPRSVVPRSVCHAR1(0) Price control indicatorVPRSVMG
VERPRVERPRCURR11(2) Moving Average Price/Periodic Unit PriceWERT11VMG
STPRSSTPRSCURR11(2) Standard priceWERT11VMG
PEINHPEINHDEC5(0) Price unitPACK3MG
USEQUUSEQUCHAR1(0) TMQ2Quota arrangement usageUSEQUME
PERIVPERIVCHAR2(0) T009Fiscal Year VariantPERIVSAP
MTVFPMTVFPCHAR2(0) TMVFChecking Group for Availability CheckMTVFPVA
WERTUWERTUCHAR1(0) Value Updating in Material Master RecordXFELDMG
MENGUMENGUCHAR1(0) Quantity Updating in Material Master RecordXFELDMG
SAUFTSA_SAUFTCHAR1(0) Indicator: Repetitive Manufacturing AllowedXFELDMG
MRPPPMRPPPCHAR3(0) T439GPPC Planning CalendarMRPPPMD
LFRHYLFRHYCHAR3(0) T439GPlanning cycleMRPPP
DISGRDISGRCHAR4(0) T438MMRP GroupDISGRMD
PSTATPSTAT_DCHAR15(0) Maintenance statusPSTATMG
VRMODVRMODCHAR1(0) Consumption modeVRMODMD
VINT1VINT1NUMC3(0) Consumption period: backwardVRINTMD
VINT2VINT2NUMC3(0) Consumption period: forwardVRINTMD
FXHORFXHORNUMC3(0) Planning time fenceFXHORMD
QMATVQMATVCHAR1(0) Inspection Setup Exists for Material/PlantXFELD
PRGRPVPMATCHAR40(0) MARAPlanning materialMATNRMD
PRWRKVPWRKCHAR4(0) T001WPlanning plantWERKS
UMREFUMREFFFLTP16(16) Conversion factor: quantitiesFLTP
PRBMEPRBMEUNIT3(0) T006Base unit of measure for product groupMEINS
TAKZTTAKZTDEC3(0) Takt timeDEC3MG
FEVORFEVORCHAR3(0) T024FProduction SupervisorFEVORCFV
RWPRORWPROCHAR3(0) T438RRange of coverage profileRWPRO
KZREVKZREVCHAR1(0) Revision Level Has Been Assigned to the MaterialXFELD
KZKFGKZKFGCHAR1(0) Configurable MaterialXFELD
STDPDSTDPDCHAR40(0) MARAConfigurable materialMATNRMG
CUOBJCUOBMNUMC18(0) Internal object numberCUOBJ
CUOBFCUOBMNUMC18(0) Internal object numberCUOBJ
LGPROLGPROCHAR4(0) T001LIssue Storage LocationLGORT
SFEPRSFEPRCHAR4(0) T437SRepetitive Manufacturing ProfileSFEPR
RDPRFRDPRFCHAR4(0) Rounding ProfileRDPRF
STRGRSTRGRCHAR2(0) T461PPlanning Strategy GroupSTRGR
LGFSBLGFSBCHAR4(0) T001LDefault storage location for external procurementLGORT
BSTMEBSTMEUNIT3(0) T006Purchase Order Unit of MeasureMEINSME
AUSMEAUSMEUNIT3(0) T006Unit of issueMEINSMG
EXPMEEXPMEUNIT3(0) T006Unit of measure for commodity code (foreign trade)MEINSMG
FRTMEFRTMEUNIT3(0) T006Production unitMEINSMG
SERNPSERAILCHAR4(0) T377PSerial Number ProfileSERAIL
EPRIOEPRIOCHAR4(0) Withdrawal Sequence Group for StocksEPRIO
CUOBVCUOBVNUMC18(0) Internal object number of configurable material for planningCUOBJ
BSEXTBSEXTCHAR1(0) External Purchase Orders AllowedBSEXTMG
BSINTBSINTCHAR1(0) Internal purchase orders allowedBSINTMG
KZGRPKZGRPCHAR1(0) Grouping indicatorKZGRP
INSMKINSMKCHAR1(0) Stock TypeINSMKMG
RESVPRESVPDEC3(0) Period of adjustment for planned independent requirementsRESVP
XCHPFXCHPFCHAR1(0) Batch management requirement indicatorXFELDMG
SHFLGSHFLGCHAR1(0) Safety time indicator (with or without safety time)SHFLG
SHZETSHZETNUMC2(0) Safety time (in workdays)NUMC2
MDACHMDACHCHAR2(0) T46ACAction control: planned order processingMDACH
BWSCLBWSCLCHAR1(0) Source of SupplyBQSCLMW
SPARTSPARTCHAR2(0) DivisionSPARTSPAVC_SPARTSPART
ATTYPATTYPCHAR2(0) Material CategoryATTYPMTY
SATNRSATNRCHAR40(0) Cross-Plant Configurable MaterialMATNR
KZWSMKZWSOCHAR1(0) Units of measure usageKZWSO
FABKZFABKZCHAR1(0) Indicator: Item Relevant to JIT Delivery SchedulesFABKZ
SERLVSERLVCHAR1(0) Level of Explicitness for Serial NumberSERLV
VSPVBVSPVBCHAR10(0) PVBEProposed Supply Area in Material Master RecordPRVBE
DPLFSDPLFSCHAR2(0) Fair share ruleDPLFS
DPLPUDPLPUCHAR1(0) Indicator: push distributionDPLPU
DPLHODPLHODEC3(0) Deployment horizon in daysDEC3
MMSTDMMSTDDATS8(0) Date from Which the Plant-Specific Material Status Is ValidDATUMMG
MSTAEMSTAECHAR2(0) T141Cross-Plant Material StatusMMSTAH_T141MMSTA
MSTDEMSTDEDATS8(0) Date from which the cross-plant material status is validDATUM
MFRPNMFRPNCHAR40(0) Manufacturer Part NumberCHAR40
MFRNRMFRNRCHAR10(0) Manufacturer numberLIFNR
MPROFMPROFCHAR4(0) Mfr part profileMPROF
PRCTRPRCTRCHAR10(0) Profit CenterPRCTRPRCKEPRCTR_EMPTYPRCTR
KZEFFCC_MTEFFCHAR1(0) Assign effectivity parameter values/ override change numbersXFELD
MAABCMAABCCHAR1(0) TMABCABC IndicatorMAABCMG
SHPROSHPROCHAR3(0) Period Profile for Safety TimeSHPRO
DIBERDIBERCHAR1(0) Indicator: MRP area existsXFELD
AHDISAHDISCHAR1(0) MRP relevancy for dependent requirementsAHDIS
APOKZAPOKZCHAR1(0) Indicator: Is material relevant for APOAPOKZ
SCHGTSCHGTCHAR1(0) Indicator: bulk materialXFELDCS
BERIDBERIDCHAR10(0) MRP AreaBERIDBERID
KZPSPKZPSPCHAR1(0) Indicator for cross-project materialKZPSP
EISLOEISLOQUAN13(3) Minimum Safety StockMENG13
BFLMEBFLMECHAR1(0) Generic Material with Logistical VariantsBFLME
SGT_RELSGT_RELCHAR1(0) Segmentation RelevantCHAR1
SGT_COVSSGT_COVSCHAR8(0) Segmentation StrategySGT_COVSSGT_ESGT_COVS_SHLPSGT_COVS
SGT_STATCSGT_STATCCHAR1(0) Segmentation StatusSGT_STAT
SGT_PRCMSGT_PRCMCHAR1(0) Consumption PrioritySGT_PRCM
SGT_SCOPESGT_SCOPECHAR1(0) Segmentation Strategy ScopeSGT_SCOPE
SGT_STK_PRTSGT_STK_PRTCHAR1(0) Stock Protection IndicatorSGT_STK_PRT
SGT_MRPSISGT_MRPSICHAR1(0) Sort Stock based on SegmentSGT_ATPSI
PPSKZPPSKZCHAR1(0) Indicator for Advanced PlanningBOOLE
.INCLU--AP0(0)
FSH_MG_ARUN_REQFSH_MG_ARUN_REQCHAR1(0) Supply Assignment (ARun)FSH_MG_ARUN_REQ
FPRFMFPRFMCHAR3(0) Distribution profile of material in plantMPPRF
.INCLU--AP0(0)
IMATNIMATNCHAR40(0) FFF classMATNR
PICNUMPIC_PICNUM_SUSCHAR40(0) Supersession chain numberPIC_PICNUMPIC_PICNUMPICNUM


View list of all S4 Hana tables