SAP ABAP Table MDMA (MRP Area for Material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MDMA	Table Relationship Diagram
Short Description	MRP Area for Material

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	BERID	☑	BERID	BERID	CHAR	10	0	MRP Area	MDLV
4	WERKS	☐	WERKDP	WERKS	CHAR	4	0	MRP area: Plant	T001W
5	DISPR	☐	DISPR	DISPR	CHAR	4	0	Material: MRP profile	MDIP
6	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
7	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
8	DISGR	☐	DISGR	DISGR	CHAR	4	0	MRP Group	T438M
9	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
10	LFRHY	☐	LFRHY	MRPPP	CHAR	3	0	Planning cycle	T439G
11	FXHOR	☐	FXHOR	FXHOR	NUMC	3	0	Planning time fence
12	DISLS	☐	DISLS	DISLS	CHAR	2	0	Lot size (materials planning)	T439A
13	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
14	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
15	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
16	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
17	MABST	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
18	TAKZT	☐	TAKZT	DEC3	DEC	3	0	Takt time
19	AUSSS	☐	AUSSS	DEC3_2	DEC	5	2	Assembly scrap in percent
20	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
21	LGPRO	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	MDLG
22	LGFSB	☐	LGFSB	LGORT	CHAR	4	0	Default storage location for external procurement	MDLG
23	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	T439G
24	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
25	RWPRO	☐	RWPRO	RWPRO	CHAR	3	0	Range of coverage profile	T438R
26	SHZET	☐	SHZET	NUMC2	NUMC	2	0	Safety time (in workdays)
27	BSTFE	☐	BSTFE	MENG13	QUAN	13	3	Fixed lot size
28	LOSFX	☐	LOSFX	WERT11	CURR	11	2	Ordering costs
29	LAGPR	☐	LAGPR	LAGPR	CHAR	1	0	Storage costs indicator	T439L
30	LGRAD	☐	LGRAD	DEC2_1	DEC	3	1	Service level
31	PROPR	☐	PROPR	PROPR	CHAR	4	0	Forecast profile	*
32	VRBMT	☐	VRBMT	MATNR	CHAR	18	0	Reference material for consumption	*
33	VRBDB	☐	VRBDB	BERID	CHAR	10	0	Reference MRP area - consumption	*
34	VRBDT	☐	VRBDT	DATUM	DATS	8	0	To date of the material to be copied for consumption
35	VRBFK	☐	VRBFK	DEC2_2	DEC	4	2	Multiplier for reference material for consumption
36	LOEKZ	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
37	SHPRO	☐	SHPRO	SHPRO	CHAR	3	0	Period profile for safety time	T438V
38	AHDIS	☐	AHDIS	AHDIS	CHAR	1	0	MRP relevancy for dependent requirements
39	AUTRU	☐	AUTRU	XFELD	CHAR	1	0	Reset forecast model automatically
40	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
41	KZKFK	☐	KZKFK	XFELD	CHAR	1	0	Indicator: take correction factors into account
42	SHFLG	☐	SHFLG	SHFLG	CHAR	1	0	Safety time indicator (with or without safety time)
43	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
44	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
45	PLIFZX	☐	MD_PLIFZ_DB	MD_PLIFZ_DB	CHAR	1	0	Consider Planned Delivery Time of the MRP Area

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDMA	BERID	MDLV	BERID	KEY	1	CN
2	MDMA	DISGR	T438M	MTART	REF	C	CN
3	MDMA	DISLS	T439A	DISLS	REF	C	CN
4	MDMA	DISMM	T438A	DISMM	REF	1	CN
5	MDMA	DISPO	T024D	DISPO	REF	C	CN
6	MDMA	DISPR	MDIP	DISPR		1	CN
7	MDMA	LAGPR	T439L	LAGPR	REF	C	CN
8	MDMA	LFRHY	T439G	MRPPP		1	CN
9	MDMA	LGFSB	MDLG	LGORT	KEY	C	CN
10	MDMA	LGPRO	MDLG	LGORT	KEY	C	CN
11	MDMA	MANDT	T000	MANDT		1	CN
12	MDMA	MATNR	MARA	MATNR
13	MDMA	MRPPP	T439G	MRPPP	REF	C	CN
14	MDMA	RDPRF	RDPR	RDPRF
15	MDMA	RWPRO	T438R	RWPRO	REF	C	CN
16	MDMA	SHPRO	T438V	SHPRO
17	MDMA	SOBSL	T460A	SOBSL	REF	C	CN
18	MDMA	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20100310
SAP Release Created in