SAP AFRP0 Table of planned changes for confirmation (PDC) Table
Overview
AFRP0 is a standard SAP S/4HANA table that stores Table of planned changes for confirmation (PDC) data. There are total 100 fields in the AFRP0 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFRP0 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 AFRP0 to other SAP tables and standard CDS views available based on AFRP0 table in S/4HANA 2020.
Techincal Settings of AFRP0
Below are technical details of the table AFRP0
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFRP0 Fields
The following table gives you an overview of the fields available in AFRP0
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| PDSNR | Sequential number for PDC messages | PDSNR_D | * | NUMC | 12 |
| COUNTER | Internal counter | CIM_COUNT | NUMC | 8 | |
| ERNAM | Entered By | AUFERFNAM | CHAR | 12 | |
| ERTSTAMPS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | |
| RU_PCOUNT | Number of failed attempts at a confirmation | RU_PCOUNT | INT4 | 10 | |
| RU_ORINA | Origin indicator: Confirmation application | RU_ORINA | CHAR | 1 | |
| RU_ORINI | Origin indicator: Confirmation interface | RU_ORINI | CHAR | 1 | |
| RU_VSWBN | Indicator: Goods movements are already determined | VSWBN | CHAR | 1 | |
| WEBLNR | Number of a document from a goods movement with errors | WEBLNR | AFFW | CHAR | 10 |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| AUFNR | Order Number | AUFNR | * | CHAR | 12 |
| APLFL | Sequence | PLNFOLGE | CHAR | 6 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| UVORN | Suboperation | UVORN | CHAR | 4 | |
| KAPAR | Capacity category | KAPART | * | CHAR | 3 |
| SPLIT | Split number | CY_SPLIT | INT1 | 3 | |
| AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | |
| AUSOR | Clear Open Reservations | AUSBU | CHAR | 1 | |
| BUDAT | Posting Date | BUCHDATUM | DATS | 8 | |
| GRUND | Reason for Variance | CO_AGRND | * | CHAR | 4 |
| LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40 | |
| 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 | |
| MEINH | Confirmation Unit of Measure | RU_VORME | * | UNIT | 3 |
| LMNGA | Yield to be Confirmed | RU_LMNGA | QUAN | 13 | |
| XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13 | |
| RMNGA | Current Confirmation Rework Quantity | RU_RMNGA | QUAN | 13 | |
| 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 | |
| WERKS | Plant | WERKS_D | * | CHAR | 4 |
| ARBPL | Work center | ARBPL | CHAR | 8 | |
| SATZA | Record Type for Confirmation | CO_SATZA | CHAR | 3 | |
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | * | UNIT | 3 |
| ISM01 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13 | |
| 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 | RU_ISMNG | QUAN | 13 | |
| 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 | RU_ISMNG | QUAN | 13 | |
| 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 | RU_ISMNG | QUAN | 13 | |
| 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 | RU_ISMNG | QUAN | 13 | |
| 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 | RU_ISMNG | QUAN | 13 | |
| LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| 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 | |
| ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | |
| OFE01 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE02 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM02 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE03 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM03 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE04 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM04 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE05 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM05 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OFE06 | Unit of Measurement of Standard Value | VGWRTEH | * | UNIT | 3 |
| OFM06 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 9 | |
| OPRZ1 | Remaining Quantity for Business Process | OPRZ1 | QUAN | 13 | |
| OPRE1 | Unit for Remaining Quantity of Business Process | OPRE1 | * | UNIT | 3 |
| PERNR | Personnel number | CO_PERNR | NUMC | 8 | |
| ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | |
| LOART | Wage type | LOHNART | CHAR | 4 | |
| QUALF | Suitability | QUALF | * | CHAR | 2 |
| ANZMA | Number of employees | ANZMS | DEC | 5 | |
| LOGRP | Wage Group | LOHNGRP | * | CHAR | 3 |
| ZEIER | Unit for a Break Time | DZEIER | * | UNIT | 3 |
| ISERH | Confirmed Break Time | ISERH | QUAN | 9 | |
| 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 | |
| LDATE | Logical Date | LDATE | DATS | 8 | |
| LTIME | Logical time | LTIME | TIMS | 6 |
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 AFRP0
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFRP0 | WEBLNR | : | AFFW |