MDSU_DB - MDSU DB table

MDSU DB table information is stored in SAP table MDSU_DB.
It is part of development package ODATA_PP_MRP in software component PP-FIO. This development package consists of objects that can be grouped under "OData Services for Material Requirements Planning".

Fields for table MDSU_DB

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	S_MANDT	CLNT	6
MATNR	Material Number	X	MATNR	CHAR	80
PLANT	Plant	X	WERKS_D	CHAR	8
LINE	Numeric field length 8	X	NUM08	NUMC	16
PLAAB	Material requirements planning segment		PLAAB	NUMC	4
PLANR	Planning segment number		PLANR	CHAR	40
SORT0	Numeric field length 8		NUM08	NUMC	16
DELKZ	MRP element		DELKZ	CHAR	4
DAT00	Receipt/Requirements date		DAT00	DATS	16
PERKZ	Period Indicator		PERKZ	CHAR	2
PRPER	Forecast period		PRPER	NUMC	12
ANZFD	Number of workdays per period		ANZFD	DEC	3
EXTSU	Period or Segment		EXTSU	CHAR	44
MNG01	Planned independent requirements		MNG07	QUAN	7
MNG02	Requirement		MNG08	QUAN	7
MNG03	Receipts		MNG09	QUAN	7
MNG04	Available quantity		MNG10	QUAN	7
MNG05	ATP quantity		MNG11	QUAN	7
MNG06	Sum of receipts that are not available		MNG12	QUAN	7
MNG07	Total of non-available issues		MNG13	QUAN	7
ISTRW	Statistical range of coverage (range of coverage profile)		ISTRW	DEC	3
SLRWX	Target range of coverage		SLRWX	NUMC	4
MIRWX	Minimum range of coverage		MIRWX	NUMC	4
MARWX	Maximum range of coverage		MARWX	NUMC	4
SLBES	Target Stock Level		SLBES	QUAN	7
MDBES	Minimum stock		MDBES	QUAN	7
MXBES	Maximum Stock Level		MXBES	QUAN	7
TGBED	Average daily requirements		TGBED	QUAN	7
TGPRO	Average daily production quantity		TGPRO	QUAN	7
BERW1	Actual Range of Coverage		BERW3	DEC	3
BERW2	First Receipt Days' Supply		BERW2	DEC	3
ANZBV	Number of order proposals per period		ANZBV	NUMC	6
AZZUG	Number of receipts per period		AZZUG	NUMC	10
ALINE	Line index for internal table processing		XLINE	INT4	4
ELINE	Line index for internal table processing		XLINE	INT4	4
FBYTE	Single-Character Flag		CHAR1	CHAR	2
AKZ01	Exceptions in column		AUSKZ	CHAR	2
AKZ02	Exceptions in column		AUSKZ	CHAR	2
AKZ03	Exceptions in column		AUSKZ	CHAR	2
AKZ04	Exceptions in column		AUSKZ	CHAR	2
USEX1	Quantity field for user exit		USEXQ	QUAN	7
USEX2	Quantity field for user exit		USEXQ	QUAN	7
USEX3	Field to be filled by user exit		USEEX	CHAR	60
DETAIL_ICON	Carrier field for icons		ICON_TEXT	CHAR	264