	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

186 COLUMNS | 4 INDEXES | ERP 6.0 | VSAFVC_CN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Project System :: Simulation
1	ERP EHP7	6.0	VSAFVC_CN	186	4	Version: Operation in order	Simulation

SQL: selectupdate insert create

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

SELECT MANDT, VSNMR, AUFPL, APLZL, PLNFL, PLNKN, PLNAL, PLNTY, VINTV, PLNNR, ZAEHL, VORNR, STEUS, ARBID, PDEST, WERKS, KTSCH, LTXA1, LTXA2, TXTSP, VPLTY, VPLNR, VPLAL, VPLFL, VGWTS, LAR01, LAR02, LAR03, LAR04, LAR05, LAR06, ZERMA, ZGDAT, ZCODE, ZULNR, LOANZ, LOART, RSANZ, QUALF, ANZMA, RFGRP, RFSCH, RASCH, AUFAK, LOGRP, UEMUS, UEKAN, FLIES, SPMUS, SPLIM, ABLIPKZ, RSTRA, SUMNR, SORTL, LIFNR, PREIS, PEINH, SAKTO, WAERS, INFNR, ESOKZ, EKORG, EKGRP, KZLGF, KZWRTF, MATKL, DDEHN, ANZZL, PRZNT, MLSTN, PPRIO, BUKRS, ANFKO, ANFKOKRS, INDET, LARNT, PRKST, APLFL, RUECK, RMZHL, PROJN, OBJNR, SPANZ, BEDID, BEDZL, BANFN, BNFPO, LEK01, LEK02, LEK03, LEK04, LEK05, LEK06, SELKZ, KALID, FRSP, STDKN, ANLZU, ISTRU, ISTTY, ISTNR, ISTKN, ISTPO, IUPOZ, EBORT, VERTL, LEKNW, NPRIO, PVZKN, PHFLG, PHSEQ, KNOBJ, ERFSICHT, QPPKTABS, OTYPE, OBJEKTID, QLKAPAR, RSTUF, NPTXTKY, SUBSYS, PSPNR, PACKNO, TXJCD, SCOPE, GSBER, PRCTR, NO_DISP, QKZPRZEIT, QKZZTMG1, QKZPRMENG, QKZPRFREI, KZFEAT, QKZTLSBEST, AENNR, CUOBJ_ARB, EVGEW, ARBII, WERKI, CY_SEQNRV, KAPT_PUFFR, EBELN, EBELP, WEMPF, ABLAD, CLASF, FRUNV, ZSCHL, KALSM, SCHED_END, NETZKONT, OWAER, AFNAM, BEDNR, KZFIX, PERNR, FRDLB, QPART, LOEKZ, WKURS, PROD_ACT, FPLNR, OBJTYPE, CH_PROC, KLVAR, KALNR, FORDN, FORDP, MAT_PRKST, PRZ01, RFPNT, FUNC_AREA, TECHS, ADPSP, RFIPPNT, MES_OPERID, MES_STEPID, /CUM/CUGUID, /ISDFPS/OBJNR, AFVC_STATUS, MILL_OC_AUFNR_MO, WTY_IND, ORGAUFPL, ORGAPLZL, INACT, TPLNR, EQUNR FROM VSAFVC_CN

TOP ERP 6.0 | VSAFVC_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	*	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	PLNFL	Sequence	nvarchar	6	0	CHAR	(N' ')	Yes		PLNFOLGE	Allow NULL?
6	PLNKN	Number of the task list node	nvarchar	8	0	NUMC	(N'00000000')	Yes		PLNKN	Allow NULL?
7	PLNAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
8	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	TCA01	PLNTY	Allow NULL?
9	VINTV	Increment between referenced operations	decimal	3	0	DEC	((0))	Yes		VINTV
10	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
11	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
12	VORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
13	STEUS	Control key	nvarchar	4	0	CHAR	(N' ')	Yes	T430	STEUS	Allow NULL?
14	ARBID	Object ID of the resource	nvarchar	8	0	NUMC	(N'00000000')	Yes	CRID	CR_OBJID	Allow NULL?
15	PDEST	Printer for shop papers	nvarchar	4	0	CHAR	(N' ')	Yes	TSP03	CR_PDEST	Allow NULL?
16	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
17	KTSCH	Standard text key	nvarchar	7	0	CHAR	(N' ')	Yes	T435	KTSCH	Allow NULL?
18	LTXA1	Operation short text	nvarchar	40	0	CHAR	(N' ')	Yes		LTXA1	Allow NULL?
19	LTXA2	Second line of the description	nvarchar	40	0	CHAR	(N' ')	Yes		LTXA2	Allow NULL?
20	TXTSP	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
21	VPLTY	Type of the referenced task list	char	1	0	CHAR	(N' ')	Yes	TCA01	VPLNTY	Allow NULL?
22	VPLNR	Group of the referenced task list	nvarchar	8	0	CHAR	(N' ')	Yes		VPLNNR	Allow NULL?
23	VPLAL	Group counter of the referenced task list	nvarchar	2	0	CHAR	(N' ')	Yes		VPLNAL	Allow NULL?
24	VPLFL	Referenced sequence in routing	nvarchar	6	0	CHAR	(N' ')	Yes		VPLBFL	Allow NULL?
25	VGWTS	Standard value key	nvarchar	4	0	CHAR	(N' ')	Yes	TC21	VORGSCHL	Allow NULL?
26	LAR01	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
27	LAR02	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
28	LAR03	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
29	LAR04	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
30	LAR05	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
31	LAR06	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
32	ZERMA	Type of standard value calculation	nvarchar	5	0	CHAR	(N' ')	Yes	T429	DZERMA	Allow NULL?
33	ZGDAT	Date when the standard value was calculated	nvarchar	4	0	CHAR	(N' ')	Yes		DZGDAT	Allow NULL?
34	ZCODE	Reference number for standard value code	nvarchar	6	0	CHAR	(N' ')	Yes		DZCODE	Allow NULL?
35	ZULNR	Basis for standard value calculation	nvarchar	5	0	CHAR	(N' ')	Yes		DZULNR	Allow NULL?
36	LOANZ	Number of Time Tickets	decimal	3	0	DEC	((0))	Yes		LOHNANZ
37	LOART	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes		LOHNART	Allow NULL?
38	RSANZ	Number of confirmation slips	nvarchar	3	0	NUMC	(N'000')	Yes		CR_RS_ANZ	Allow NULL?
39	QUALF	Suitability	nvarchar	2	0	CHAR	(N' ')	Yes	T423	QUALF	Allow NULL?
40	ANZMA	Number of employees	decimal	5	2	DEC	((0))	Yes		ANZMS
41	RFGRP	Setup group category	nvarchar	10	0	CHAR	(N' ')	Yes	T426	RUEFAGRP	Allow NULL?
42	RFSCH	Setup group key	nvarchar	10	0	CHAR	(N' ')	Yes	T425	RUEFASCHLU	Allow NULL?
43	RASCH	Setup Type Key	nvarchar	2	0	CHAR	(N' ')	Yes	T428	RUEARSCHLU	Allow NULL?
44	AUFAK	Scrap factor	decimal	5	3	DEC	((0))	Yes		AUSCHUFAK
45	LOGRP	Wage group	nvarchar	3	0	CHAR	(N' ')	Yes	T421	LOHNGRP	Allow NULL?
46	UEMUS	Required overlapping	char	1	0	CHAR	(N' ')	Yes		UEMUSKZ	Allow NULL?
47	UEKAN	Optional overlapping	char	1	0	CHAR	(N' ')	Yes		UEKANKZ	Allow NULL?
48	FLIES	Indicator: continuous flow production	char	1	0	CHAR	(N' ')	Yes		FLIESSKZ	Allow NULL?
49	SPMUS	Required splitting	char	1	0	CHAR	(N' ')	Yes		SPLITTUNG	Allow NULL?
50	SPLIM	Maximum number of splits	decimal	3	0	DEC	((0))	Yes		SPLITTANZ
51	ABLIPKZ	Indicator: simultaneous teardown and wait	char	1	0	CHAR	(N' ')	Yes		ABLIPKZ	Allow NULL?
52	RSTRA	Reduction strategy per operation/activity	nvarchar	2	0	CHAR	(N' ')	Yes	T499Q	RSTRA	Allow NULL?
53	SUMNR	Node number of the superior operation	nvarchar	8	0	NUMC	(N'00000000')	Yes		SUMKNTNR	Allow NULL?
54	SORTL	Sort Term for Non-Stock Info Records	nvarchar	10	0	CHAR	(N' ')	Yes		SORTI	Allow NULL?
55	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	LIFNR	Allow NULL?
56	PREIS	Price	decimal	11	2	CURR	((0))	Yes		PREIS
57	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
58	SAKTO	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
59	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
60	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	EINA	INFNR	Allow NULL?
61	ESOKZ	Purchasing info record category	char	1	0	CHAR	(N' ')	Yes		ESOKZ	Allow NULL?
62	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
63	EKGRP	Purchasing group for external processing	nvarchar	3	0	CHAR	(N' ')	Yes	T024	VG_EKGRP	Allow NULL?
64	KZLGF	Indicator: fixed lot external processing	char	1	0	CHAR	(N' ')	Yes		KZLGF	Allow NULL?
65	KZWRTF	Indicator: Fixed price for external processing	char	1	0	CHAR	(N' ')	Yes		KZWRTF	Allow NULL?
66	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
67	DDEHN	Indicator: flexible duration	char	1	0	CHAR	(N' ')	Yes		DAUDEHN	Allow NULL?
68	ANZZL	Number of capacities required	tinyint	3	0	INT1	((0))	Yes		ANZKAP
69	PRZNT	Work percentage	tinyint	3	0	INT1	((0))	Yes		APROZENT
70	MLSTN	Usage	nvarchar	5	0	CHAR	(N' ')	Yes	T433	MILESTONE	Allow NULL?
71	PPRIO	Priority	nvarchar	2	0	CHAR	(N' ')	Yes		PRIORITAET	Allow NULL?
72	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
73	ANFKO	Requesting cost center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	ANFKO	Allow NULL?
74	ANFKOKRS	Controlling area of the requesting cost center	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	ANFKOKRS	Allow NULL?
75	INDET	Key for calculation	char	1	0	CHAR	(N' ')	Yes		INDET	Allow NULL?
76	LARNT	Activity Type	nvarchar	6	0	CHAR	(N' ')	Yes	CSLA	LSTAR	Allow NULL?
77	PRKST	Costs in the activity	decimal	11	2	CURR	((0))	Yes		PRKST
78	APLFL	Sequence	nvarchar	6	0	CHAR	(N' ')	Yes		PLNFOLGE	Allow NULL?
79	RUECK	Completion confirmation number for the operation	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_RUECK	Allow NULL?
80	RMZHL	Confirmation counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CO_RMZHL	Allow NULL?
81	PROJN	Work breakdown structure element (WBS element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_ELE	Allow NULL?
82	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
83	SPANZ	Actual number of splits	decimal	3	0	DEC	((0))	Yes		SPLITTERM
84	BEDID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
85	BEDZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
86	BANFN	Purchase requisition number	nvarchar	10	0	CHAR	(N' ')	Yes		CO_BANFN	Allow NULL?
87	BNFPO	Item number of the purchase requisition in the order	nvarchar	5	0	NUMC	(N'00000')	Yes	EBAN	CO_BNFPO	Allow NULL?
88	LEK01	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
89	LEK02	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
90	LEK03	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
91	LEK04	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
92	LEK05	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
93	LEK06	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	Yes		CO_LEIKZ	Allow NULL?
94	SELKZ	Selection indicator for costing line items	char	1	0	CHAR	(N' ')	Yes	TCK08	CO_SELKZ	Allow NULL?
95	KALID	Factory Calendar	nvarchar	2	0	CHAR	(N' ')	Yes	TFACD	WFCID	Allow NULL?
96	FRSP	Earliest possible activity / Latest possible activity	char	1	0	CHAR	(N' ')	Yes		FRSP	Allow NULL?
97	STDKN	Node of operation within reference operation set	nvarchar	8	0	NUMC	(N'00000000')	Yes		STDKN	Allow NULL?
98	ANLZU	Syst.Condition	char	1	0	CHAR	(N' ')	Yes	T357M	ANLZU	Allow NULL?
99	ISTRU	Assembly	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	ISTRU	Allow NULL?
100	ISTTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
101	ISTNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
102	ISTKN	BOM item node number	nvarchar	8	0	NUMC	(N'00000000')	Yes		STLKN	Allow NULL?
103	ISTPO	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
104	IUPOZ	Subitem Number	nvarchar	4	0	CHAR	(N' ')	Yes		UPOSZ	Allow NULL?
105	EBORT	Installation Point for Subitem	nvarchar	20	0	CHAR	(N' ')	Yes		EBORT	Allow NULL?
106	VERTL	Distr.cap.reqmts (plant maint.,process order, network)	nvarchar	8	0	CHAR	(N' ')	Yes	TC29	CR_VERTN	Allow NULL?
107	LEKNW	Indicator: No Remaining Work Expected	char	1	0	CHAR	(N' ')	Yes		LEKNW	Allow NULL?
108	NPRIO	Priority	char	1	0	CHAR	(N' ')	Yes	TCN07	NW_PRIO	Allow NULL?
109	PVZKN	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	CO_APLZL	Allow NULL?
110	PHFLG	Indicator: Phase	char	1	0	CHAR	(N' ')	Yes		PHFLG	Allow NULL?
111	PHSEQ	Control Recipe Destination	nvarchar	2	0	CHAR	(N' ')	Yes	TC52	PHSEQ	Allow NULL?
112	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		KNOBJ	Allow NULL?
113	ERFSICHT	Recording View	nvarchar	2	0	CHAR	(N' ')	Yes		QERFSICHT	Allow NULL?
114	QPPKTABS	Flow Variants for Inspection Point Completion	char	1	0	CHAR	(N' ')	Yes		QPPKTABS	Allow NULL?
115	OTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	T778O	OTYPE	Allow NULL?
116	OBJEKTID	Object ID	nvarchar	8	0	NUMC	(N'00000000')	Yes		OBJEKTID	Allow NULL?
117	QLKAPAR	Capacity category	nvarchar	3	0	CHAR	(N' ')	Yes	TC26	QL_KAPART	Allow NULL?
118	RSTUF	Reduction level which reduces operation lead time	char	1	0	NUMC	(N'0')	Yes		RSTUF	Allow NULL?
119	NPTXTKY	Internal text number (12-character)	nvarchar	12	0	CHAR	(N' ')	Yes		TXTKY	Allow NULL?
120	SUBSYS	Subsystem Identifier for QM Subsystem Interface	nvarchar	6	0	CHAR	(N' ')	Yes	*	QEIFSUBSYS	Allow NULL?
121	PSPNR	Standard WBS element	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_SPS_ELE	Allow NULL?
122	PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO	Allow NULL?
123	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
124	SCOPE	Object Class	nvarchar	2	0	CHAR	(N' ')	Yes		SCOPE_CV	Allow NULL?
125	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
126	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
127	NO_DISP	Effective for Materials Planning	char	1	0	CHAR	(N' ')	Yes		NO_DISP_PLUS	Allow NULL?
128	QKZPRZEIT	Interval = Time (Time-Related)	char	1	0	CHAR	(N' ')	Yes		QKZPRZEIT	Allow NULL?
129	QKZZTMG1	Quantity Confirmation for Each Partial Lot	char	1	0	CHAR	(N' ')	Yes		QKZZTMG1	Allow NULL?
130	QKZPRMENG	Creation Cycle = Quantity (Quantity-Reference)	char	1	0	CHAR	(N' ')	Yes		QKZPRMENG	Allow NULL?
131	QKZPRFREI	Interval Without Reference to Time or Quantity	char	1	0	CHAR	(N' ')	Yes		QKZPRFREI	Allow NULL?
132	KZFEAT	Indicator Is Not Used Currently	char	1	0	CHAR	(N' ')	Yes		QKZFEAT	Allow NULL?
133	QKZTLSBEST	Operation with Stock-Related Partial Lot Assignment	char	1	0	CHAR	(N' ')	Yes		QKZTLSBEST	Allow NULL?
134	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
135	CUOBJ_ARB	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
136	EVGEW	Aggregation weight for POC (PS progress)	decimal	8	0	DEC	((0))	Yes		EV_WEIGHTD
137	ARBII	Actual operating resources object identification	nvarchar	8	0	NUMC	(N'00000000')	Yes	CRID	CR_OBJID_I	Allow NULL?
138	WERKI	Actual plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_I	Allow NULL?
139	CY_SEQNRV	Sequence number operation	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		CY_SEQNRV	Allow NULL?
140	KAPT_PUFFR	Operation floats after finite scheduling (in seconds)	int	10	0	INT4	((0))	Yes		KAPT_PUFFR	Allow NULL?
141	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
142	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
143	WEMPF	Goods Recipient/Ship-To Party	nvarchar	12	0	CHAR	(N' ')	Yes		WEMPF	Allow NULL?
144	ABLAD	Unloading Point	nvarchar	25	0	CHAR	(N' ')	Yes		ABLAD	Allow NULL?
145	CLASF	Ind.: Take Activity Into Account for Project Summarization	char	1	0	CHAR	(N' ')	Yes		CLASF	Allow NULL?
146	FRUNV	Indicator: External procurement data incomplete	char	1	0	CHAR	(N' ')	Yes		FRUNV	Allow NULL?
147	ZSCHL	Overhead key	nvarchar	6	0	CHAR	(N' ')	Yes		AUFZSCHL	Allow NULL?
148	KALSM	Costing Sheet	nvarchar	6	0	CHAR	(N' ')	Yes	*	AUFKALSM	Allow NULL?
149	SCHED_END	Ind.: Purchase requisition at activity finish date	char	1	0	CHAR	(N' ')	Yes		SCEND_ACT	Allow NULL?
150	NETZKONT	Indicator for the account assignment of a network(hdr/act.)	char	1	0	CHAR	(N' ')	Yes		NETZKONT	Allow NULL?
151	OWAER	Object currency for network activity	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OWAERS	Allow NULL?
152	AFNAM	Name of Requisitioner/Requester	nvarchar	12	0	CHAR	(N' ')	Yes		AFNAM	Allow NULL?
153	BEDNR	Requirement Tracking Number	nvarchar	10	0	CHAR	(N' ')	Yes		BEDNR	Allow NULL?
154	KZFIX	Indicator: Purchasing info record data are fixed	char	1	0	CHAR	(N' ')	Yes		CN_KZFIX	Allow NULL?
155	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	Yes		CO_PERNR	Allow NULL?
156	FRDLB	Indicator: Externally processed op. with subcontracting	char	1	0	CHAR	(N' ')	Yes		CO_FRDLB	Allow NULL?
157	QPART	Inspection Type	nvarchar	8	0	CHAR	(N' ')	Yes	TQ30	QPART	Allow NULL?
158	LOEKZ	Deletion flag	char	1	0	CHAR	(N' ')	Yes		AUFLOEKZ	Allow NULL?
159	WKURS	Exchange Rate	decimal	9	5	DEC	((0))	Yes		WKURS
160	PROD_ACT	Indicator: Activity is a production activity	char	1	0	CHAR	(N' ')	Yes		PROD_ACT	Allow NULL?
161	FPLNR	Billing plan number / invoicing plan number	nvarchar	10	0	CHAR	(N' ')	Yes	*	FPLNR	Allow NULL?
162	OBJTYPE	Change indicator	char	1	0	CHAR	(N' ')	Yes		OCM_OBJ_TYPE	Allow NULL?
163	CH_PROC	Process that has lead to the change of an object	char	1	0	CHAR	(N' ')	Yes		OCM_CH_PROC	Allow NULL?
164	KLVAR	Costing Variant	nvarchar	4	0	CHAR	(N' ')	Yes	*	CK_KLVAR	Allow NULL?
165	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	CK_KALNR	Allow NULL?
166	FORDN	Framework Order	nvarchar	10	0	CHAR	(N' ')	Yes	*	SFORDN	Allow NULL?
167	FORDP	Item of framework order	nvarchar	5	0	NUMC	(N'00000')	Yes	*	FORDP	Allow NULL?
168	MAT_PRKST	Material planning in networks: primary costs	decimal	11	2	CURR	((0))	Yes		MAT_PRKST
169	PRZ01	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
170	RFPNT	Reference point for BOM transfer	nvarchar	20	0	CHAR	(N' ')	Yes	TCNRFP	CN_RFPNT	Allow NULL?
171	FUNC_AREA	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	TFKB	FKBER	Allow NULL?
172	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
173	ADPSP	Reference Element PM/PS	nvarchar	40	0	CHAR	(N' ')	Yes	*	ADDCOMPARE_CORE	Allow NULL?
174	RFIPPNT	Reference Point for Relationship Between iPPE and PS	nvarchar	20	0	CHAR	(N' ')	Yes	TCNRPIP	CN_RPIP	Allow NULL?
175	MES_OPERID	Key of an Operation from an ME System	nvarchar	48	0	CHAR	(N' ')	Yes		CO_MES_INT_OPERID	Allow NULL?
176	MES_STEPID	Key of a Step in a Routing (SAP ME)	nvarchar	6	0	CHAR	(N' ')	Yes		CO_MES_INT_STEPID	Allow NULL?
177	/CUM/CUGUID	UUID in X form (binary)	varbinary	16	0	RAW		Yes	/CUM/AFCU	SYSUUID_X
178	/ISDFPS/OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	*	J_OBJNR	Allow NULL?
179	AFVC_STATUS	Status Combination	tinyint	3	0	INT1	((0))	Yes	ACTCMB_TAB	ACTCMB_DELE
180	MILL_OC_AUFNR_MO	Number of Combined Order	nvarchar	12	0	CHAR	(N' ')	Yes	*	MILL_OC_AUFNR_MO	Allow NULL?
181	WTY_IND	Warranty indicator	char	1	0	CHAR	(N' ')	Yes		WTYSC_WTY_INDICATOR	Allow NULL?
182	ORGAUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
183	ORGAPLZL	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	CO_APLZL	Allow NULL?
184	INACT	Version inactive indicator	char	1	0	CHAR	(N' ')	Yes		VSINACT	Allow NULL?
185	TPLNR	Functional Location	nvarchar	30	0	CHAR	(N' ')	Yes	*	TPLNR	Allow NULL?
186	EQUNR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	EQUNR	Allow NULL?

TOP ERP 6.0 | VSAFVC_CN INDEXES

Name	Primary	Unique	Type	Columns
VSAFVC_CN~0	Yes	Yes	CLUSTERED	MANDT, VSNMR, AUFPL, APLZL
VSAFVC_CN~1	No	No	NONCLUSTERED	MANDT, VSNMR, PROJN
VSAFVC_CN~2	No	No	NONCLUSTERED	MANDT, AUFPL
VSAFVC_CN~A	No	No	NONCLUSTERED	MANDT, OBJNR

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

186 COLUMNS | 4 INDEXES | ERP 6.0 | VSAFVC_CN TABLE

TOP ERP 6.0 | VSAFVC_CN COLUMNS

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

186 COLUMNS | 4 INDEXES | ERP 6.0 | VSAFVC_CN TABLE

TOPERP 6.0 | VSAFVC_CN COLUMNS

TOPERP 6.0 | VSAFVC_CN INDEXES

TOP ERP 6.0 | VSAFVC_CN COLUMNS

TOP ERP 6.0 | VSAFVC_CN INDEXES