SAP ABAP Table CIFMDMAVR (Versions of Table MDMA)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-MRP (Application Component) Material Requirements Planning
     ⤷ MDCI (Package) Planned Orders APO Core Interface Add-Ons

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CIFMDMAVR	Table Relationship Diagram
Short Description	Versions of Table MDMA

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20030602
SAP Release Created in	2002_1_46C