	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

183 COLUMNS | 5 INDEXES | ERP 6.0 | AFVC TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders
1	ERP EHP7	6.0	AFVC	183	5	Operation within an order	Production Orders

SQL: selectupdate insert create

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

SELECT MANDT, 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, TPLNR, EQUNR, CPD_UPDAT FROM AFVC

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

TOP ERP 6.0 | AFVC INDEXES

Name	Primary	Unique	Type	Columns
AFVC~0	Yes	Yes	CLUSTERED	APLZL, AUFPL, MANDT
AFVC~1	No	No	NONCLUSTERED	RUECK, MANDT
AFVC~2	No	No	NONCLUSTERED	ARBID, MANDT
AFVC~3	No	No	NONCLUSTERED	PROJN, MANDT
AFVC~4	No	No	NONCLUSTERED	RFIPPNT, 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 | 5 INDEXES | ERP 6.0 | AFVC TABLE

TOP ERP 6.0 | AFVC COLUMNS

TOP ERP 6.0 | AFVC 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 | 5 INDEXES | ERP 6.0 | AFVC TABLE

TOPERP 6.0 | AFVC COLUMNS

TOPERP 6.0 | AFVC INDEXES

TOP ERP 6.0 | AFVC COLUMNS

TOP ERP 6.0 | AFVC INDEXES