AFRD SAP (Default values for collective confirmation) Table details

Dictionary Type: Table
Description: Default values for collective confirmation




ABAP Code to SELECT data from AFRD
Related tables to AFRD
Access table AFRD




Table field list including key, data, relationships and ABAP select examples

AFRD is a standard SAP Table which is used to store Default values for collective confirmation data and is available within R/3 SAP systems depending on the version and release level.

The AFRD table consists of various fields, each holding specific information or linking keys about Default values for collective confirmation data available in SAP. These include AUTYP (Order category), UNAME (User Name), RUECK (Completion confirmation number for the operation), BUDAT (Posting date).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AFRD 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
MANDTClient MANDTCLNT3T000MANDT
AUTYPOrder category AUFTYPNUMC2AUFTYP
UNAMEUser Name UNAMECHAR12UNAME
RUECKCompletion confirmation number for the operation CO_RUECKNUMC10CO_RUECKRCK
BUDATPosting date BUCHDATUMDATS8DATUM
ARBIDObject ID OBJEKTIDNUMC8NUM08PON
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LTXA1Confirmation text CO_RTEXTCHAR40TEXT40
ISERHConfirmed break time ISERHQUAN9(3) VGWRT
ZEIERUnit for the break time DZEIERUNIT3T006CUNITMEINS
ILE01Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM01Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ILE02Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM02Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ILE03Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM03Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ILE04Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM04Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ILE05Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM05Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ILE06Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3T006CUNITMEINS
ISM06Activity Currently to be Confirmed RU_ISMNGQUAN13(3) MENGV13
ABARBConfirmation: Degree of processing CO_ABARBNUMC3CO_ABARB
ISMNWActual work ISMNWQUAN7(1) ARBEIT
ISMNEUnit for work ARBEITEUNIT3T006CUNITMEINS
LEARRActivity Type for Confirmation LEARRCHAR6CSLALSTAR
IDAURActual Duration for Confirmation IDAURQUAN5(1) DAUER_4_1
IDAUEUnit for actual duration IDAUREUNIT3T006CUNITMEINS
ZCODEReference number for standard value code DZCODECHAR6ZCODE
LOARTWage Type LOHNARTCHAR4LOART
QUALFSuitability QUALFCHAR2T423QUALF
ANZMANumber of employees ANZMSDEC5(2) ANZMA
LOGRPWage group LOHNGRPCHAR3T421LOHNGRP
GMNGAPreviously confirmed yield in order unit of measure RU_GMNGAQUAN13(3) MENG13
LMNGAYield to Be Confirmed RU_LMNGAQUAN13(3) MENGV13
XMNGAScrap to Be Confirmed RU_XMNGAQUAN13(3) MENGV13
GMEINBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MEINHConfirmation unit of measure RU_VORMEUNIT3T006CUNITMEINS
GRUNDReason for Variance CO_AGRNDCHAR4TRUGCO_AGRND
PERNRPersonnel number CO_PERNRNUMC8PERNRPER
ISDDConfirmed date for start of execution RU_ISDDDATS8DATUM
ISDZConfirmed time for 'Execution start' RU_ISDZTIMS6ATIME
IERDConfirmed date for 'Setup finish' RU_IERDDATS8DATUM
IERZConfirmed time for 'Setup finish' RU_IERZTIMS6ATIME
ISBDConfirmed date for 'Processing start' RU_ISBDDATS8DATUM
ISBZConfirmed time for 'Processing start' RU_ISBZTIMS6ATIME
IEBDConfirmed date for 'processing finish' RU_IEBDDATS8DATUM
IEBZConfirmed time for 'processing finish' RU_IEBZTIMS6ATIME
ISADConfirmed date for 'teardown start' RU_ISADDATS8DATUM
ISAZConfirmed time for 'teardown start' RU_ISAZTIMS6ATIME
IEDDConfirmed date for execution finish RU_IEDDDATS8DATUMEDR
IEDZConfirmed time for 'Execution finish' RU_IEDZTIMS6ATIMEEZR
PEDDForecast finish date of operation from confirmation CO_PEDDDATS8DATUM
PEDZForecast finish time of operation from confirmation CO_PEDZTIMS6ATIME
AUERUActivation of Final Confirmation AUERUCHAR1AUERU_VS
AUSORClear Open Reservations AUSBUCHAR1XFELD
STNDRIndicator: Standard confirmation STNDRCHAR1XFELD
MANURIndicator for type of confirmation MANURCHAR1MANUR
MEILRIndicator: Milestone confirmation carried out MEILRCHAR1MEILR
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
APLFLSequence PLNFOLGECHAR6ALPHAPLNFOLGE
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
OFM01Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE01Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK01Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFM02Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE02Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK02Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFM03Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE03Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK03Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFM04Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE04Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK04Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFM05Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE05Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK05Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFM06Forecast value used to update the standard value CO_SCHAETZQUAN9(3) VGWRT
OFE06Unit of measure for the standard value VGWRTEHUNIT3T006CUNITMEINS
LEK06Indicator: No remaining activity expected CO_LEIKZCHAR1XFELD
OFMNWRemaining work REMNWQUAN7(1) ARBEIT
OFMNEUnit of measure for remaining work OFMNEUNIT3T006CUNITMEINS
LEKNWIndicator: No Remaining Work Expected LEKNWCHAR1XFELD
ODAURRemaining duration of activity ODAURQUAN5(1) DAUER_4_1
ODAUEUnit for remaining duration ODAUEUNIT3T006CUNITMEINS
SMENGOperation Quantity MGVRGQUAN13(3) MENG13
SPLITSplit number CY_SPLITINT13INT1
ZAUSWTime Recording ID Number DZAUSWNUMC8ZAUSW
KAPARCapacity category KAPARTCHAR3TC26KAPARTCAA
UVORNSuboperation UVORNCHAR4NUMCVVORNR
CATSBELNRDocument Number CATSBELNRCHAR10ALPHABELNR
CATSPRICEPrice in Transaction Currency CATSPRICECURR11(2) WERTV6
CATSTCURRTransaction Currency TWAERCUKY5Assigned to domainWAERSFWS
CATSPEINHPrice Unit PEINHDEC5PACK3
RMNGACurrent rework quantity to be confirmed RU_RMNGAQUAN13(3) MENGV13
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
PRZ01Business Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
IPRZ1Current quantity to be confirmed for the business process RU_IPRZSQUAN13(3) MENGV13
IPRE1Unit of measurement for conf. quantity for business process RU_IPRZEUNIT3Assigned to domainCUNITMEINS
IPRK1No remaining quantity expected for business process RU_IPRZKCHAR1XFELD
OPRZ1Remaining quantity for business process OPRZ1QUAN13(3) MENGV13
OPRE1Unit for remaining quantity of business process OPRE1UNIT3Assigned to domainCUNITMEINS
SCRIDID for collective entry input list RU_SCRIDCHAR1RU_SCRID
NODATDo not update actual date in the operation NODATCHAR1XFELD
ISMNW_2Actual Work ISMNW_2QUAN8(2) ARBEIT_2
OFMNW_2Remaining Work REMNW_2QUAN8(2) ARBEIT_2
ISMNUUnit for work ARBEITEUNIT3T006CUNITMEINS
OFMNUUnit for work ARBEITEUNIT3T006CUNITMEINS
PACKNOPackage number PACKNONUMC10Assigned to domainPACKNO

Key field Non-key field



How do I retrieve data from SAP table AFRD using ABAP code

The following ABAP code Example will allow you to do a basic selection on AFRD to SELECT all data from the table
DATA: WA_AFRD TYPE AFRD.

SELECT SINGLE *
FROM AFRD
INTO CORRESPONDING FIELDS OF WA_AFRD
WHERE...

How to access SAP table AFRD

Within an ECC or HANA version of SAP you can also view further information about AFRD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!