SAP ABAP Table AFRV_DEL (Backup Copy for 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_DEL	Table Relationship Diagram
Short Description	Backup Copy for 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_DEL	AFRUV	AFRH	AFRUV	KEY	1	N
2	AFRV_DEL	AUFNR	AUFK	AUFNR
3	AFRV_DEL	BEMOT	TBMOT	BEMOT
4	AFRV_DEL	BUKRS	T001	BUKRS
5	AFRV_DEL	CLIENT	T000	MANDT	KEY	1	CN
6	AFRV_DEL	EBELN	EKKO	EBELN
7	AFRV_DEL	EBELP	EKPO	EBELP
8	AFRV_DEL	GSBER	TGSB	GSBER
9	AFRV_DEL	KDAUF	VBUK	VBELN
10	AFRV_DEL	KOKRS	TKA01	KOKRS
11	AFRV_DEL	KOSTL	CSKS	KOSTL
12	AFRV_DEL	KSTRG	CKPH	KSTRG
13	AFRV_DEL	LSTAR	CSLA	LSTAR
14	AFRV_DEL	LSTNR	ASMD	ASNUM
15	AFRV_DEL	LTLST	CSLA	LSTAR
16	AFRV_DEL	NPLNR	AUFK	AUFNR
17	AFRV_DEL	OTYPE	T778O	OTYPE
18	AFRV_DEL	PKNUM	PKHD	PKNUM
19	AFRV_DEL	POSNR	PRPS	PSPNR
20	AFRV_DEL	SBUKR	T001	BUKRS
21	AFRV_DEL	SGSBR	TGSB	GSBER
22	AFRV_DEL	SKOST	CSKS	KOSTL

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C