SAP table AFRD (Default values for collective confirmation)

SAP table AFRD has 3 primary key fields being MANDT,AUTYP,UNAME.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
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
UNAME User Name CHAR 12 0 UNAME
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
BUDAT Posting Date DATS 8 0 BUCHDATUM
ARBID Object ID NUMC 8 0 OBJEKTID
WERKS Plant CHAR 4 0 T001W WERKS_D
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 T006 DZEIER
ILE01 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM01 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ILE02 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM02 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ILE03 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM03 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ILE04 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM04 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ILE05 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM05 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ILE06 Unit of measure for the activity to be confirmed UNIT 3 0 T006 CO_ISMNGEH
ISM06 Activity Currently to be Confirmed QUAN 13 3 RU_ISMNG
ABARB Confirmation: Degree of processing NUMC 3 0 CO_ABARB
ISMNW Actual work QUAN 7 1 ISMNW
ISMNE Unit for work UNIT 3 0 T006 ARBEITE
LEARR Activity Type for Confirmation CHAR 6 0 CSLA LEARR
IDAUR Actual Duration for Confirmation QUAN 5 1 IDAUR
IDAUE Unit for actual duration UNIT 3 0 T006 IDAURE
ZCODE Reference number for standard value code CHAR 6 0 DZCODE
LOART Wage type CHAR 4 0 LOHNART
QUALF Suitability CHAR 2 0 T423 QUALF
ANZMA Number of employees DEC 5 2 ANZMS
LOGRP Wage Group CHAR 3 0 T421 LOHNGRP
GMNGA Confirmed yield quantity in order unit of measure QUAN 13 3 RU_GMNGA
LMNGA Yield to be Confirmed QUAN 13 3 RU_LMNGA
XMNGA Scrap to Be Confirmed QUAN 13 3 RU_XMNGA
GMEIN Base Unit of Measure UNIT 3 0 T006 MEINS
MEINH Confirmation Unit of Measure UNIT 3 0 T006 RU_VORME
GRUND Reason for Variance CHAR 4 0 TRUG CO_AGRND
PERNR Personnel number NUMC 8 0 CO_PERNR
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 AUSBU
STNDR Indicator: Standard confirmation CHAR 1 0 STNDR
MANUR Indicator for Type of Confirmation CHAR 1 0 MANUR
1 Confirmation was Entered Manually
2 Automatic Confirmation due to Milestone Confirmation
3 Automatic Conf. due to Sub-Operation Degree of Processing
4 Automatic Confirmation from Cumulative Confirmation
MEILR Indicator: Milestone Confirmation Carried Out CHAR 1 0 MEILR
No
D Dynamic milestone
X Milestone
AUFNR Order Number CHAR 12 0 AUFK AUFNR
APLFL Sequence CHAR 6 0 PLNFOLGE
VORNR Operation/Activity Number CHAR 4 0 VORNR
OFM01 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE01 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK01 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFM02 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE02 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK02 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFM03 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE03 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK03 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFM04 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE04 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK04 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFM05 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE05 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK05 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFM06 Forecast Value for Updating of Standard Value QUAN 9 3 CO_SCHAETZ
OFE06 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
LEK06 Indicator: No Remaining Activity Expected CHAR 1 0 CO_LEIKZ
OFMNW Remaining work QUAN 7 1 REMNW
OFMNE Unit of Measure for Remaining Work UNIT 3 0 T006 OFMNE
LEKNW Indicator: No Remaining Work Expected CHAR 1 0 LEKNW
ODAUR Remaining duration of activity QUAN 5 1 ODAUR
ODAUE Unit for remaining duration UNIT 3 0 T006 ODAUE
SMENG Operation Total Quantity QUAN 13 3 MGVRG
SPLIT Split number INT1 3 0 CY_SPLIT
ZAUSW Time Recording ID Number NUMC 8 0 DZAUSW
KAPAR Capacity category CHAR 3 0 TC26 KAPART
UVORN Suboperation CHAR 4 0 UVORN
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
RMNGA Current Confirmation Rework Quantity QUAN 13 3 RU_RMNGA
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
SCRID ID for collective entry input list CHAR 1 0 RU_SCRID
1 Confirmation number as fixed column
2 Order/sequence/operation as fixed column
NODAT Do not update actual date in the operation CHAR 1 0 NODAT
ISMNW_2 Actual Work QUAN 8 2 ISMNW_2
OFMNW_2 Remaining Work QUAN 8 2 REMNW_2
ISMNU Unit for work UNIT 3 0 T006 ARBEITE
OFMNU Unit for work UNIT 3 0 T006 ARBEITE
PACKNO Package number NUMC 10 0 * PACKNO

AFRD foreign key relationships

Table Field Check Table Check Field
0 AFRD AUFNR AUFK Order master data AUFNR
1 AFRD BEMOT TBMOT Accounting indicators MANDT
1 AFRD BEMOT TBMOT Accounting indicators BEMOT
0 AFRD GMEIN T006 Units of Measurement MANDT
0 AFRD GMEIN T006 Units of Measurement MSEHI
1 AFRD GRUND TRUG Reason for variances in completion confirmations MANDT
1 AFRD GRUND TRUG Reason for variances in completion confirmations WERKS
0 AFRD IDAUE T006 Units of Measurement MANDT
1 AFRD ILE01 T006 Units of Measurement MANDT
0 AFRD ILE02 T006 Units of Measurement MANDT
1 AFRD ILE03 T006 Units of Measurement MANDT
0 AFRD ILE04 T006 Units of Measurement MANDT
1 AFRD ILE05 T006 Units of Measurement MANDT
0 AFRD ILE06 T006 Units of Measurement MANDT
1 AFRD ISMNE T006 Units of Measurement MANDT
1 AFRD ISMNE T006 Units of Measurement MSEHI
0 AFRD ISMNU T006 Units of Measurement MANDT
0 AFRD ISMNU T006 Units of Measurement MSEHI
1 AFRD KAPAR TC26 Capacity category MANDT
0 AFRD LEARR CSLA Activity master MANDT
0 AFRD LEARR CSLA Activity master KOKRS
0 AFRD LEARR CSLA Activity master DATBI
1 AFRD LOGRP T421 Wage groups MANDT
0 AFRD MANDT T000 Clients MANDT
1 AFRD MEINH T006 Units of Measurement MANDT
1 AFRD MEINH T006 Units of Measurement MSEHI
0 AFRD ODAUE T006 Units of Measurement MANDT
1 AFRD OFE01 T006 Units of Measurement MANDT
1 AFRD OFE01 T006 Units of Measurement MSEHI
0 AFRD OFE02 T006 Units of Measurement MANDT
0 AFRD OFE02 T006 Units of Measurement MSEHI
1 AFRD OFE03 T006 Units of Measurement MANDT
1 AFRD OFE03 T006 Units of Measurement MSEHI
0 AFRD OFE04 T006 Units of Measurement MANDT
0 AFRD OFE04 T006 Units of Measurement MSEHI
1 AFRD OFE05 T006 Units of Measurement MANDT
1 AFRD OFE05 T006 Units of Measurement MSEHI
0 AFRD OFE06 T006 Units of Measurement MANDT
0 AFRD OFE06 T006 Units of Measurement MSEHI
1 AFRD OFMNE T006 Units of Measurement MANDT
1 AFRD OFMNE T006 Units of Measurement MSEHI
0 AFRD OFMNU T006 Units of Measurement MANDT
0 AFRD OFMNU T006 Units of Measurement MSEHI
1 AFRD QUALF T423 Wage group qualification MANDT
1 AFRD QUALF T423 Wage group qualification QUALF
0 AFRD WERKS T001W Plants/Branches MANDT
0 AFRD WERKS T001W Plants/Branches WERKS
1 AFRD ZEIER T006 Units of Measurement MANDT