1. Home
  2. Resources
  3. SAP Tables
  4. MDMA_UEB - MDMA Extended by Include MUEB_REST and BERTY

SAP Table MDMA_UEB

MDMA Extended by Include MUEB_REST and BERTY

MDMA_UEB (MDMA Extended by Include MUEB_REST and BERTY) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDMA_UEB to other SAP tables.

MDMA_UEB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
BERID MRP Area BERID MDLV CHAR 10 0
WERKS MRP area: Plant WERKDP T001W CHAR 4 0
DISPR Material: MRP profile DISPR MDIP CHAR 4 0
DISMM MRP Type DISMM T438A CHAR 2 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
DISGR MRP Group DISGR T438M CHAR 4 0
MINBE Reorder Point MINBE QUAN 13 3
LFRHY Planning cycle LFRHY T439G CHAR 3 0
FXHOR Planning time fence FXHOR NUMC 3 0
DISLS Lot size (materials planning) DISLS T439A CHAR 2 0
RDPRF Rounding Profile RDPRF RDPR CHAR 4 0
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
MABST Maximum stock level MABST QUAN 13 3
TAKZT Takt time TAKZT DEC 3 0
AUSSS Assembly scrap in percent AUSSS DEC 5 2
SOBSL Special procurement type SOBSL T460A CHAR 2 0
LGPRO Issue Storage Location LGPRO MDLG CHAR 4 0
LGFSB Default storage location for external procurement LGFSB MDLG CHAR 4 0
MRPPP PPC planning calendar MRPPP T439G CHAR 3 0
EISBE Safety Stock EISBE QUAN 13 3
RWPRO Range of coverage profile RWPRO T438R CHAR 3 0
SHZET Safety time (in workdays) SHZET NUMC 2 0
BSTFE Fixed lot size BSTFE QUAN 13 3
LOSFX Ordering costs LOSFX CURR 11 2
LAGPR Storage costs indicator LAGPR T439L CHAR 1 0
LGRAD Service level LGRAD DEC 3 1
PROPR Forecast profile PROPR CHAR 4 0
VRBMT Reference material for consumption VRBMT CHAR 18 0
VRBDB Reference MRP area - consumption VRBDB CHAR 10 0
VRBDT To date of the material to be copied for consumption VRBDT DATS 8 0
VRBFK Multiplier for reference material for consumption VRBFK DEC 4 2
LOEKZ Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
SHPRO Period Profile for Safety Time SHPRO T438V CHAR 3 0
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
AUTRU Reset Forecast Model Automatically AUTRU CHAR 1 0
X Yes
NULL No
PSTAT Maintenance status PSTAT_D CHAR 15 0
KZKFK Indicator: take correction factors into account KZKFK CHAR 1 0
X Yes
NULL No
SHFLG Safety time indicator (with or without safety time) SHFLG CHAR 1 0
NULL Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
PLIFZX Consider Planned Delivery Time of the MRP Area MD_PLIFZ_DB CHAR 1 0
NULL Use Planned Delivery Time of the Plant
X Use Planned Delivery Time of the MRP Area
BERTY Type of MRP area BERTY NUMC 2 0
01 Plant
02 Storage location
03 Vendor
TRANC Transaction counter for data transfer TRANSCOUNT NUMC 10 0
D_IND Which number within a transaction must be reset? M_DELIND NUMC 10 0

MDMA_UEB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDMA_UEB BERID MDMA_UEB MANDT MDLV Customizing MRP Area MANDT
MDMA_UEB BERID MDMA_UEB BERID MDLV Customizing MRP Area BERID
MDMA_UEB DISGR MDMA_UEB DISGR T438M Control Parameter for MRP -Material Level- MTART
MDMA_UEB DISGR MDMA_UEB MANDT T438M Control Parameter for MRP -Material Level- MANDT
MDMA_UEB DISGR MDMA_UEB WERKS T438M Control Parameter for MRP -Material Level- WERKS
MDMA_UEB DISLS MDMA_UEB MANDT T439A MRP Lot Sizes MANDT
MDMA_UEB DISLS MDMA_UEB DISLS T439A MRP Lot Sizes DISLS
MDMA_UEB DISMM MDMA_UEB MANDT T438A MRP Type MANDT
MDMA_UEB DISMM MDMA_UEB DISMM T438A MRP Type DISMM
MDMA_UEB DISPO MDMA_UEB DISPO T024D MRP controllers DISPO
MDMA_UEB DISPO MDMA_UEB MANDT T024D MRP controllers MANDT
MDMA_UEB DISPO MDMA_UEB WERKS T024D MRP controllers WERKS
MDMA_UEB DISPR MDMA_UEB MANDT MDIP Material: MRP Profiles (Field Contents) MANDT
MDMA_UEB DISPR MDMA_UEB DISPR MDIP Material: MRP Profiles (Field Contents) DISPR
MDMA_UEB LAGPR MDMA_UEB WERKS T439L Warehouse costs for MRP lot size WERKS
MDMA_UEB LAGPR MDMA_UEB LAGPR T439L Warehouse costs for MRP lot size LAGPR
MDMA_UEB LAGPR MDMA_UEB MANDT T439L Warehouse costs for MRP lot size MANDT
MDMA_UEB LFRHY MDMA_UEB LFRHY T439G PPplanning periods: header table MRPPP
MDMA_UEB LFRHY MDMA_UEB MANDT T439G PPplanning periods: header table MANDT
MDMA_UEB LFRHY MDMA_UEB WERKS T439G PPplanning periods: header table WERKS
MDMA_UEB LGFSB MDMA_UEB LGFSB MDLG Customizing: MRP Area Storage Location LGORT
MDMA_UEB LGFSB MDMA_UEB MANDT MDLG Customizing: MRP Area Storage Location MANDT
MDMA_UEB LGFSB MDMA_UEB BERID MDLG Customizing: MRP Area Storage Location BERID
MDMA_UEB LGFSB MDMA_UEB WERKS MDLG Customizing: MRP Area Storage Location WERKS
MDMA_UEB LGPRO MDMA_UEB MANDT MDLG Customizing: MRP Area Storage Location MANDT
MDMA_UEB LGPRO MDMA_UEB BERID MDLG Customizing: MRP Area Storage Location BERID
MDMA_UEB LGPRO MDMA_UEB WERKS MDLG Customizing: MRP Area Storage Location WERKS
MDMA_UEB LGPRO MDMA_UEB LGPRO MDLG Customizing: MRP Area Storage Location LGORT
MDMA_UEB MANDT MDMA_UEB MANDT T000 Clients MANDT
MDMA_UEB MATNR MDMA_UEB MANDT MARA General Material Data MANDT
MDMA_UEB MATNR MDMA_UEB MATNR MARA General Material Data MATNR
MDMA_UEB MRPPP MDMA_UEB MANDT T439G PPplanning periods: header table MANDT
MDMA_UEB MRPPP MDMA_UEB WERKS T439G PPplanning periods: header table WERKS
MDMA_UEB MRPPP MDMA_UEB MRPPP T439G PPplanning periods: header table MRPPP
MDMA_UEB RDPRF SYST MANDT RDPR Rounding profile MANDT
MDMA_UEB RDPRF * RDPR Rounding profile WERKS
MDMA_UEB RDPRF MDMA_UEB RDPRF RDPR Rounding profile RDPRF
MDMA_UEB RDPRF * RDPR Rounding profile RDZAE
MDMA_UEB RWPRO MDMA_UEB MANDT T438R Range of coverage profile MANDT
MDMA_UEB RWPRO MDMA_UEB WERKS T438R Range of coverage profile WERKS
MDMA_UEB RWPRO MDMA_UEB RWPRO T438R Range of coverage profile RWPRO
MDMA_UEB SHPRO MDMA_UEB SHPRO T438V Period Profile for Safety Time SHPRO
MDMA_UEB SHPRO MDMA_UEB MANDT T438V Period Profile for Safety Time MANDT
MDMA_UEB SHPRO MDMA_UEB WERKS T438V Period Profile for Safety Time WERKS
MDMA_UEB SOBSL MDMA_UEB MANDT T460A Special procurement key MANDT
MDMA_UEB SOBSL MDMA_UEB WERKS T460A Special procurement key WERKS
MDMA_UEB SOBSL MDMA_UEB SOBSL T460A Special procurement key SOBSL
MDMA_UEB WERKS MDMA_UEB MANDT T001W Plants/Branches MANDT
MDMA_UEB WERKS MDMA_UEB WERKS T001W Plants/Branches WERKS