	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

182 COLUMNS | 1 INDEXES | ERP 6.0 | AFVV TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders
1	ERP EHP7	6.0	AFVV	182	1	DB structure of the quantities/dates/values in the operation	Production Orders

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, AUFPL, APLZL, MEINH, UMREN, UMREZ, BMSCH, ZMERH, ZEIER, VGE01, VGW01, VGE02, VGW02, VGE03, VGW03, VGE04, VGW04, VGE05, VGW05, VGE06, VGW06, ZEIMU, ZMINU, MINWE, ZEIMB, ZMINB, ZEILM, ZLMAX, ZEILP, ZLPRO, ZEIWN, ZWNOR, ZEIWM, ZWMIN, ZEITN, ZTNOR, ZEITM, ZTMIN, PLIFZ, DAUNO, DAUNE, DAUMI, DAUME, EINSA, EINSE, ARBEI, ARBEH, MGVRG, ASVRG, LMNGA, XMNGA, GMNGA, ISM01, ISM02, ISM03, ISM04, ISM05, ISM06, ISMNW, FSAVD, FSAVZ, FSSBD, FSSBZ, FSSAD, FSSAZ, FSEDD, FSEDZ, FSSLD, FSSLZ, FSELD, FSELZ, SSAVD, SSAVZ, SSSBD, SSSBZ, SSSAD, SSSAZ, SSEDD, SSEDZ, SSSLD, SSSLZ, SSELD, SSELZ, ISAVD, IEAVD, ISDD, ISDZ, IERD, IERZ, ISBD, ISBZ, IEBD, IEBZ, ISAD, ISAZ, IEDD, IEDZ, PEDD, PEDZ, PUFFR, PUFGS, NTANF, NTANZ, NTEND, NTENZ, EWSTD, EWSTZ, EWEND, EWENZ, EWDAN, EWDNE, EWDAM, EWDME, EWSTE, EWSTA, WARTZ, WRTZE, RUEST, RSTZE, BEARZ, BEAZE, ABRUE, ARUZE, LIEGZ, LIGZE, TRANZ, TRAZE, ISERH, OFM01, OFM02, OFM03, OFM04, OFM05, OFM06, OFMNW, BZOFFB, EHOFFB, OFFSTB, OFFSTE, BZOFFE, EHOFFE, FPAVD, FPAVZ, FPEDD, FPEDZ, SPAVD, SPAVZ, SPEDD, SPEDZ, BEAZP, PUFGP, PUFFP, BEARP, EPANF, EPANZ, EPEND, EPENZ, PDAU, PDAE, KNOTE, VSTZW, VSTGA, QRASTZEHT, QRASTZFAK, QRASTMENG, QRASTEREH, AUFKT, RMNGA, ILE01, ILE02, ILE03, ILE04, ILE05, ILE06, RWFAK, IPRZ1, IPRE1, IPRK1, TAKT, OPRZ1, OPRE1, PSPM_INDICATOR FROM AFVV

TOP ERP 6.0 | AFVV COLUMNS

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

TOP ERP 6.0 | AFVV INDEXES

Name	Primary	Unique	Type	Columns
AFVV~0	Yes	Yes	CLUSTERED	APLZL, AUFPL, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

182 COLUMNS | 1 INDEXES | ERP 6.0 | AFVV TABLE

TOP ERP 6.0 | AFVV COLUMNS

TOP ERP 6.0 | AFVV INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

182 COLUMNS | 1 INDEXES | ERP 6.0 | AFVV TABLE

TOPERP 6.0 | AFVV COLUMNS

TOPERP 6.0 | AFVV INDEXES

TOP ERP 6.0 | AFVV COLUMNS

TOP ERP 6.0 | AFVV INDEXES