SAP ABAP Table MDSA (Generated Table for View MDSA)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDSA	Table Relationship Diagram
Short Description	Generated Table for View MDSA

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

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	AUFNR	☑	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number
3	MATNR	☐	SA_MATNR	MATNR	CHAR	18	0	Material number	MARA
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
6	PHAS0	☐	SA_PHAS0	XFELD	CHAR	1	0	Indicator for blocking run schedule header
7	BSTMI	☐	SA_LOSVN	MENG13	QUAN	13	3	Lower value of the lot-size interval
8	BSTMA	☐	SA_LOSBS	MENG13	QUAN	13	3	Upper value of the lot-size interval
9	STDAY	☐	STDAY	DATUM	DATS	8	0	Start of the validity period of the RS header
10	ENDAY	☐	ENDAY	DATUM	DATS	8	0	End of validity period of the RS header
11	VERTO	☐	SA_VERTO	SA_VERTL	CHAR	4	0	Distribution key for quantity produced	T437V
12	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
13	STLAN	☐	STLAN	STLAN	CHAR	1	0	BOM Usage	T416
14	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
15	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
16	APLAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDSA	MANDT	T000	MANDT	KEY	1	CN
2	MDSA	MATNR	MARA	MATNR	KEY	1	CN
3	MDSA	PLNTY	TCA01	PLNTY	REF	C	CN
4	MDSA	STLAN	T416	STLAN	KEY	1	CN
5	MDSA	VERID	MKAL	VERID	KEY	1	CN
6	MDSA	VERTO	T437V	VERTL	KEY	1	CN
7	MDSA	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in