SAP ABAP Table AFRV (Confirmation pool)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CORU (Package) R/3 Application development: PP Confirmations

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AFRV	Table Relationship Diagram
Short Description	Confirmation pool

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFRV	AFRUV	AFRH	AFRUV	KEY	1	N
2	AFRV	AUFNR	AUFK	AUFNR
3	AFRV	BEMOT	TBMOT	BEMOT
4	AFRV	BUKRS	T001	BUKRS
5	AFRV	CLIENT	T000	MANDT	KEY	1	CN
6	AFRV	EBELN	EKKO	EBELN
7	AFRV	EBELP	EKPO	EBELP
8	AFRV	GSBER	TGSB	GSBER
9	AFRV	KDAUF	VBUK	VBELN
10	AFRV	KOKRS	TKA01	KOKRS
11	AFRV	KOSTL	CSKS	KOSTL
12	AFRV	KSTRG	CKPH	KSTRG
13	AFRV	LSTAR	CSLA	LSTAR
14	AFRV	LSTNR	ASMD	ASNUM
15	AFRV	LTLST	CSLA	LSTAR
16	AFRV	NPLNR	AUFK	AUFNR
17	AFRV	OTYPE	T778O	OTYPE
18	AFRV	PKNUM	PKHD	PKNUM
19	AFRV	POSNR	PRPS	PSPNR
20	AFRV	SBUKR	T001	BUKRS
21	AFRV	SGSBR	TGSB	GSBER
22	AFRV	SKOST	CSKS	KOSTL

History

Last changed by/on	SAP	20130529
SAP Release Created in