SAP table AFRV (Confirmation pool)

SAP table AFRV has 4 primary key fields being CLIENT,AFORI,AFRUV,COUNTER.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
AFORI Origin Indicator of PDC Message (Application) CHAR 1 0 ORIND
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 CHAR 20 0 AFRH AFRUV
COUNTER Internal counter NUMC 8 0 CIM_COUNT
VTEXT Operation Short Text CHAR 40 0 LTXA1
BEAKNZ Indicator: Entry in pool was confirmed CHAR 1 0 BEAKNZ
MPE_CONF Confirmation generated by Manufacturing Processing Execution CHAR 1 0 MPE_CONF
PDSNR Sequential number for PDC messages NUMC 12 0 * PDSNR_D
PERNR Personnel Number NUMC 8 0 PERNR_D
INFTY Infotype CHAR 4 0 INFOTYP
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Character field, length 2 CHAR 2 0 CHAR_LG_02
SPRPS Single-Character Flag CHAR 1 0 CHAR1
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
KSTRG Cost Object CHAR 12 0 CKPH KSTRG
POSNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
KDAUF Sales Order Number CHAR 10 0 * KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRZNR Business Process CHAR 12 0 * CO_PRZNR
FISTL Funds Center CHAR 16 0 * FM_FICTR
FIPOS Commitment Item CHAR 14 0 * FIPOS
GEBER Fund CHAR 10 0 * BP_GEBER
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
LSTNR Activity Number CHAR 18 0 ASMD ASNUM
LTLST Activity Type CHAR 6 0 CSLA LSTAR
SBUKR Company Code CHAR 4 0 T001 BUKRS
SGSBR Business Area CHAR 4 0 TGSB GSBER
SKOST Cost Center CHAR 10 0 CSKS KOSTL
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
EXBEL Field length 18 CHAR 18 0 CHAR18
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
OTYPE Object Type CHAR 2 0 T778O OTYPE
STELL Job NUMC 8 0 * STELL
POHRS Number of Hours for Activity Allocation/External Services DEC 7 2 POHRS
DART Character field, length 2 CHAR 2 0 * CHAR_LG_02
UDART Character field, length 2 CHAR 2 0 * CHAR_LG_02
SGTXT Item Text CHAR 50 0 SGTXT
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
LDATE Entry Date DATS 8 0 BDE_DATE
LTIME Time received TIMS 6 0 BDE_TIME
ERDAT Created on DATS 8 0 PHDAT
ERTIM Created at TIMS 6 0 PHTIM
SATZA Time Event Type CHAR 3 0 RETYP
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 CHAR 4 0 TERID
ABWGR Undefined range (can be used for patch levels) CHAR 4 0 * CHAR4
EXLGA Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
ZEINH 3-Byte field CHAR 3 0 * CHAR3
HRAZL Decimal field of length 7 DEC 7 2 DEC07
HRBET Currency amount, field length 9 CURR 9 2 CURR09
ORIGF Origin Indicator of PDC Message CHAR 1 0 ORIGF
Was entered in a subsystem
E Was entered by employee in ESS
G Not currently in use
M Was entered or changed by Time Administrator
S Was entered in a subsystem and processed in ESS
DALLF Single-Character Flag CHAR 1 0 CHAR1
PDC_OTYPE Object Type CHAR 2 0 * OTYPE
PDC_PLANS Position NUMC 8 0 * PLANS
PDC_USRUP Customer-Specific Field CHAR 20 0 PDC_USRUP
REFEX Single-Character Flag CHAR 1 0 CHAR1
ORDEX Single-Character Flag CHAR 1 0 CHAR1
ZAUSW Time Recording ID Number NUMC 8 0 DZAUSW
ORIND Origin Indicator of PDC Message (Application) CHAR 1 0 ORIND
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 CHAR 1 0 INDEU
Insert Record
D Delete/cancel record
I Insert Record
U Change record/ Used only by HR
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
SPLIT Split number INT1 3 0 CY_SPLIT
RMZHL Confirmation counter NUMC 8 0 CO_RMZHL
BUDAT Posting Date DATS 8 0 BUCHDATUM
WERKS Plant CHAR 4 0 WERKS_D
ARBPL Work Center CHAR 8 0 ARBPL
KAPAR Capacity category CHAR 3 0 * KAPART
LTXA1 Confirmation text CHAR 40 0 CO_RTEXT
ISERH Confirmed Break Time QUAN 9 3 ISERH
ZEIER Unit for a Break Time UNIT 3 0 * DZEIER
ILE01 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM01 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM01 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE01 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK01 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ILE02 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM02 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM02 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE02 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK02 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ILE03 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM03 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM03 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE03 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK03 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ILE04 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM04 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM04 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE04 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK04 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ILE05 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM05 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM05 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE05 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK05 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ILE06 Unit of measure for the activity to be confirmed UNIT 3 0 * CO_ISMNGEH
ISM06 Activity Currently to be Confirmed QUAN 13 3 CO_ISMNG
OFM06 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE06 Unit of Measurement of Standard Value UNIT 3 0 * VGWRTEH
LEK06 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
ISMNW Actual work QUAN 7 1 ISMNW
ISMNE Unit for work UNIT 3 0 * ARBEITE
LEARR Activity Type for Confirmation CHAR 6 0 * LEARR
OFMNW Remaining work QUAN 7 1 REMNW
OFMNE Unit of Measure for Remaining Work UNIT 3 0 * OFMNE
LEKNW Indicator: No Remaining Work Expected CHAR 1 0 LEKNW
ABARB Confirmation: Degree of processing NUMC 3 0 CO_ABARB
IDAUR Actual Duration for Confirmation QUAN 5 1 IDAUR
IDAUE Unit for actual duration UNIT 3 0 * IDAURE
ODAUR Remaining duration of activity QUAN 5 1 ODAUR
ODAUE Unit for remaining duration UNIT 3 0 * ODAUE
LOART Wage type CHAR 4 0 LOHNART
QUALF Suitability CHAR 2 0 * QUALF
ANZMA Number of employees DEC 5 2 ANZMS
LOGRP Wage Group CHAR 3 0 * LOHNGRP
LMNGA Yield to be Confirmed QUAN 13 3 RU_LMNGA
XMNGA Scrap to Be Confirmed QUAN 13 3 RU_XMNGA
MEINH Confirmation Unit of Measure UNIT 3 0 * RU_VORME
GRUND Reason for Variance CHAR 4 0 * CO_AGRND
ISDD Confirmed Start Date of Execution DATS 8 0 RU_ISDD
ISDZ Confirmed Time for 'Start Execution' TIMS 6 0 RU_ISDZ
IERD Confirmed Date for 'Finish Setup' DATS 8 0 RU_IERD
IERZ Confirmed Time for 'Finish Setup' TIMS 6 0 RU_IERZ
ISBD Confirmed Date for 'Start Processing' DATS 8 0 RU_ISBD
ISBZ Confirmed Time for 'Start Processing' TIMS 6 0 RU_ISBZ
IEBD Confirmed Date for 'Finish Processing" DATS 8 0 RU_IEBD
IEBZ Confirmed Time for 'Finish Processing' TIMS 6 0 RU_IEBZ
ISAD Confirmed Date for 'Start Teardown' DATS 8 0 RU_ISAD
ISAZ Confirmed Time for 'Start Teardown' TIMS 6 0 RU_ISAZ
IEDD Confirmed Finish Date of Execution DATS 8 0 RU_IEDD
IEDZ Confirmed Time for 'Finish Execution' TIMS 6 0 RU_IEDZ
PEDD Forecast finish date of operation from confirmation DATS 8 0 CO_PEDD
PEDZ Forecast End Time of Operation from Confirmation TIMS 6 0 CO_PEDZ
AUERU Activation of Final Confirmation CHAR 1 0 AUERU
AUSOR Clear Open Reservations CHAR 1 0 AUSOR
APLFL Sequence CHAR 6 0 PLNFOLGE
UVORN Suboperation CHAR 4 0 UVORN
AUTYP Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
PKNUM Control Cycle CHAR 7 0 PKHD PKNUM
PKPOS Kanban Control Cycle Item NUMC 3 0 PKPOS
PKBST Kanban Status CHAR 1 0 PKBST
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 QUAN 13 3 ABMNG
RMNGA Total Confirmed Rework Quantity QUAN 13 3 RMNGA
PKKEY Kanban Identification Number NUMC 10 0 * PKKEY
PKIMG Actual Quantity QUAN 13 3 PKIMG
CATSBELNR Document no. CHAR 10 0 CATSBELNR
CATSPRICE Price in Transaction Currency CURR 11 2 CATSPRICE
CATSTCURR Transaction Currency CUKY 5 0 * TWAER
CATSPEINH Price unit DEC 5 0 PEINH
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
PRZ01 Business Process CHAR 12 0 * CO_PRZNR
IPRZ1 Current Quantity for Business Process QUAN 13 3 RU_IPRZS
IPRE1 Unit of Measure for Business Process Quantity UNIT 3 0 * RU_IPRZE
IPRK1 No Remaining Quantity Expected for Business Process CHAR 1 0 RU_IPRZK
OPRZ1 Remaining Quantity for Business Process QUAN 13 3 OPRZ1
OPRE1 Unit for Remaining Quantity of Business Process UNIT 3 0 * OPRE1
EXNAM External creator of confirmation CHAR 12 0 RU_EXNAM
EXERD External date of entry for confirmation DATS 8 0 RU_EXERD
EXERZ External time of entry for confirmation TIMS 6 0 RU_EXERZ
WEBLNR Number of a document from a goods movement with errors CHAR 10 0 WEBLNR
PKLUZ Delivery time for a kanban, time of day TIMS 6 0 PKLUZ
PKLDT Delivery time for a kanban, date DATS 8 0 PKLDT
PKBMG Requested Quantity QUAN 13 3 PKBMG
CHARG Batch Number CHAR 10 0 * CHARG_D
SKOKRS Controlling Area CHAR 4 0 * KOKRS
SKOSTL Sender Cost Center CHAR 10 0 * SKOSTL
NODAT Do not update actual date in the operation CHAR 1 0 NODAT
ISMNU Unit for work UNIT 3 0 * ARBEITE
OFMNU Unit for work UNIT 3 0 * ARBEITE
PACKNO Package number NUMC 10 0 * PACKNO
SLK01 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SLK02 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SLK03 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SLK04 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SLK05 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SLK06 Indicator: Determine target activity CHAR 1 0 RU_TARGET_ACTIVITY
SPRK1 Indicator: Determine target qty for business transaction CHAR 1 0 RU_TARGET_BUS_PROC
EXTID External Key for Confirmation (for example, from PDC System) RAW 16 0 RU_EXTID
CATSCURR Transaction Currency CUKY 5 0 * TWAER

AFRV foreign key relationships

Table Field Check Table Check Field
0 AFRV AFRUV AFRH Header information for confirmation pool AFRUV
1 AFRV AUFNR AUFK Order master data AUFNR
0 AFRV BEMOT TBMOT Accounting indicators MANDT
0 AFRV BEMOT TBMOT Accounting indicators BEMOT
1 AFRV BUKRS T001 Company Codes BUKRS
0 AFRV CLIENT T000 Clients MANDT
1 AFRV EBELN EKKO Purchasing Document Header MANDT
1 AFRV EBELN EKKO Purchasing Document Header EBELN
0 AFRV EBELP EKPO Purchasing Document Item MANDT
0 AFRV EBELP EKPO Purchasing Document Item EBELN
1 AFRV GSBER TGSB Business Areas MANDT
1 AFRV GSBER TGSB Business Areas GSBER
0 AFRV KOKRS TKA01 Controlling Areas MANDT
1 AFRV KOSTL CSKS Cost Center Master Record MANDT
1 AFRV KOSTL CSKS Cost Center Master Record KOKRS
1 AFRV KOSTL CSKS Cost Center Master Record KOSTL
1 AFRV KOSTL CSKS Cost Center Master Record DATBI
0 AFRV KSTRG CKPH Master Record: Cost Object ID Number MANDT
0 AFRV KSTRG CKPH Master Record: Cost Object ID Number KSTRG
0 AFRV KSTRG CKPH Master Record: Cost Object ID Number DATBI
1 AFRV LSTAR CSLA Activity master MANDT
1 AFRV LSTAR CSLA Activity master KOKRS
1 AFRV LSTAR CSLA Activity master DATBI
0 AFRV LTLST CSLA Activity master MANDT
0 AFRV LTLST CSLA Activity master KOKRS
0 AFRV LTLST CSLA Activity master DATBI
1 AFRV NPLNR AUFK Order master data AUFNR
0 AFRV OTYPE T778O Object Types MANDT
0 AFRV OTYPE T778O Object Types OTYPE
1 AFRV PKNUM PKHD Control Cycle MANDT
0 AFRV POSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 AFRV POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 AFRV SBUKR T001 Company Codes BUKRS
0 AFRV SGSBR TGSB Business Areas MANDT
0 AFRV SGSBR TGSB Business Areas GSBER
1 AFRV SKOST CSKS Cost Center Master Record MANDT
1 AFRV SKOST CSKS Cost Center Master Record KOKRS
1 AFRV SKOST CSKS Cost Center Master Record DATBI