AFRP0 SAP (Table of planned changes for confirmation (PDC)) Table details
Dictionary Type: Table
Description: Table of planned changes for confirmation (PDC)
Description: Table of planned changes for confirmation (PDC)
Table field list including key, data, relationships and ABAP select examples
AFRP0 is a standard SAP Table which is used to store Table of planned changes for confirmation (PDC) data and is available within R/3 SAP systems depending on the version and release level.
The AFRP0 table consists of various fields, each holding specific information or linking keys about Table of planned changes for confirmation (PDC) data available in SAP. These include PDSNR (Sequential number for PDC messages), COUNTER (Internal counter), ERNAM (Entered by), ERTSTAMPS (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AFRP0 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PDSNR | Sequential number for PDC messages | PDSNR_D | NUMC | 12 | Assigned to domain | PDSNR | |||
COUNTER | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
ERNAM | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
ERTSTAMPS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS | ||||
RU_PCOUNT | Number of failed attempts at a confirmation | RU_PCOUNT | INT4 | 10 | SINT4_NOS | ||||
RU_ORINA | Origin indicator: Confirmation application | RU_ORINA | CHAR | 1 | RU_ORINA | ||||
RU_ORINI | Origin indicator: Confirmation interface | RU_ORINI | CHAR | 1 | RU_ORINI | ||||
RU_VSWBN | Indicator: Goods movements are already determined | VSWBN | CHAR | 1 | XFELD | ||||
WEBLNR | Number of a document from a goods movement with errors | WEBLNR | CHAR | 10 | AFFW | ALPHA | BELNR | ||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
APLFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
KAPAR | Capacity category | KAPART | CHAR | 3 | Assigned to domain | KAPART | CAA | ||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | AUERU_VS | ||||
AUSOR | Clear Open Reservations | AUSBU | CHAR | 1 | XFELD | ||||
BUDAT | Posting date | BUCHDATUM | DATS | 8 | DATUM | ||||
GRUND | Reason for Variance | CO_AGRND | CHAR | 4 | Assigned to domain | CO_AGRND | |||
LTXA1 | Confirmation text | CO_RTEXT | CHAR | 40 | TEXT40 | ||||
EXNAM | External creator of confirmation | RU_EXNAM | CHAR | 12 | USNAM | ||||
EXERD | External date of entry for confirmation | RU_EXERD | DATS | 8 | DATUM | ||||
EXERZ | External time of entry for confirmation | RU_EXERZ | TIMS | 6 | UZEIT | ||||
MEINH | Confirmation unit of measure | RU_VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LMNGA | Yield to Be Confirmed | RU_LMNGA | QUAN | 13(3) | MENGV13 | ||||
XMNGA | Scrap to Be Confirmed | RU_XMNGA | QUAN | 13(3) | MENGV13 | ||||
RMNGA | Current rework quantity to be confirmed | RU_RMNGA | QUAN | 13(3) | MENGV13 | ||||
ISDD | Confirmed date for start of execution | RU_ISDD | DATS | 8 | DATUM | ||||
ISDZ | Confirmed time for 'Execution start' | RU_ISDZ | TIMS | 6 | ATIME | ||||
IERD | Confirmed date for 'Setup finish' | RU_IERD | DATS | 8 | DATUM | ||||
IERZ | Confirmed time for 'Setup finish' | RU_IERZ | TIMS | 6 | ATIME | ||||
ISBD | Confirmed date for 'Processing start' | RU_ISBD | DATS | 8 | DATUM | ||||
ISBZ | Confirmed time for 'Processing start' | RU_ISBZ | TIMS | 6 | ATIME | ||||
IEBD | Confirmed date for 'processing finish' | RU_IEBD | DATS | 8 | DATUM | ||||
IEBZ | Confirmed time for 'processing finish' | RU_IEBZ | TIMS | 6 | ATIME | ||||
ISAD | Confirmed date for 'teardown start' | RU_ISAD | DATS | 8 | DATUM | ||||
ISAZ | Confirmed time for 'teardown start' | RU_ISAZ | TIMS | 6 | ATIME | ||||
IEDD | Confirmed date for execution finish | RU_IEDD | DATS | 8 | DATUM | EDR | |||
IEDZ | Confirmed time for 'Execution finish' | RU_IEDZ | TIMS | 6 | ATIME | EZR | |||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
SATZA | Record type for confirmation | CO_SATZA | CHAR | 3 | CO_SATZA | ||||
ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM01 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK01 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM02 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK02 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM03 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK03 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM04 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK04 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM05 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK05 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISM06 | Activity Currently to be Confirmed | RU_ISMNG | QUAN | 13(3) | MENGV13 | ||||
LEK06 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
IPRZ1 | Current quantity to be confirmed for the business process | RU_IPRZS | QUAN | 13(3) | MENGV13 | ||||
IPRE1 | Unit of measurement for conf. quantity for business process | RU_IPRZE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IPRK1 | No remaining quantity expected for business process | RU_IPRZK | CHAR | 1 | XFELD | ||||
ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
OFE01 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE02 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE03 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE04 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE05 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFE06 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OPRZ1 | Remaining quantity for business process | OPRZ1 | QUAN | 13(3) | MENGV13 | ||||
OPRE1 | Unit for remaining quantity of business process | OPRE1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PERNR | Personnel number | CO_PERNR | NUMC | 8 | PERNR | PER | |||
ZAUSW | Time Recording ID Number | DZAUSW | NUMC | 8 | ZAUSW | ||||
LOART | Wage Type | LOHNART | CHAR | 4 | LOART | ||||
QUALF | Suitability | QUALF | CHAR | 2 | Assigned to domain | QUALF | |||
ANZMA | Number of employees | ANZMS | DEC | 5(2) | ANZMA | ||||
LOGRP | Wage group | LOHNGRP | CHAR | 3 | Assigned to domain | LOHNGRP | |||
ZEIER | Unit for the break time | DZEIER | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ISERH | Confirmed break time | ISERH | QUAN | 9(3) | VGWRT | ||||
SLK01 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK02 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK03 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK04 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK05 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SLK06 | Indicator: Determine target activity | RU_TARGET_ACTIVITY | CHAR | 1 | XFELD | ||||
SPRK1 | Indicator: Determine target qty for business transaction | RU_TARGET_BUS_PROC | CHAR | 1 | XFELD | ||||
EXTID | External Key for Confirmation (for example, from PDC System) | RU_EXTID | RAW | 16 | SYSUUID | ||||
LDATE | Logical Date | LDATE | DATS | 8 | DATUM | ||||
LTIME | Logical time | LTIME | TIMS | 6 | UZEIT |
Key field | Non-key field |
How do I retrieve data from SAP table AFRP0 using ABAP code
The following ABAP code Example will allow you to do a basic selection on AFRP0 to SELECT all data from the tableDATA: WA_AFRP0 TYPE AFRP0.
SELECT SINGLE *
FROM AFRP0
INTO CORRESPONDING FIELDS OF WA_AFRP0
WHERE...
How to access SAP table AFRP0
Within an ECC or HANA version of SAP you can also view further information about AFRP0 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects