SAP ABAP Table PSHLP_TREX_MLST_ST (Milestone structure for TREX)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS (Application Component) Project System
     ⤷ PS_HLP_CACHE (Package) Handling Large Projects:-Cache

Basic Data

Table Category	INTTAB	Structure
Structure	PSHLP_TREX_MLST_ST	Table Relationship Diagram
Short Description	Milestone structure for TREX

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	MLST_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
2	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
3	.INCLUDE	☐				0	0	Milestone (include structure)
4	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
5	TECHV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
6	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
7	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
8	MLSTN	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
9	USERH	☐	MLST_USERH	UNAME	CHAR	12	0	Milestone created by
10	DATEH	☐	MLST_DATEH	DATUM	DATS	8	0	Milestone created on
11	USERV	☐	MLST_USERV	UNAME	CHAR	12	0	Milestone changed by
12	DATEV	☐	MLST_DATEV	DATUM	DATS	8	0	Milestone changed on
13	PLNNR	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
14	PLNTY	☐	CN_PLNTY	PLNTY	CHAR	1	0	Standard network type	TCA01
15	PLNAL	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
16	PLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
17	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
18	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
19	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
20	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
21	TEDAT	☐	MLST_TEDAT	DATUM	DATS	8	0	Scheduled milestone date (Basic)
22	TETIM	☐	MLST_TETIM	ATIME	TIMS	6	0	Scheduled milestone time (Basic)
23	TPDAT	☐	MLST_TPDAT	DATUM	DATS	8	0	Scheduled milestone date (Forecast)
24	TPTIM	☐	MLST_TPTIM	ATIME	TIMS	6	0	Scheduled milestone time (Forecast)
25	EDATU	☐	MLST_EDATU	DATUM	DATS	8	0	Fixed milestone date (basic)
26	EZEIT	☐	MLST_EZEIT	ATIME	TIMS	6	0	Fixed milestone time (Basic)
27	PDATU	☐	MLST_PDATU	DATUM	DATS	8	0	Fixed milestone date (F)
28	PZEIT	☐	MLST_PZEIT	ATIME	TIMS	6	0	Fixed milestone time (F)
29	LATED	☐	MLST_LATE	FLAG	CHAR	1	0	Indicator: Latest dates
30	DLTAS	☐	MLST_DLTAS	FLAG	CHAR	1	0	Ind: Reference for offset (start/finish activity date)
31	DELTA	☐	MLST_DELTA	VNZTV	QUAN	5	0	Offset for milestone date
32	DELTE	☐	MLST_DELTE	MEINS	UNIT	3	0	Time unit for offset of milestone date	T006
33	PRCNT	☐	MLST_PRCNT	MLST_PRCNT	DEC	3	0	Percentual offset of milestone to activity date
34	SDDAT	☐	MLST_SDDAT	MLST_SDDAT	CHAR	2	0	Key determining the date for milestone in sales order
35	KZ_TREND	☐	MLST_TREND	FLAG	CHAR	1	0	Milestone relevant for trend analysis
36	KZ_LSTWR	☐	MLST_LSTWR	FLAG	CHAR	1	0	Milestone relevant for progress analysis
37	KZ_WFLOW	☐	MLST_WFLOW	FLAG	CHAR	1	0	Indicator: Milestone is used for milestone functions
38	KZ_FAKTP	☐	MLST_FAKTP	FLAG	CHAR	1	0	Milestone is relevant for date in sales document
39	KZ_FRMST	☐	MLST_FRMST	FLAG	CHAR	1	0	Release stop indicator
40	LST_FERTG	☐	MLST_FERTG	PROZENT100	NUMC	3	0	Percentage of completion (%)
41	LST_ACTDT	☐	MLST_ACTDT	DATUM	DATS	8	0	Actual date (Milestone met)
42	LST_ACTTM	☐	MLST_ACTTM	ATIME	TIMS	6	0	Actual date/time (Milestone met)
43	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
44	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
45	AUART_ICNW	☐	MLST_AUART	AUFART	CHAR	4	0	Network type	T003O
46	STDNR_ICNW	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
47	ALTNR_ICNW	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
48	STDNR_ICPN	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
49	ALTNR_ICPN	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
50	VORNR_ICPN	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
51	STDNR_ICSN	☐	CN_PLNNR	PLNNR	CHAR	8	0	Standard network number
52	ALTNR_ICSN	☐	CN_PLNAL	ALTNR	CHAR	2	0	Alternative to a standard network
53	OPRST_ICSN	☐	OPR_START	VORNR	CHAR	4	0	Activity preceding the standard network to be included
54	OPREN_ICSN	☐	OPR_END	VORNR	CHAR	4	0	Activity following the standard network to be included
55	TASK_ID	☐	MLST_TASK	HROBJEC_14	CHAR	14	0	Workflow task
56	RELSU	☐	MLST_RELSU	FLAG	CHAR	1	0	Selection function
57	RELMS	☐	MLST_RELMS	FLAG	CHAR	1	0	Selection function
58	INCPN	☐	MLST_INCPN	FLAG	CHAR	1	0	Selection function
59	INCNW	☐	MLST_INCNW	FLAG	CHAR	1	0	Selection function
60	INCSN	☐	MLST_INCSN	FLAG	CHAR	1	0	Selection function
61	WKFLW	☐	MLST_WKFLW	FLAG	CHAR	1	0	Selection function
62	RELSU_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
63	RELMS_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
64	INCPN_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
65	INCNW_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
66	INCSN_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
67	WKFLW_AL	☐	ACTLV	CHAR1	CHAR	1	0	Processing stage
68	RELSU_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
69	RELMS_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
70	INCPN_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
71	INCNW_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
72	INCSN_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
73	WKFLW_SS	☐	SYSTA	J_STATUS	CHAR	5	0	Function - activated system status
74	RELSU_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
75	RELMS_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
76	INCPN_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
77	INCNW_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
78	INCSN_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
79	WKFLW_US	☐	USSTA	J_STATUS	CHAR	5	0	Function - activated user status
80	RELSU_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
81	RELMS_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
82	INCPN_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
83	INCNW_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
84	INCSN_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
85	WKFLW_SM	☐	SESMA	SELID	CHAR	7	0	Selection profile (status)	TJ48
86	RELSU_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
87	RELMS_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
88	INCPN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
89	INCNW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
90	INCSN_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
91	WKFLW_CH	☐	CHANG	FLDSE	CHAR	1	0	Status change triggering the function
92	RELSU_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
93	RELMS_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
94	INCPN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
95	INCNW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
96	INCSN_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
97	WKFLW_SG	☐	SGACT	FLAG	CHAR	1	0	Ind: Function should only be executed once
98	RELSU_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
99	RELMS_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
100	INCPN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
101	INCNW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
102	INCSN_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
103	WKFLW_TR	☐	TRIGG	MLST_TRIG	CHAR	1	0	Activate function
104	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
105	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	TJ20
106	SPSNR	☐	PS_SPSNR	PS_SPSNR	NUMC	8	0	Std WBS: Internal project item number (w/exit on ID)	PRPSS
107	FPROZ	☐	FPROZ	PRZ32	DEC	5	2	Percentage of value to be billed
108	COMP_RES	☐	OCM_COMP_RES	OCM_COMP_RES	CHAR	1	0	OCM: Result of comparison of two order objects
109	CH_PROC	☐	OCM_CH_PROC	OCM_CH_PROC	CHAR	1	0	Process that has lead to the change of an object
110	.INCLUDE	☐				0	0	Include miolestones for versions
111	VSNMR	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
112	.INCLUDE	☐				0	0	Milestone original key
113	MLST_ZAEHL_ORG	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
114	ZAEHL_EXT_ORG	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
115	MLST_ZAEHL_EXT	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
116	ZAEHL_EXT	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
117	.INCLUDE	☐				0	0	Extra fields for update milestones
118	SN_VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
119	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
120	NW_VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
121	STTXT	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
122	SSTA	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
123	ASTA	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
124	ACTLV	☐	MLST_ACTLV	CHAR25	CHAR	25	0	Processing stage of the function
125	SELID_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
126	CHANG_TXT	☐	TEXT35	TEXT35	CHAR	35	0	Text (length 35)
127	RELSU_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
128	RELMS_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
129	INCNW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
130	INCPN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
131	INCSN_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
132	WKFLW_TSS	☐	MLST_SSTA	STATUV_TXT	CHAR	4	0	System status (4 character text)
133	RELSU_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
134	RELMS_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
135	INCNW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
136	INCPN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
137	INCSN_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
138	WKFLW_TUS	☐	MLST_ASTA	TEXT4	CHAR	4	0	User status (4 character text)
139	FKT_RELSU	☐	MLST_FUNC1	TEXT35	CHAR	35	0	Description of the milestone function
140	FKT_RELMS	☐	MLST_FUNC2	TEXT35	CHAR	35	0	Description of the milestone function
141	FKT_INCSN	☐	MLST_FUNC3	TEXT35	CHAR	35	0	Description of the milestone function
142	FKT_INCNW	☐	MLST_FUNC4	TEXT35	CHAR	35	0	Description of the milestone function
143	FKT_INCPN	☐	MLST_FUNC5	TEXT35	CHAR	35	0	Description of the milestone function
144	FKT_WKFLW	☐	MLST_FUNC6	TEXT35	CHAR	35	0	Description of the milestone function
145	INDBT	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
146	TASK_SHORT	☐	MLST_TASKS	TEXT12	CHAR	12	0	Short ID for workflow task
147	TASK_STEXT	☐	MLST_TASKT	TEXT40	CHAR	40	0	Description of the workflow task
148	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
149	ACTIVE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
150	DISPLAY	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
151	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
152	.INCLUDE	☐				0	0	Milestone Description
153	MLTX_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
154	MLTX_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
155	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
156	AEND_ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
157	.INCLUDE	☐				0	0	Milestone Description
158	KTEXT	☐	MLST_KTEXT	TEXT40	CHAR	40	0	Description
159	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
160	.INCLUDE	☐				0	0	TREX Administration Data
161	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
162	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
163	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSHLP_TREX_MLST_ST	AENNR	AENR	AENNR
2	PSHLP_TREX_MLST_ST	AUART_ICNW	T003O	AUART		C	CN
3	PSHLP_TREX_MLST_ST	DELTE	T006	MSEHI
4	PSHLP_TREX_MLST_ST	INCNW_SM	TJ48	SELID	REF	C	CN
5	PSHLP_TREX_MLST_ST	INCPN_SM	TJ48	SELID	REF	C	CN
6	PSHLP_TREX_MLST_ST	INCSN_SM	TJ48	SELID	REF	C	CN
7	PSHLP_TREX_MLST_ST	LANGU	T002	SPRAS	KEY	1	CN
8	PSHLP_TREX_MLST_ST	LTXSP	T002	SPRAS	KEY	1	CN
9	PSHLP_TREX_MLST_ST	MLSTN	T433	MLSTN
10	PSHLP_TREX_MLST_ST	MLTX_MANDT	T000	MANDT	KEY	1	CN
11	PSHLP_TREX_MLST_ST	PLNTY	TCA01	PLNTY	REF	C	CN
12	PSHLP_TREX_MLST_ST	PSPNR	PRPS	PSPNR	REF	C	CN
13	PSHLP_TREX_MLST_ST	RELMS_SM	TJ48	SELID	REF	C	CN
14	PSHLP_TREX_MLST_ST	RELSU_SM	TJ48	SELID	REF	C	CN
15	PSHLP_TREX_MLST_ST	SPSNR	PRPSS	PSPNR
16	PSHLP_TREX_MLST_ST	STSMA	TJ20	STSMA
17	PSHLP_TREX_MLST_ST	WKFLW_SM	TJ48	SELID	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	606