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