	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

187 COLUMNS | 1 INDEXES | ERP 6.0 | AFRV_DEL TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders :: Order Processing :: Confirmations
1	ERP EHP7	6.0	AFRV_DEL	187	1	Backup Copy for Confirmation Pool	Confirmations

SQL: selectupdate insert create

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

SELECT CLIENT, AFORI, AFRUV, COUNTER, VTEXT, BEAKNZ, PDSNR, PERNR, INFTY, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, BUKRS, GSBER, KOKRS, KOSTL, AUFNR, KSTRG, POSNR, NPLNR, VORNR, KDAUF, KDPOS, PAOBJNR, PRZNR, FISTL, FIPOS, GEBER, EBELN, EBELP, LSTNR, LTLST, SBUKR, SGSBR, SKOST, LSTAR, EXBEL, MWSKZ, OTYPE, STELL, POHRS, DART, UDART, SGTXT, TXJCD, LDATE, LTIME, ERDAT, ERTIM, SATZA, TERID, ABWGR, EXLGA, ZEINH, HRAZL, HRBET, ORIGF, DALLF, PDC_OTYPE, PDC_PLANS, PDC_USRUP, REFEX, ORDEX, ZAUSW, ORIND, INDEU, RUECK, SPLIT, RMZHL, BUDAT, WERKS, ARBPL, KAPAR, LTXA1, ISERH, ZEIER, ILE01, ISM01, OFM01, OFE01, LEK01, ILE02, ISM02, OFM02, OFE02, LEK02, ILE03, ISM03, OFM03, OFE03, LEK03, ILE04, ISM04, OFM04, OFE04, LEK04, ILE05, ISM05, OFM05, OFE05, LEK05, ILE06, ISM06, OFM06, OFE06, LEK06, ISMNW, ISMNE, LEARR, OFMNW, OFMNE, LEKNW, ABARB, IDAUR, IDAUE, ODAUR, ODAUE, LOART, QUALF, ANZMA, LOGRP, LMNGA, XMNGA, MEINH, GRUND, ISDD, ISDZ, IERD, IERZ, ISBD, ISBZ, IEBD, IEBZ, ISAD, ISAZ, IEDD, IEDZ, PEDD, PEDZ, AUERU, AUSOR, APLFL, UVORN, AUTYP, PKNUM, PKPOS, PKBST, ABMNG, RMNGA, PKKEY, PKIMG, CATSBELNR, CATSPRICE, CATSTCURR, CATSPEINH, BEMOT, PRZ01, IPRZ1, IPRE1, IPRK1, OPRZ1, OPRE1, EXNAM, EXERD, EXERZ, WEBLNR, PKLUZ, PKLDT, PKBMG, CHARG, SKOKRS, SKOSTL, NODAT, ISMNU, OFMNU, PACKNO, SLK01, SLK02, SLK03, SLK04, SLK05, SLK06, SPRK1, EXTID FROM AFRV_DEL

TOP ERP 6.0 | AFRV_DEL COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	AFORI	Origin Indicator of PDC Message (Application)	char	1	0	CHAR	(N' ')	No		ORIND	Allow NULL?
3	AFRUV	Confirmation pool	nvarchar	20	0	CHAR	(N' ')	No	AFRH	AFRUV	Allow NULL?
4	COUNTER	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	No		CIM_COUNT	Allow NULL?
5	VTEXT	Operation short text	nvarchar	40	0	CHAR	(N' ')	No		LTXA1	Allow NULL?
6	BEAKNZ	Indicator: Entry in pool was confirmed	char	1	0	CHAR	(N' ')	No		BEAKNZ	Allow NULL?
7	PDSNR	Sequential number for PDC messages	nvarchar	12	0	NUMC	(N'000000000000')	No	*	PDSNR_D	Allow NULL?
8	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	No		PERNR_D	Allow NULL?
9	INFTY	Infotype	nvarchar	4	0	CHAR	(N' ')	No		INFOTYP	Allow NULL?
10	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
11	OBJPS	Character field, length 2	nvarchar	2	0	CHAR	(N' ')	No		CHAR_LG_02	Allow NULL?
12	SPRPS	Single-Character Indicator	char	1	0	CHAR	(N' ')	No		CHAR1	Allow NULL?
13	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
14	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
15	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
16	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
17	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
18	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	No	TKA01	KOKRS	Allow NULL?
19	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
20	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	No	AUFK	AUFNR	Allow NULL?
21	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	No	CKPH	KSTRG	Allow NULL?
22	POSNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	PRPS	PS_PSP_PNR	Allow NULL?
23	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	No	AUFK	NPLNR	Allow NULL?
24	VORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	No		VORNR	Allow NULL?
25	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	No	VBUK	KDAUF	Allow NULL?
26	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	No		KDPOS	Allow NULL?
27	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
28	PRZNR	Business Process	nvarchar	12	0	CHAR	(N' ')	No	*	CO_PRZNR	Allow NULL?
29	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FM_FICTR	Allow NULL?
30	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	No	*	FIPOS	Allow NULL?
31	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
32	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	No	EKKO	EBELN	Allow NULL?
33	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	No	EKPO	EBELP	Allow NULL?
34	LSTNR	Activity Number	nvarchar	18	0	CHAR	(N' ')	No	ASMD	ASNUM	Allow NULL?
35	LTLST	Activity Type	nvarchar	6	0	CHAR	(N' ')	No	CSLA	LSTAR	Allow NULL?
36	SBUKR	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
37	SGSBR	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
38	SKOST	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
39	LSTAR	Activity Type	nvarchar	6	0	CHAR	(N' ')	No	CSLA	LSTAR	Allow NULL?
40	EXBEL	Field length 18	nvarchar	18	0	CHAR	(N' ')	No		CHAR18	Allow NULL?
41	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	No	*	MWSKZ	Allow NULL?
42	OTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	No	T778O	OTYPE	Allow NULL?
43	STELL	Job	nvarchar	8	0	NUMC	(N'00000000')	No	*	STELL	Allow NULL?
44	POHRS	Number of Hours for Activity Allocation/External Services	decimal	7	2	DEC	((0))	No		POHRS
45	DART	Character field, length 2	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR_LG_02	Allow NULL?
46	UDART	Character field, length 2	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR_LG_02	Allow NULL?
47	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
48	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
49	LDATE	Entry Date	nvarchar	8	0	DATS	(N'00000000')	No		BDE_DATE	Allow NULL?
50	LTIME	Time received	nvarchar	6	0	TIMS	(N'000000')	No		BDE_TIME	Allow NULL?
51	ERDAT	Created on	nvarchar	8	0	DATS	(N'00000000')	No		PHDAT	Allow NULL?
52	ERTIM	Created at	nvarchar	6	0	TIMS	(N'000000')	No		PHTIM	Allow NULL?
53	SATZA	Time Event Type	nvarchar	3	0	CHAR	(N' ')	No		RETYP	Allow NULL?
54	TERID	Terminal ID	nvarchar	4	0	CHAR	(N' ')	No		TERID	Allow NULL?
55	ABWGR	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	CHAR	(N' ')	No		CHAR4	Allow NULL?
56	EXLGA	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	CHAR	(N' ')	No		CHAR4	Allow NULL?
57	ZEINH	3-Byte field	nvarchar	3	0	CHAR	(N' ')	No		CHAR3	Allow NULL?
58	HRAZL	Decimal field of length 7	decimal	7	2	DEC	((0))	No		DEC07
59	HRBET	Currency amount, field length 9	decimal	9	2	CURR	((0))	No		CURR09
60	ORIGF	Origin Indicator of PDC Message	char	1	0	CHAR	(N' ')	No		ORIGF	Allow NULL?
61	DALLF	Single-Character Indicator	char	1	0	CHAR	(N' ')	No		CHAR1	Allow NULL?
62	PDC_OTYPE	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
63	PDC_PLANS	Position	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PLANS	Allow NULL?
64	PDC_USRUP	Customer-Specific Field	nvarchar	20	0	CHAR	(N' ')	Yes		PDC_USRUP	Allow NULL?
65	REFEX	Single-Character Indicator	char	1	0	CHAR	(N' ')	No		CHAR1	Allow NULL?
66	ORDEX	Single-Character Indicator	char	1	0	CHAR	(N' ')	No		CHAR1	Allow NULL?
67	ZAUSW	Time Recording ID Number	nvarchar	8	0	NUMC	(N'00000000')	No		DZAUSW	Allow NULL?
68	ORIND	Origin Indicator of PDC Message (Application)	char	1	0	CHAR	(N' ')	No		ORIND	Allow NULL?
69	INDEU	Insert/delete or update indicator	char	1	0	CHAR	(N' ')	No		INDEU	Allow NULL?
70	RUECK	Completion confirmation number for the operation	nvarchar	10	0	NUMC	(N'0000000000')	No		CO_RUECK	Allow NULL?
71	SPLIT	Split number	tinyint	3	0	INT1	((0))	No		CY_SPLIT
72	RMZHL	Confirmation counter	nvarchar	8	0	NUMC	(N'00000000')	No		CO_RMZHL	Allow NULL?
73	BUDAT	Posting date	nvarchar	8	0	DATS	(N'00000000')	No		BUCHDATUM	Allow NULL?
74	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	No	*	WERKS_D	Allow NULL?
75	ARBPL	Work center	nvarchar	8	0	CHAR	(N' ')	No		ARBPL	Allow NULL?
76	KAPAR	Capacity category	nvarchar	3	0	CHAR	(N' ')	No	*	KAPART	Allow NULL?
77	LTXA1	Confirmation text	nvarchar	40	0	CHAR	(N' ')	No		CO_RTEXT	Allow NULL?
78	ISERH	Confirmed break time	decimal	9	3	QUAN	((0))	No		ISERH
79	ZEIER	Unit for the break time	nvarchar	3	0	UNIT	(N' ')	No	*	DZEIER	Allow NULL?
80	ILE01	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
81	ISM01	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
82	OFM01	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
83	OFE01	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
84	LEK01	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
85	ILE02	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
86	ISM02	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
87	OFM02	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
88	OFE02	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
89	LEK02	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
90	ILE03	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
91	ISM03	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
92	OFM03	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
93	OFE03	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
94	LEK03	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
95	ILE04	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
96	ISM04	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
97	OFM04	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
98	OFE04	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
99	LEK04	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
100	ILE05	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
101	ISM05	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
102	OFM05	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
103	OFE05	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
104	LEK05	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
105	ILE06	Unit of measure for the activity to be confirmed	nvarchar	3	0	UNIT	(N' ')	No	*	CO_ISMNGEH	Allow NULL?
106	ISM06	Activity currently to be confirmed	decimal	13	3	QUAN	((0))	No		CO_ISMNG
107	OFM06	Forecast value used to update the standard value	decimal	9	3	QUAN	((0))	No		CO_SCHAETZ
108	OFE06	Unit of measure for the standard value	nvarchar	3	0	UNIT	(N' ')	No	*	VGWRTEH	Allow NULL?
109	LEK06	Indicator: No remaining activity expected	char	1	0	CHAR	(N' ')	No		CO_LEIKZ	Allow NULL?
110	ISMNW	Actual work	decimal	7	1	QUAN	((0))	No		ISMNW
111	ISMNE	Unit for work	nvarchar	3	0	UNIT	(N' ')	No	*	ARBEITE	Allow NULL?
112	LEARR	Activity Type for Confirmation	nvarchar	6	0	CHAR	(N' ')	No	*	LEARR	Allow NULL?
113	OFMNW	Remaining work	decimal	7	1	QUAN	((0))	No		REMNW
114	OFMNE	Unit of measure for remaining work	nvarchar	3	0	UNIT	(N' ')	No	*	OFMNE	Allow NULL?
115	LEKNW	Indicator: No Remaining Work Expected	char	1	0	CHAR	(N' ')	No		LEKNW	Allow NULL?
116	ABARB	Confirmation: Degree of processing	nvarchar	3	0	NUMC	(N'000')	No		CO_ABARB	Allow NULL?
117	IDAUR	Actual Duration for Confirmation	decimal	5	1	QUAN	((0))	No		IDAUR
118	IDAUE	Unit for actual duration	nvarchar	3	0	UNIT	(N' ')	No	*	IDAURE	Allow NULL?
119	ODAUR	Remaining duration of activity	decimal	5	1	QUAN	((0))	No		ODAUR
120	ODAUE	Unit for remaining duration	nvarchar	3	0	UNIT	(N' ')	No	*	ODAUE	Allow NULL?
121	LOART	Wage Type	nvarchar	4	0	CHAR	(N' ')	No		LOHNART	Allow NULL?
122	QUALF	Suitability	nvarchar	2	0	CHAR	(N' ')	No	*	QUALF	Allow NULL?
123	ANZMA	Number of employees	decimal	5	2	DEC	((0))	No		ANZMS
124	LOGRP	Wage group	nvarchar	3	0	CHAR	(N' ')	No	*	LOHNGRP	Allow NULL?
125	LMNGA	Yield to Be Confirmed	decimal	13	3	QUAN	((0))	No		RU_LMNGA
126	XMNGA	Scrap to Be Confirmed	decimal	13	3	QUAN	((0))	No		RU_XMNGA
127	MEINH	Confirmation unit of measure	nvarchar	3	0	UNIT	(N' ')	No	*	RU_VORME	Allow NULL?
128	GRUND	Reason for Variance	nvarchar	4	0	CHAR	(N' ')	No	*	CO_AGRND	Allow NULL?
129	ISDD	Confirmed date for start of execution	nvarchar	8	0	DATS	(N'00000000')	No		RU_ISDD	Allow NULL?
130	ISDZ	Confirmed time for 'Execution start'	nvarchar	6	0	TIMS	(N'000000')	No		RU_ISDZ	Allow NULL?
131	IERD	Confirmed date for 'Setup finish'	nvarchar	8	0	DATS	(N'00000000')	No		RU_IERD	Allow NULL?
132	IERZ	Confirmed time for 'Setup finish'	nvarchar	6	0	TIMS	(N'000000')	No		RU_IERZ	Allow NULL?
133	ISBD	Confirmed date for 'Processing start'	nvarchar	8	0	DATS	(N'00000000')	No		RU_ISBD	Allow NULL?
134	ISBZ	Confirmed time for 'Processing start'	nvarchar	6	0	TIMS	(N'000000')	No		RU_ISBZ	Allow NULL?
135	IEBD	Confirmed date for 'processing finish'	nvarchar	8	0	DATS	(N'00000000')	No		RU_IEBD	Allow NULL?
136	IEBZ	Confirmed time for 'processing finish'	nvarchar	6	0	TIMS	(N'000000')	No		RU_IEBZ	Allow NULL?
137	ISAD	Confirmed date for 'teardown start'	nvarchar	8	0	DATS	(N'00000000')	No		RU_ISAD	Allow NULL?
138	ISAZ	Confirmed time for 'teardown start'	nvarchar	6	0	TIMS	(N'000000')	No		RU_ISAZ	Allow NULL?
139	IEDD	Confirmed date for execution finish	nvarchar	8	0	DATS	(N'00000000')	No		RU_IEDD	Allow NULL?
140	IEDZ	Confirmed time for 'Execution finish'	nvarchar	6	0	TIMS	(N'000000')	No		RU_IEDZ	Allow NULL?
141	PEDD	Forecast finish date of operation from confirmation	nvarchar	8	0	DATS	(N'00000000')	No		CO_PEDD	Allow NULL?
142	PEDZ	Forecast finish time of operation from confirmation	nvarchar	6	0	TIMS	(N'000000')	No		CO_PEDZ	Allow NULL?
143	AUERU	Activation of Final Confirmation	char	1	0	CHAR	(N' ')	No		AUERU	Allow NULL?
144	AUSOR	Post open reservations	char	1	0	CHAR	(N' ')	No		AUSOR	Allow NULL?
145	APLFL	Sequence	nvarchar	6	0	CHAR	(N' ')	No		PLNFOLGE	Allow NULL?
146	UVORN	Suboperation	nvarchar	4	0	CHAR	(N' ')	No		UVORN	Allow NULL?
147	AUTYP	Order category	nvarchar	2	0	NUMC	(N'00')	No		AUFTYP	Allow NULL?
148	PKNUM	Control cycle number	nvarchar	7	0	CHAR	(N' ')	No	PKHD	PKNUM	Allow NULL?
149	PKPOS	Kanban item number / control cycle item	nvarchar	3	0	NUMC	(N'000')	No		PKPOS	Allow NULL?
150	PKBST	Kanban status	char	1	0	CHAR	(N' ')	No		PKBST	Allow NULL?
151	ABMNG	Reduced quantity in the planned order	decimal	13	3	QUAN	((0))	No		ABMNG
152	RMNGA	Total confirmed rework quantity	decimal	13	3	QUAN	((0))	Yes		RMNGA
153	PKKEY	Identification Number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PKKEY	Allow NULL?
154	PKIMG	Actual quantity	decimal	13	3	QUAN	((0))	Yes		PKIMG
155	CATSBELNR	Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		CATSBELNR	Allow NULL?
156	CATSPRICE	Price in Transaction Currency	decimal	11	2	CURR	((0))	Yes		CATSPRICE
157	CATSTCURR	Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TWAER	Allow NULL?
158	CATSPEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
159	BEMOT	Accounting Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TBMOT	BEMOT	Allow NULL?
160	PRZ01	Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	*	CO_PRZNR	Allow NULL?
161	IPRZ1	Current quantity to be confirmed for the business process	decimal	13	3	QUAN	((0))	Yes		RU_IPRZS
162	IPRE1	Unit of measurement for conf. quantity for business process	nvarchar	3	0	UNIT	(N' ')	Yes	*	RU_IPRZE	Allow NULL?
163	IPRK1	No remaining quantity expected for business process	char	1	0	CHAR	(N' ')	Yes		RU_IPRZK	Allow NULL?
164	OPRZ1	Remaining quantity for business process	decimal	13	3	QUAN	((0))	Yes		OPRZ1
165	OPRE1	Unit for remaining quantity of business process	nvarchar	3	0	UNIT	(N' ')	Yes	*	OPRE1	Allow NULL?
166	EXNAM	External creator of confirmation	nvarchar	12	0	CHAR	(N' ')	Yes		RU_EXNAM	Allow NULL?
167	EXERD	External date of entry for confirmation	nvarchar	8	0	DATS	(N'00000000')	Yes		RU_EXERD	Allow NULL?
168	EXERZ	External time of entry for confirmation	nvarchar	6	0	TIMS	(N'000000')	Yes		RU_EXERZ	Allow NULL?
169	WEBLNR	Number of a document from a goods movement with errors	nvarchar	10	0	CHAR	(N' ')	Yes		WEBLNR	Allow NULL?
170	PKLUZ	Delivery time for a kanban, time of day	nvarchar	6	0	TIMS	(N'000000')	Yes		PKLUZ	Allow NULL?
171	PKLDT	Delivery time for a kanban, date	nvarchar	8	0	DATS	(N'00000000')	Yes		PKLDT	Allow NULL?
172	PKBMG	Quantity requested	decimal	13	3	QUAN	((0))	Yes		PKBMG
173	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
174	SKOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	KOKRS	Allow NULL?
175	SKOSTL	Sender Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	SKOSTL	Allow NULL?
176	NODAT	Do not update actual date in the operation	char	1	0	CHAR	(N' ')	Yes		NODAT	Allow NULL?
177	ISMNU	Unit for work	nvarchar	3	0	UNIT	(N' ')	Yes	*	ARBEITE	Allow NULL?
178	OFMNU	Unit for work	nvarchar	3	0	UNIT	(N' ')	Yes	*	ARBEITE	Allow NULL?
179	PACKNO	Package number	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	PACKNO	Allow NULL?
180	SLK01	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
181	SLK02	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
182	SLK03	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
183	SLK04	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
184	SLK05	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
185	SLK06	Indicator: Determine target activity	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_ACTIVITY	Allow NULL?
186	SPRK1	Indicator: Determine target qty for business transaction	char	1	0	CHAR	(N' ')	Yes		RU_TARGET_BUS_PROC	Allow NULL?
187	EXTID	External Key for Confirmation (for example, from PDC System)	varbinary	16	0	RAW		Yes		RU_EXTID

TOP ERP 6.0 | AFRV_DEL INDEXES

Name	Primary	Unique	Type	Columns
AFRV_DEL~0	Yes	Yes	CLUSTERED	COUNTER, AFRUV, AFORI, CLIENT

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

187 COLUMNS | 1 INDEXES | ERP 6.0 | AFRV_DEL TABLE

TOP ERP 6.0 | AFRV_DEL COLUMNS

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

187 COLUMNS | 1 INDEXES | ERP 6.0 | AFRV_DEL TABLE

TOPERP 6.0 | AFRV_DEL COLUMNS

TOPERP 6.0 | AFRV_DEL INDEXES

TOP ERP 6.0 | AFRV_DEL COLUMNS

TOP ERP 6.0 | AFRV_DEL INDEXES