SAP ABAP Table PSHLP_TREX_ACTY_DATES_ST (Activity Dates 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_ACTY_DATES_ST	Table Relationship Diagram
Short Description	Activity Dates 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
4	.INCLUDE	☐				0	0	Include structure of the operation quantities/dates/values
5	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
6	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
7	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
8	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
9	ZMERH	☐	DZMERH	VGWRT	QUAN	9	3	Break
10	ZEIER	☐	DZEIER	MEINS	UNIT	3	0	Unit for the break time	T006
11	VGE01	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
12	VGW01	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
13	VGE02	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
14	VGW02	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
15	VGE03	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
16	VGW03	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
17	VGE04	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
18	VGW04	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
19	VGE05	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
20	VGW05	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
21	VGE06	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
22	VGW06	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
23	ZEIMU	☐	DZEIMU	MEINS	UNIT	3	0	Unit for the minimum overlap time	T006
24	ZMINU	☐	DZMINU	VGWRT	QUAN	9	3	Minimum overlap time
25	MINWE	☐	MINWEI	MINWEI	QUAN	13	3	Minimum Send-Ahead Quantity
26	ZEIMB	☐	DZEIMB	MEINS	UNIT	3	0	Unit for the minimum processing time	T006
27	ZMINB	☐	DZMINB	VGWRT	QUAN	9	3	Minimum processing time
28	ZEILM	☐	DZEILM	MEINS	UNIT	3	0	Unit for the maximum wait time	T006
29	ZLMAX	☐	DZLMAX	VGWRT	QUAN	9	3	Maximum wait time
30	ZEILP	☐	DZEILP	MEINS	UNIT	3	0	Unit for the required wait time	T006
31	ZLPRO	☐	DZLPRO	VGWRT	QUAN	9	3	Minimum wait time
32	ZEIWN	☐	DZEIWN	MEINS	UNIT	3	0	Unit for the standard queue time	T006
33	ZWNOR	☐	DZWNOR	VGWRT	QUAN	9	3	Standard queue time
34	ZEIWM	☐	DZEIWM	MEINS	UNIT	3	0	Unit for the minumum queue time	T006
35	ZWMIN	☐	DZWMIN	VGWRT	QUAN	9	3	Minimum queue time
36	ZEITN	☐	DZEITN	MEINS	UNIT	3	0	Unit for the standard move time	T006
37	ZTNOR	☐	DZTNOR	VGWRT	QUAN	9	3	Standard move time
38	ZEITM	☐	DZEITM	MEINS	UNIT	3	0	Unit for the minimum move time	T006
39	ZTMIN	☐	DZTMIN	VGWRT	QUAN	9	3	Minimum move time
40	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
41	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
42	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
43	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
44	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
45	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
46	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
47	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
48	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
49	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
50	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
51	LMNGA	☐	LMNGA	MENG13	QUAN	13	3	Total Yield Confirmed
52	XMNGA	☐	XMNGA	MENG13	QUAN	13	3	Total scrap quantity confirmed
53	GMNGA	☐	GMNGA	MENG13	QUAN	13	3	Confirmed yield in order unit of measure
54	ISM01	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
55	ISM02	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
56	ISM03	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
57	ISM04	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
58	ISM05	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
59	ISM06	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
60	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
61	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
62	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
63	FSSBD	☐	FSSBD	DATUM	DATS	8	0	Earliest scheduled start: Processing (date)
64	FSSBZ	☐	FSSBZ	ATIME	TIMS	6	0	Earliest scheduled start: Processing (time)
65	FSSAD	☐	FSSAD	DATUM	DATS	8	0	Earliest scheduled start: Teardown (date)
66	FSSAZ	☐	FSSAZ	ATIME	TIMS	6	0	Earliest scheduled start: Teardown (time)
67	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
68	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
69	FSSLD	☐	FSSLD	DATUM	DATS	8	0	Earliest scheduled start: Wait (date)
70	FSSLZ	☐	FSSLZ	ATIME	TIMS	6	0	Earliest scheduled start: Wait (time)
71	FSELD	☐	FSELD	DATUM	DATS	8	0	Earliest scheduled finish: Wait (date)
72	FSELZ	☐	FSELZ	ATIME	TIMS	6	0	Earliest scheduled finish: Wait (time)
73	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
74	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
75	SSSBD	☐	SSSBD	DATUM	DATS	8	0	Latest scheduled start: Processing (date)
76	SSSBZ	☐	SSSBZ	ATIME	TIMS	6	0	Latest scheduled start: Processing (time)
77	SSSAD	☐	SSSAD	DATUM	DATS	8	0	Latest scheduled start: Teardown (date)
78	SSSAZ	☐	SSSAZ	ATIME	TIMS	6	0	Latest scheduled start: Teardown (time)
79	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
80	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
81	SSSLD	☐	SSSLD	DATUM	DATS	8	0	Latest scheduled start: Wait time (date)
82	SSSLZ	☐	SSSLZ	ATIME	TIMS	6	0	Latest scheduled start: Wait time
83	SSELD	☐	SSELD	DATUM	DATS	8	0	Latest scheduled finish: Wait time (date)
84	SSELZ	☐	SSELZ	ATIME	TIMS	6	0	Latest scheduled finish: Wait time
85	ISAVD	☐	ISAVD	DATUM	DATS	8	0	Actual operation start (date)
86	IEAVD	☐	IEAVD	DATUM	DATS	8	0	Actual finish of operation (date)
87	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
88	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
89	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
90	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
91	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
92	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
93	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
94	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
95	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
96	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
97	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
98	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
99	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
100	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
101	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
102	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
103	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
104	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
105	NTEND	☐	VORGABEEND2	VORGABEEND	DATS	8	0	Constraint for Finish of Activity (Basic)
106	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
107	EWSTD	☐	EWSTARTD	DATUM	DATS	8	0	Forecasted start date for the activity
108	EWSTZ	☐	EWSTARTZ	ATIME	TIMS	6	0	Forecast start time of the activity
109	EWEND	☐	EWENDED	DATUM	DATS	8	0	Forecast finish date
110	EWENZ	☐	EWENDEZ	ATIME	TIMS	6	0	Forecast finish time for the activity
111	EWDAN	☐	EWDAN	DAUER_4_1	QUAN	5	1	Normal duration (from forecast) of activity
112	EWDNE	☐	EWDNE	MEINS	UNIT	3	0	Unit for forecast normal duration	T006
113	EWDAM	☐	EWDAM	DAUER_4_1	QUAN	5	1	Minimum duration (from forecast) for activity
114	EWDME	☐	EWDME	MEINS	UNIT	3	0	Unit for forecast minimum duration	T006
115	EWSTE	☐	PS_RESTE	RESTRIKEND	CHAR	1	0	Forecast date constraint on activity finish
116	EWSTA	☐	PS_RESTA	RESTRIKSTR	CHAR	1	0	Forecast date constraint on activity start
117	WARTZ	☐	WARTEZEIT	CX_ZEIT	FLTP	16	16	Queue time used for scheduling
118	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
119	RUEST	☐	RUEST	CX_ZEIT	FLTP	16	16	Setup time
120	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
121	BEARZ	☐	BEARZEIT	CX_ZEIT	FLTP	16	16	Processing time
122	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
123	ABRUE	☐	ABRUE	CX_ZEIT	FLTP	16	16	Teardown
124	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
125	LIEGZ	☐	LIEGEZEIT	CX_ZEIT	FLTP	16	16	Wait time used for scheduling
126	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
127	TRANZ	☐	TRANSZEIT	CX_ZEIT	FLTP	16	16	Move time used for scheduling
128	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
129	ISERH	☐	ISERH	VGWRT	QUAN	9	3	Confirmed break time
130	OFM01	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
131	OFM02	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
132	OFM03	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
133	OFM04	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
134	OFM05	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
135	OFM06	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
136	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
137	BZOFFB	☐	CP_OBZOFFB	CP_BZOFF	CHAR	2	0	Reference date for start of sub-operation	TCA54
138	EHOFFB	☐	CP_OEHOFFB	MEINS	UNIT	3	0	Unit for offset to start	T006
139	OFFSTB	☐	CP_OOFFSTB	VNZTV	QUAN	5	0	Offset to sub-operation start
140	OFFSTE	☐	CP_OOFFSTE	VNZTV	QUAN	5	0	Offset to sub-operation finish
141	BZOFFE	☐	CP_OBZOFFE	CP_BZOFF	CHAR	2	0	Reference date for finish of sub-operation	TCA54
142	EHOFFE	☐	CP_OEHOFFE	MEINS	UNIT	3	0	Unit for offset to finish	T006
143	FPAVD	☐	FPAVD	DATUM	DATS	8	0	Earliest scheduled start date (forecast)
144	FPAVZ	☐	FPAVZ	ATIME	TIMS	6	0	Earliest scheduled start time (forecast)
145	FPEDD	☐	FPEDD	DATUM	DATS	8	0	Earliest scheduled finish date (forecast)
146	FPEDZ	☐	FPEDZ	ATIME	TIMS	6	0	Earliest scheduled finish time (forecast)
147	SPAVD	☐	SPAVD	DATUM	DATS	8	0	Latest scheduled start date (forecast)
148	SPAVZ	☐	SPAVZ	ATIME	TIMS	6	0	Latest scheduled start time (forecast)
149	SPEDD	☐	SPEDD	DATUM	DATS	8	0	Latest scheduled finish date (forecast)
150	SPEDZ	☐	SPEDZ	ATIME	TIMS	6	0	Latest scheduled finish time (forecast)
151	BEAZP	☐	BEAZEP	EINHEIT	UNIT	3	0	Unit of processing time (Forecast)
152	PUFGP	☐	PPUFF_GESM	PUFFER	DEC	3	0	Total float (from forecast)
153	PUFFP	☐	PPUFF_FREI	PUFFER	DEC	3	0	Free float (from forecast)
154	BEARP	☐	PBEARZEIT	CX_ZEIT	FLTP	16	16	Processing time (forecast)
155	EPANF	☐	EPANF	DATUM	DATS	8	0	Dispatched start date for operation
156	EPANZ	☐	EPANZ	ATIME	TIMS	6	0	Dispatched start time for operation
157	EPEND	☐	EPEND	DATUM	DATS	8	0	Dispatched finish date
158	EPENZ	☐	EPENZ	ATIME	TIMS	6	0	Dispatched finish time
159	PDAU	☐	PDAU	DAUER_4_1	QUAN	5	1	Forecasted duration of activity from confirmation
160	PDAE	☐	PDAE	MEINS	UNIT	3	0	Unit of the forecasted duration from the confirmation	T006
161	KNOTE	☐	KNOTE	KNOTN	CHAR	10	0	Transportation Connection Points	TVKN
162	VSTZW	☐	VSTZW	VSTZW	CHAR	4	0	Deadline function	TVTZ
163	VSTGA	☐	VSTGA	VSTGA	CHAR	4	0	Deadline deviation reason	TVTG
164	QRASTZEHT	☐	QRASTZEHT	MEINS	UNIT	3	0	Time Unit	*
165	QRASTZFAK	☐	QRASTZFAK	QPROBEFAK	DEC	5	2	Time Factor
166	QRASTMENG	☐	QRASTMENG	MENG13	QUAN	13	3	Quantity Between Two Inspections
167	QRASTEREH	☐	QRASTEREH	MEINS	UNIT	3	0	Grid Unit of Measure	*
168	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
169	RMNGA	☐	RMNGA	MENGV13	QUAN	13	3	Total confirmed rework quantity
170	ILE01	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
171	ILE02	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
172	ILE03	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
173	ILE04	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
174	ILE05	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
175	ILE06	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
176	RWFAK	☐	RWFAK	AUSCHUFAK	DEC	5	3	Rework factor (is not used yet)
177	IPRZ1	☐	CO_IPRZS	MENGV13	QUAN	13	3	Confirmed quantity/work for business process
178	IPRE1	☐	RU_IPRZE	MEINS	UNIT	3	0	Unit of measurement for conf. quantity for business process	*
179	IPRK1	☐	RU_IPRZK	XFELD	CHAR	1	0	No remaining quantity expected for business process
180	TAKT	☐	LD_TAKT	LD_TAKT	NUMC	4	0	takt within a line segment
181	OPRZ1	☐	OPRZ1	MENGV13	QUAN	13	3	Remaining quantity for business process
182	OPRE1	☐	OPRE1	MEINS	UNIT	3	0	Unit for remaining quantity of business process	*
183	PSPM_INDICATOR	☐	PSPM_INDICATOR	PSPM_INDICATOR	CHAR	1	0	Indicates PMCS date influence activity scheduling
184	.INCLUDE	☐				0	0	TREX Administration Data
185	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
186	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
187	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_ACTY_DATES_ST	ARBEH	T006	MSEHI
2	PSHLP_TREX_ACTY_DATES_ST	BZOFFB	TCA54	BZOFF
3	PSHLP_TREX_ACTY_DATES_ST	BZOFFE	TCA54	BZOFF
4	PSHLP_TREX_ACTY_DATES_ST	DAUME	T006	MSEHI
5	PSHLP_TREX_ACTY_DATES_ST	DAUNE	T006	MSEHI
6	PSHLP_TREX_ACTY_DATES_ST	EHOFFB	T006	MSEHI
7	PSHLP_TREX_ACTY_DATES_ST	EHOFFE	T006	MSEHI
8	PSHLP_TREX_ACTY_DATES_ST	EWDME	T006	MSEHI
9	PSHLP_TREX_ACTY_DATES_ST	EWDNE	T006	MSEHI
10	PSHLP_TREX_ACTY_DATES_ST	KNOTE	TVKN	KNOTE
11	PSHLP_TREX_ACTY_DATES_ST	MEINH	T006	MSEHI
12	PSHLP_TREX_ACTY_DATES_ST	PDAE	T006	MSEHI
13	PSHLP_TREX_ACTY_DATES_ST	VGE01	T006	MSEHI
14	PSHLP_TREX_ACTY_DATES_ST	VGE02	T006	MSEHI
15	PSHLP_TREX_ACTY_DATES_ST	VGE03	T006	MSEHI
16	PSHLP_TREX_ACTY_DATES_ST	VGE04	T006	MSEHI
17	PSHLP_TREX_ACTY_DATES_ST	VGE05	T006	MSEHI
18	PSHLP_TREX_ACTY_DATES_ST	VGE06	T006	MSEHI
19	PSHLP_TREX_ACTY_DATES_ST	VSTGA	TVTG	VSTGA
20	PSHLP_TREX_ACTY_DATES_ST	VSTZW	TVTZ	VSTZW
21	PSHLP_TREX_ACTY_DATES_ST	ZEIER	T006	MSEHI
22	PSHLP_TREX_ACTY_DATES_ST	ZEILM	T006	MSEHI
23	PSHLP_TREX_ACTY_DATES_ST	ZEILP	T006	MSEHI
24	PSHLP_TREX_ACTY_DATES_ST	ZEIMB	T006	MSEHI
25	PSHLP_TREX_ACTY_DATES_ST	ZEIMU	T006	MSEHI
26	PSHLP_TREX_ACTY_DATES_ST	ZEITM	T006	MSEHI
27	PSHLP_TREX_ACTY_DATES_ST	ZEITN	T006	MSEHI
28	PSHLP_TREX_ACTY_DATES_ST	ZEIWM	T006	MSEHI
29	PSHLP_TREX_ACTY_DATES_ST	ZEIWN	T006	MSEHI

History

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