SAP MDMA Table in S/4 HANA - MRP Area for Material
MDMA is a standard SAP Table which is used to store MRP Area for Material data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MDMA table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MDMA
MDMA table structure field list
Below is the full MDMA 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) | T000 | MANDT | ||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
BERID | MRP Area | BERID | CHAR | 10(0) | MDLV | BERID | BERID | |||
WERKS | MRP area: Plant | WERKDP | CHAR | 4(0) | T001W | WERKS | ||||
DISPR | Material: MRP profile | DISPR | CHAR | 4(0) | MDIP | DISPR | DPR | |||
DISMM | MRP Type | DISMM | CHAR | 2(0) | T438A | DISMM | ||||
DISPO | MRP Controller | DISPO | CHAR | 3(0) | T024D | DISPO | DGR | HS_T024D | DISPO | |
DISGR | MRP Group | DISGR | CHAR | 4(0) | T438M | DISGR | ||||
MINBE | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | |||||
LFRHY | Planning cycle | LFRHY | CHAR | 3(0) | T439G | MRPPP | ||||
FXHOR | Planning time fence | FXHOR | NUMC | 3(0) | FXHOR | |||||
DISLS | Lot Sizing Procedure within Materials Planning | DISLS | CHAR | 2(0) | T439A | DISLS | ||||
RDPRF | Rounding Profile | RDPRF | CHAR | 4(0) | RDPR | RDPRF | ||||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | |||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | |||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | |||||
MABST | Maximum Stock Level | MABST | QUAN | 13(3) | MENG13 | |||||
TAKZT | Takt time | TAKZT | DEC | 3(0) | DEC3 | |||||
AUSSS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | |||||
SOBSL | Special procurement type | SOBSL | CHAR | 2(0) | T460A | SOBSL | ||||
LGPRO | Issue Storage Location | LGPRO | CHAR | 4(0) | MDLG | LGORT | ||||
LGFSB | Default storage location for external procurement | LGFSB | CHAR | 4(0) | MDLG | LGORT | ||||
MRPPP | PPC Planning Calendar | MRPPP | CHAR | 3(0) | T439G | MRPPP | ||||
EISBE | Safety stock | EISBE | QUAN | 13(3) | MENG13 | |||||
RWPRO | Range of coverage profile | RWPRO | CHAR | 3(0) | T438R | RWPRO | ||||
SHZET | Safety time (in workdays) | SHZET | NUMC | 2(0) | NUMC2 | |||||
BSTFE | Fixed lot size | BSTFE | QUAN | 13(3) | MENG13 | |||||
LOSFX | Lot-Size-Independent Costs | LOSFX | CURR | 11(2) | WERT11 | |||||
LAGPR | Storage Costs Percentage Code | LAGPR | CHAR | 1(0) | T439L | LAGPR | ||||
LGRAD | Service level | LGRAD | DEC | 3(1) | DEC2_1 | |||||
PROPR | Forecast profile | PROPR | CHAR | 4(0) | PROPR | PPR | ||||
VRBMT | Reference material for consumption | VRBMT | CHAR | 40(0) | MATN1 | MATNR | ||||
VRBDB | Reference MRP area - consumption | VRBDB | CHAR | 10(0) | BERID | |||||
VRBDT | To date of the material to be copied for consumption | VRBDT | DATS | 8(0) | DATUM | |||||
VRBFK | Multiplier for reference material for consumption | VRBFK | DEC | 4(2) | DEC2_2 | |||||
LOEKZ | Deletion Indicator | LVORM | CHAR | 1(0) | XFELD | |||||
SHPRO | Period Profile for Safety Time | SHPRO | CHAR | 3(0) | T438V | SHPRO | ||||
AHDIS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1(0) | AHDIS | |||||
AUTRU | Reset Forecast Model Automatically | AUTRU | CHAR | 1(0) | XFELD | |||||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15(0) | PSTAT | |||||
KZKFK | Indicator: take correction factors into account | KZKFK | CHAR | 1(0) | XFELD | |||||
SHFLG | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1(0) | SHFLG | |||||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1(0) | APOKZ | |||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
PLIFZX | Consider Planned Delivery Time of the MRP Area | MD_PLIFZ_DB | CHAR | 1(0) | MD_PLIFZ_DB | |||||
AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
AEDAT | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
AEZEIT | Time of Change | AEZEIT | TIMS | 6(0) | UHRZT | |||||
SCM_MATLOCID_GUID16 | Internal Key for Product | /SCMB/MDL_MATID | RAW | 16(0) | SYSUUID | |||||
SCM_MATLOCID_GUID22 | Internal Number (UID) for Location Product | /SAPAPO/MATLOCID | CHAR | 22(0) | /SAPAPO/MATLOCID | |||||
SCM_GRPRT | Goods Receipt Processing Time | /SAPAPO/GRPRT | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
SCM_GIPRT | Goods Issue Processing Time | /SAPAPO/GIPRT | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
SCM_RRP_TYPE | PP Planning Procedure | /SAPAPO/PPS_PLANNING_TYPE | CHAR | 1(0) | /SAPAPO/RRP_TYPE | RRP_TYPE | ||||
SCM_HEUR_ID | PPC Heuristics | /SAPAPO/PROD_HEUR_ID | CHAR | 12(0) | ||||||
SCM_PACKAGE_ID | Planning Package to Which Product Belongs | /SAPAPO/PROD_HEUR_PACKID | CHAR | 12(0) | /SAPAPO/PROD_HEUR_PACKID | PACKAGE_ID | ||||
SCM_CONHAP | Handling Capacity Consumption in Unit of Measure (Gds Rcpt) | /SAPAPO/SNPCONHAP | QUAN | 13(3) | MENG13 | |||||
SCM_HUNIT | Unit of Measure: Handling Capacity in Goods Receipt | /SAPAPO/HUNIT | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
SCM_CONHAP_OUT | Handling Capacity Consumption in Unit of Measure (Gds Issue) | /SAPAPO/SNPCONHAP_OUT | QUAN | 13(3) | MENG13 | |||||
SCM_HUNIT_OUT | Unit of Measure: Handling Capacity in Goods Issue | /SAPAPO/HUNIT_OUT | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
SCM_RRP_SEL_GROUP | Planning Group | /SAPAPO/RRP_SEL_GROUP | CHAR | 2(0) | /SAPAPO/RRP_SEL_GROUP | SEL_GROUP | ||||
SCM_LSUOM | Unit of Measure of Lot Size | /SAPAPO/LSUOM | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
SCM_REORD_DUR | Reorder Days' Supply (in Workdays) | /SAPAPO/REORD_DUR | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
SCM_TARGET_DUR | Target Days' Supply in Workdays | /SAPAPO/TARGET_DUR | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
SCM_TSTRID | Planning Calendar for Periodic Lot Sizing Procedure | /SAPAPO/LOT_TSTRID | CHAR | 10(0) | Assigned to domain | /SAPAPO/TSTRID | /SAPAPO/TSTRID | |||
SCM_THRUPUT_TIME | Throughput Time | /SAPAPO/THRUPUT_TIME | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
SCM_TPOP | Third-Party Order Processing | /SAPAPO/TPOP | CHAR | 2(0) | /SAPAPO/TPOP | |||||
SCM_SAFTY_V | Safety Stock for Virtual Child Location | SAFTYV | QUAN | 13(3) | MENG13 | |||||
SCM_PPSAFTYSTK | Safety Stock at Parent Location | PPSAFTYSTK | QUAN | 13(3) | MENG13 | |||||
SCM_PPSAFTYSTK_V | Safety Stock of Parent Location Virtual Child Location | PPSAFTYSTKV | QUAN | 13(3) | MENG13 | |||||
SCM_REPSAFTY | Repair Safety Stock | REPSAFTY | QUAN | 13(3) | MENG13 | |||||
SCM_REPSAFTY_V | Repair Safety Stock for Virtual Child Location | REPSAFTYV | QUAN | 13(3) | MENG13 | |||||
SCM_REORD_V | Reorder Point for Virtual Child Location | REORD_V | QUAN | 13(3) | MENG13 | |||||
SCM_MAXSTOCK_V | Maximum Stock Level for Virtual Child Locations | MAXSTOCK_V | QUAN | 13(3) | MENG13 | |||||
SCM_SCOST_PRCNT | Cost Factor for Stockholding Costs | /SAPAPO/PERCENT_SCOST | DEC | 3(2) | /SAPAPO/PERCENT_SCOST | |||||
SCM_PROC_COST | Procurement Costs for Product | /SAPAPO/PROC_COST | DEC | 13(3) | /SAPAPO/DEC13 | |||||
SCM_NDCOSTWE | Goods Receiving Costs (Network Design) | NDCOSTWE | DEC | 13(3) | ||||||
SCM_NDCOSTWA | Goods Issue Costs (Network Design) | NDCOSTWA | DEC | 13(3) |
Search for further information about these or an SAP related objects