	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

183 COLUMNS | 2 INDEXES | ERP 6.0 | VSAFVV_CN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Project System :: Simulation
1	ERP EHP7	6.0	VSAFVV_CN	183	2	Version: Quantities/Dates/Values in order operation	Simulation

SQL: selectupdate insert create

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

SELECT MANDT, VSNMR, 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 VSAFVV_CN

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

TOP ERP 6.0 | VSAFVV_CN INDEXES

Name	Primary	Unique	Type	Columns
VSAFVV_CN~0	Yes	Yes	CLUSTERED	MANDT, VSNMR, AUFPL, APLZL
VSAFVV_CN~A	No	No	NONCLUSTERED	AUFPL, APLZL, 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

183 COLUMNS | 2 INDEXES | ERP 6.0 | VSAFVV_CN TABLE

TOP ERP 6.0 | VSAFVV_CN COLUMNS

TOP ERP 6.0 | VSAFVV_CN 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

183 COLUMNS | 2 INDEXES | ERP 6.0 | VSAFVV_CN TABLE

TOPERP 6.0 | VSAFVV_CN COLUMNS

TOPERP 6.0 | VSAFVV_CN INDEXES

TOP ERP 6.0 | VSAFVV_CN COLUMNS

TOP ERP 6.0 | VSAFVV_CN INDEXES