SAP ABAP Table PSHLP_TREX_AFVV_ST (Quantities/dates/values in the operation)

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_AFVV_ST	Table Relationship Diagram
Short Description	Quantities/dates/values in the operation

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

History

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