1. Home
  2. Resources
  3. SAP Tables
  4. AFRV - Confirmation pool

SAP Table AFRV

Confirmation pool

AFRV (Confirmation pool) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFRV to other SAP tables.

Source: AFRV (Confirmation pool)

AFRV table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
AFORI Origin Indicator of PDC Message (Application) ORIND CHAR 1 0
1 Data from HR (Human Resources Management)
2 Data from PP (production orders)
3 Data from PM (maintenance work orders)
4 Data from PS (network orders)
5 Data from PP-PK (kanban)
6 Data from PP-PI (process orders)
7 Data originate from QM (QM orders)
8 Data originate from QM (results recording)
S Error records which cannot be reposted
AFRUV Confirmation pool AFRUV AFRH CHAR 20 0
COUNTER Internal counter CIM_COUNT NUMC 8 0
VTEXT Operation short text LTXA1 CHAR 40 0
BEAKNZ Indicator: Entry in pool was confirmed BEAKNZ CHAR 1 0
X Yes
NULL No
PDSNR Sequential number for PDC messages PDSNR_D NUMC 12 0
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFOTYP CHAR 4 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Character field, length 2 CHAR_LG_02 CHAR 2 0
SPRPS Single-Character Indicator CHAR1 CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
KSTRG Cost Object KSTRG CKPH CHAR 12 0
POSNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR AUFK CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRZNR Business Process CO_PRZNR CHAR 12 0
FISTL Funds Center FM_FICTR CHAR 16 0
FIPOS Commitment Item FIPOS CHAR 14 0
GEBER Fund BP_GEBER CHAR 10 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
LSTNR Activity Number ASNUM ASMD CHAR 18 0
LTLST Activity Type LSTAR CSLA CHAR 6 0
SBUKR Company Code BUKRS T001 CHAR 4 0
SGSBR Business Area GSBER TGSB CHAR 4 0
SKOST Cost Center KOSTL CSKS CHAR 10 0
LSTAR Activity Type LSTAR CSLA CHAR 6 0
EXBEL Field length 18 CHAR18 CHAR 18 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
OTYPE Object Type OTYPE T778O CHAR 2 0
STELL Job STELL NUMC 8 0
POHRS Number of Hours for Activity Allocation/External Services POHRS DEC 7 2
DART Character field, length 2 CHAR_LG_02 CHAR 2 0
UDART Character field, length 2 CHAR_LG_02 CHAR 2 0
SGTXT Item Text SGTXT CHAR 50 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
LDATE Entry Date BDE_DATE DATS 8 0
LTIME Time received BDE_TIME TIMS 6 0
ERDAT Created on PHDAT DATS 8 0
ERTIM Created at PHTIM TIMS 6 0
SATZA Time Event Type RETYP CHAR 3 0
01 Clock-in
02 Clock-out
03 Clock-in/-out
04 Start of off-site work
05 End of off-site work
06 Start or end of off-site work
07 Start of off-site work at home
08 End of off-site work at home
09 Start or end of off-site work at home
A10 Start teardown PP
A20 Partial teardown PP
A30 Interrupt teardown PP
A40 Finish teardown PP
B10 Start processing PP
B20 Partial processing PP
B30 Interrupt processing PP
B40 Finish processing PP
I20 Time ticket PM partial confirmation
I40 Time ticket PM final confirmation
K10 Currently not in use
K20 Currently not in use
K30 Currently not in use
L20 Time ticket PP partial confirmation
L40 Time ticket PP final confirmation
N10 PM work start
N20 PM work part-finish
N30 PM work interruption
N40 PM work finish
P01 Clock-in/-out
P02 Start or end of break
P03 Start or end of off-site work
P04 Start or end of off-site work at home
P05 Interim entry
P10 Clock-in
P11 Change
P15 Start of break
P20 Clock-out
P25 End of break
P30 Start of off-site work
P35 Start of off-site work at home
P40 End of off-site work
P45 End of off-site work at home
P50 External wage type
P60 Information entry
R10 Begin setup PP
R20 Partial setup PP
R30 Interrupt setup PP
R40 Finish setup PP
S10 Start of malfunction (not yet released)
S40 End of malfunction (not yet released)
T20 Time ticket PS partial confirmation
T40 Time ticket PS final confirmation
V20 Partial variable activity PP
V40 Finish variable activity PP
W10 PS work start
W20 PS work part-finish
W30 PS work interruption
W40 PS work finish
TERID Terminal ID TERID CHAR 4 0
ABWGR Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
EXLGA Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
ZEINH 3-Byte field CHAR3 CHAR 3 0
HRAZL Decimal field of length 7 DEC07 DEC 7 2
HRBET Currency amount, field length 9 CURR09 CURR 9 2
ORIGF Origin Indicator of PDC Message ORIGF CHAR 1 0
NULL Was entered in a subsystem
M Was entered or changed by Time Administrator
G Not currently in use
E Was entered by employee in ESS
S Was entered in a subsystem and processed in ESS
DALLF Single-Character Indicator CHAR1 CHAR 1 0
PDC_OTYPE Object Type OTYPE CHAR 2 0
PDC_PLANS Position PLANS NUMC 8 0
PDC_USRUP Customer-Specific Field PDC_USRUP CHAR 20 0
REFEX Single-Character Indicator CHAR1 CHAR 1 0
ORDEX Single-Character Indicator CHAR1 CHAR 1 0
ZAUSW Time Recording ID Number DZAUSW NUMC 8 0
ORIND Origin Indicator of PDC Message (Application) ORIND CHAR 1 0
1 Data from HR (Human Resources Management)
2 Data from PP (production orders)
3 Data from PM (maintenance work orders)
4 Data from PS (network orders)
5 Data from PP-PK (kanban)
6 Data from PP-PI (process orders)
7 Data originate from QM (QM orders)
8 Data originate from QM (results recording)
S Error records which cannot be reposted
INDEU Insert/delete or update indicator INDEU CHAR 1 0
NULL Insert Record
I Insert Record
D Delete/cancel record
U Change record/ Used only by HR
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
SPLIT Split number CY_SPLIT INT1 3 0
RMZHL Confirmation counter CO_RMZHL NUMC 8 0
BUDAT Posting date BUCHDATUM DATS 8 0
WERKS Plant WERKS_D CHAR 4 0
ARBPL Work center ARBPL CHAR 8 0
KAPAR Capacity category KAPART CHAR 3 0
LTXA1 Confirmation text CO_RTEXT CHAR 40 0
ISERH Confirmed break time ISERH QUAN 9 3
ZEIER Unit for the break time DZEIER UNIT 3 0
ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM01 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM01 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE01 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK01 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM02 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM02 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE02 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK02 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM03 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM03 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE03 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK03 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM04 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM04 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE04 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK04 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM05 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM05 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE05 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK05 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ISM06 Activity currently to be confirmed CO_ISMNG QUAN 13 3
OFM06 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE06 Unit of measure for the standard value VGWRTEH UNIT 3 0
LEK06 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
ISMNW Actual work ISMNW QUAN 7 1
ISMNE Unit for work ARBEITE UNIT 3 0
LEARR Activity Type for Confirmation LEARR CHAR 6 0
OFMNW Remaining work REMNW QUAN 7 1
OFMNE Unit of measure for remaining work OFMNE UNIT 3 0
LEKNW Indicator: No Remaining Work Expected LEKNW CHAR 1 0
X Yes
NULL No
ABARB Confirmation: Degree of processing CO_ABARB NUMC 3 0
IDAUR Actual Duration for Confirmation IDAUR QUAN 5 1
IDAUE Unit for actual duration IDAURE UNIT 3 0
ODAUR Remaining duration of activity ODAUR QUAN 5 1
ODAUE Unit for remaining duration ODAUE UNIT 3 0
LOART Wage Type LOHNART CHAR 4 0
QUALF Suitability QUALF CHAR 2 0
ANZMA Number of employees ANZMS DEC 5 2
LOGRP Wage group LOHNGRP CHAR 3 0
LMNGA Yield to Be Confirmed RU_LMNGA QUAN 13 3
XMNGA Scrap to Be Confirmed RU_XMNGA QUAN 13 3
MEINH Confirmation unit of measure RU_VORME UNIT 3 0
GRUND Reason for Variance CO_AGRND CHAR 4 0
ISDD Confirmed date for start of execution RU_ISDD DATS 8 0
ISDZ Confirmed time for 'Execution start' RU_ISDZ TIMS 6 0
IERD Confirmed date for 'Setup finish' RU_IERD DATS 8 0
IERZ Confirmed time for 'Setup finish' RU_IERZ TIMS 6 0
ISBD Confirmed date for 'Processing start' RU_ISBD DATS 8 0
ISBZ Confirmed time for 'Processing start' RU_ISBZ TIMS 6 0
IEBD Confirmed date for 'processing finish' RU_IEBD DATS 8 0
IEBZ Confirmed time for 'processing finish' RU_IEBZ TIMS 6 0
ISAD Confirmed date for 'teardown start' RU_ISAD DATS 8 0
ISAZ Confirmed time for 'teardown start' RU_ISAZ TIMS 6 0
IEDD Confirmed date for execution finish RU_IEDD DATS 8 0
IEDZ Confirmed time for 'Execution finish' RU_IEDZ TIMS 6 0
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
PEDZ Forecast finish time of operation from confirmation CO_PEDZ TIMS 6 0
AUERU Activation of Final Confirmation AUERU CHAR 1 0
NULL Partial confirmation
X Final confirmation
1 Automatic final confirmation
AUSOR Post open reservations AUSOR CHAR 1 0
X Yes
NULL No
APLFL Sequence PLNFOLGE CHAR 6 0
UVORN Suboperation UVORN CHAR 4 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
PKNUM Control cycle number PKNUM PKHD CHAR 7 0
PKPOS Kanban item number / control cycle item PKPOS NUMC 3 0
PKBST Kanban status PKBST CHAR 1 0
1 Container waiting (empty, w/o replen.)
2 Container empty, with replenishment
3 Container in process
4 Container in transit
5 Container full
6 Container in use
9 Container incorrect
ABMNG Reduced quantity in the planned order ABMNG QUAN 13 3
RMNGA Total confirmed rework quantity RMNGA QUAN 13 3
PKKEY Identification Number PKKEY NUMC 10 0
PKIMG Actual quantity PKIMG QUAN 13 3
CATSBELNR Document Number CATSBELNR CHAR 10 0
CATSPRICE Price in Transaction Currency CATSPRICE CURR 11 2
CATSTCURR Transaction Currency TWAER CUKY 5 0
CATSPEINH Price Unit PEINH DEC 5 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
PRZ01 Business Process CO_PRZNR CHAR 12 0
IPRZ1 Current quantity to be confirmed for the business process RU_IPRZS QUAN 13 3
IPRE1 Unit of measurement for conf. quantity for business process RU_IPRZE UNIT 3 0
IPRK1 No remaining quantity expected for business process RU_IPRZK CHAR 1 0
X Yes
NULL No
OPRZ1 Remaining quantity for business process OPRZ1 QUAN 13 3
OPRE1 Unit for remaining quantity of business process OPRE1 UNIT 3 0
EXNAM External creator of confirmation RU_EXNAM CHAR 12 0
EXERD External date of entry for confirmation RU_EXERD DATS 8 0
EXERZ External time of entry for confirmation RU_EXERZ TIMS 6 0
WEBLNR Number of a document from a goods movement with errors WEBLNR CHAR 10 0
PKLUZ Delivery time for a kanban, time of day PKLUZ TIMS 6 0
PKLDT Delivery time for a kanban, date PKLDT DATS 8 0
PKBMG Quantity requested PKBMG QUAN 13 3
CHARG Batch Number CHARG_D CHAR 10 0
SKOKRS Controlling Area KOKRS CHAR 4 0
SKOSTL Sender Cost Center SKOSTL CHAR 10 0
NODAT Do not update actual date in the operation NODAT CHAR 1 0
X Yes
NULL No
ISMNU Unit for work ARBEITE UNIT 3 0
OFMNU Unit for work ARBEITE UNIT 3 0
PACKNO Package number PACKNO NUMC 10 0
SLK01 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK02 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK03 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK04 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK05 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SLK06 Indicator: Determine target activity RU_TARGET_ACTIVITY CHAR 1 0
X Yes
NULL No
SPRK1 Indicator: Determine target qty for business transaction RU_TARGET_BUS_PROC CHAR 1 0
X Yes
NULL No
EXTID External Key for Confirmation (for example, from PDC System) RU_EXTID RAW 16 0

AFRV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFRV AFRUV AFRV AFRUV AFRH Header information for confirmation pool AFRUV
AFRV AFRUV AFRV AFORI AFRH Header information for confirmation pool AFORI
AFRV AFRUV AFRV CLIENT AFRH Header information for confirmation pool MANDT
AFRV AUFNR AFRV AUFNR AUFK Order master data AUFNR
AFRV AUFNR SYST MANDT AUFK Order master data MANDT
AFRV BEMOT SYST MANDT TBMOT Accounting indicators MANDT
AFRV BEMOT AFRV BEMOT TBMOT Accounting indicators BEMOT
AFRV BUKRS AFRV BUKRS T001 Company Codes BUKRS
AFRV BUKRS SYST MANDT T001 Company Codes MANDT
AFRV CLIENT AFRV CLIENT T000 Clients MANDT
AFRV EBELN SYST MANDT EKKO Purchasing Document Header MANDT
AFRV EBELN AFRV EBELN EKKO Purchasing Document Header EBELN
AFRV EBELP SYST MANDT EKPO Purchasing Document Item MANDT
AFRV EBELP AFRV EBELP EKPO Purchasing Document Item EBELP
AFRV EBELP AFRV EBELN EKPO Purchasing Document Item EBELN
AFRV GSBER AFRV GSBER TGSB Business Areas GSBER
AFRV GSBER SYST MANDT TGSB Business Areas MANDT
AFRV KDAUF SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
AFRV KDAUF AFRV KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
AFRV KOKRS SYST MANDT TKA01 Controlling Areas MANDT
AFRV KOKRS AFRV KOKRS TKA01 Controlling Areas KOKRS
AFRV KOSTL SYST MANDT CSKS Cost Center Master Data MANDT
AFRV KOSTL AFRV KOKRS CSKS Cost Center Master Data KOKRS
AFRV KOSTL AFRV KOSTL CSKS Cost Center Master Data KOSTL
AFRV KOSTL * CSKS Cost Center Master Data DATBI
AFRV KSTRG SYST MANDT CKPH Master Record: Cost Object ID Number MANDT
AFRV KSTRG AFRV KSTRG CKPH Master Record: Cost Object ID Number KSTRG
AFRV KSTRG * CKPH Master Record: Cost Object ID Number DATBI
AFRV LSTAR * CSLA Activity master DATBI
AFRV LSTAR AFRV LSTAR CSLA Activity master LSTAR
AFRV LSTAR AFRV KOKRS CSLA Activity master KOKRS
AFRV LSTAR SYST MANDT CSLA Activity master MANDT
AFRV LSTNR AFRV LSTNR ASMD Service Master: Basic Data ASNUM
AFRV LSTNR SYST MANDT ASMD Service Master: Basic Data MANDT
AFRV LTLST AFRV KOKRS CSLA Activity master KOKRS
AFRV LTLST * CSLA Activity master DATBI
AFRV LTLST AFRV LTLST CSLA Activity master LSTAR
AFRV LTLST SYST MANDT CSLA Activity master MANDT
AFRV NPLNR SYST MANDT AUFK Order master data MANDT
AFRV NPLNR AFRV NPLNR AUFK Order master data AUFNR
AFRV OTYPE SYST MANDT T778O Object Types MANDT
AFRV OTYPE AFRV OTYPE T778O Object Types OTYPE
AFRV PKNUM SYST MANDT PKHD Control Cycle MANDT
AFRV PKNUM AFRV PKNUM PKHD Control Cycle PKNUM
AFRV POSNR AFRV POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
AFRV POSNR SYST MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
AFRV SBUKR SYST MANDT T001 Company Codes MANDT
AFRV SBUKR AFRV SBUKR T001 Company Codes BUKRS
AFRV SGSBR AFRV SGSBR TGSB Business Areas GSBER
AFRV SGSBR SYST MANDT TGSB Business Areas MANDT
AFRV SKOST * CSKS Cost Center Master Data DATBI
AFRV SKOST AFRV SKOST CSKS Cost Center Master Data KOSTL
AFRV SKOST AFRV KOKRS CSKS Cost Center Master Data KOKRS
AFRV SKOST SYST MANDT CSKS Cost Center Master Data MANDT