SAP ABAP Table MLSTR (Milestone structure for project reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	INTTAB	Structure
Structure	MLSTR	Table Relationship Diagram
Short Description	Milestone structure for project reporting

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	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
2	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
3	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
4	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
5	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
6	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
7	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
8	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
9	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
10	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
11	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
12	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
13	MLST_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
14	AUARTTXT	☐	AUART_BEZ	TEXT20	CHAR	20	0	Description of sales order type
15	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
16	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
17	MLSTXT	☐	PS_MLSTTXT	TEXT40	CHAR	40	0	Milestone description
18	TEDAT	☐	MLST_TEDAT	DATUM	DATS	8	0	Scheduled milestone date (Basic)
19	TETIM	☐	MLST_TETIM	ATIME	TIMS	6	0	Scheduled milestone time (Basic)
20	TPDAT	☐	MLST_TPDAT	DATUM	DATS	8	0	Scheduled milestone date (Forecast)
21	TPTIM	☐	MLST_TPTIM	ATIME	TIMS	6	0	Scheduled milestone time (Forecast)
22	EDATU	☐	MLST_EDATU	DATUM	DATS	8	0	Fixed milestone date (basic)
23	EZEIT	☐	MLST_EZEIT	ATIME	TIMS	6	0	Fixed milestone time (Basic)
24	PDATU	☐	MLST_PDATU	DATUM	DATS	8	0	Fixed milestone date (F)
25	PZEIT	☐	MLST_PZEIT	ATIME	TIMS	6	0	Fixed milestone time (F)
26	LATED	☐	MLST_LATE	FLAG	CHAR	1	0	Indicator: Latest dates
27	DLTAS	☐	MLST_DLTAS	FLAG	CHAR	1	0	Ind: Reference for offset (start/finish activity date)
28	DELTA	☐	MLST_DELTA	VNZTV	QUAN	5	0	Offset for milestone date
29	DELTE	☐	MLST_DELTE	MEINS	UNIT	3	0	Time unit for offset of milestone date	T006
30	PRCNT	☐	MLST_PRCNT	MLST_PRCNT	DEC	3	0	Percentual offset of milestone to activity date
31	KZ_TREND	☐	MLST_TREND	FLAG	CHAR	1	0	Milestone relevant for trend analysis
32	KZ_LSTWR	☐	MLST_LSTWR	FLAG	CHAR	1	0	Milestone relevant for progress analysis
33	KZ_WFLOW	☐	MLST_WFLOW	FLAG	CHAR	1	0	Indicator: Milestone is used for milestone functions
34	KZ_FAKTP	☐	MLST_FAKTP	FLAG	CHAR	1	0	Milestone is relevant for date in sales document
35	KZ_FRMST	☐	MLST_FRMST	FLAG	CHAR	1	0	Release stop indicator
36	LST_FERTG	☐	MLST_FERTG	PROZENT100	NUMC	3	0	Percentage of completion (%)
37	LST_ACTDT	☐	MLST_ACTDT	DATUM	DATS	8	0	Actual date (Milestone met)
38	LST_ACTTM	☐	MLST_ACTTM	ATIME	TIMS	6	0	Actual date/time (Milestone met)
39	TASK_ID	☐	MLST_TASK	HROBJEC_14	CHAR	14	0	Workflow task
40	RELSU	☐	MLST_RELSU	FLAG	CHAR	1	0	Selection function
41	RELMS	☐	MLST_RELMS	FLAG	CHAR	1	0	Selection function
42	INCPN	☐	MLST_INCPN	FLAG	CHAR	1	0	Selection function
43	INCNW	☐	MLST_INCNW	FLAG	CHAR	1	0	Selection function
44	INCSN	☐	MLST_INCSN	FLAG	CHAR	1	0	Selection function
45	WKFLW	☐	MLST_WKFLW	FLAG	CHAR	1	0	Selection function
46	RELSU_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
47	RELMS_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
48	INCNW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
49	INCPN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
50	INCSN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
51	WKFLW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
52	RELSU_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
53	RELMS_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
54	INCNW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
55	INCPN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
56	INCSN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
57	WKFLW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
58	RELSU_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
59	RELMS_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
60	INCPN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
61	INCNW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
62	INCSN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
63	WKFLW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
64	RELSU_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
65	RELMS_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
66	INCPN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
67	INCNW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
68	INCSN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
69	WKFLW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
70	RELSU_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
71	RELMS_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
72	INCPN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
73	INCNW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
74	INCSN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
75	WKFLW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
76	KTEXT	☐	MLST_KTEXT	TEXT40	CHAR	40	0	Description
77	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
78	FRUEHER	☐	FRUEHER_2	DAUER_9_1	QUAN	10	1	Actual start is before earliest scheduled start
79	SPAETER	☐	SPAETER_2	DAUER_9_1	QUAN	10	1	Actual Finish/Planned Finish After Latest Scheduled Finish
80	VERZUG	☐	VERZUG_2	DAUER_9_1	QUAN	10	1	Duration After Latest Scheduled Finish
81	VORBEI	☐	VORBEI_2	DAUER_9_1	QUAN	10	1	Duration After Earliest Scheduled Start
82	VEINH	☐	VERZ_EINHT	MEINS	UNIT	3	0	Unit for Duration of the Delay	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MLSTR	AENNR	AENR	AENNR
2	MLSTR	AUFNR	AUFK	AUFNR	REF	C	CN
3	MLSTR	DELTE	T006	MSEHI	REF	C	CN
4	MLSTR	KDAUF	VBUK	VBELN	REF	C	CN
5	MLSTR	KDPOS	VBUP	POSNR	REF	C	CN
6	MLSTR	LTXSP	T002	SPRAS	REF	C	CN
7	MLSTR	MLSTN	T433	MLSTN	REF	C	CN
8	MLSTR	PRCTR	CEPC	PRCTR	REF	C	CN
9	MLSTR	PRNAM	IMTP	PRNAM			CN
10	MLSTR	VEINH	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in