1. Home
  2. Resources
  3. SAP Tables
  4. AFRD - Default values for collective confirmation

SAP Table AFRD

Default values for collective confirmation

AFRD (Default values for collective confirmation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFRD to other SAP tables.

Source: AFRD (Default values for collective confirmation)

AFRD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUTYP Order category AUFTYP NUMC 2 0
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
UNAME User Name UNAME CHAR 12 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
BUDAT Posting date BUCHDATUM DATS 8 0
ARBID Object ID OBJEKTID NUMC 8 0
WERKS Plant WERKS_D T001W CHAR 4 0
LTXA1 Confirmation text CO_RTEXT CHAR 40 0
ISERH Confirmed break time ISERH QUAN 9 3
ZEIER Unit for the break time DZEIER T006 UNIT 3 0
ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM01 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM02 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM03 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM04 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM05 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH T006 UNIT 3 0
ISM06 Activity Currently to be Confirmed RU_ISMNG QUAN 13 3
ABARB Confirmation: Degree of processing CO_ABARB NUMC 3 0
ISMNW Actual work ISMNW QUAN 7 1
ISMNE Unit for work ARBEITE T006 UNIT 3 0
LEARR Activity Type for Confirmation LEARR CSLA CHAR 6 0
IDAUR Actual Duration for Confirmation IDAUR QUAN 5 1
IDAUE Unit for actual duration IDAURE T006 UNIT 3 0
ZCODE Reference number for standard value code DZCODE CHAR 6 0
LOART Wage Type LOHNART CHAR 4 0
QUALF Suitability QUALF T423 CHAR 2 0
ANZMA Number of employees ANZMS DEC 5 2
LOGRP Wage group LOHNGRP T421 CHAR 3 0
GMNGA Previously confirmed yield in order unit of measure RU_GMNGA QUAN 13 3
LMNGA Yield to Be Confirmed RU_LMNGA QUAN 13 3
XMNGA Scrap to Be Confirmed RU_XMNGA QUAN 13 3
GMEIN Base Unit of Measure MEINS T006 UNIT 3 0
MEINH Confirmation unit of measure RU_VORME T006 UNIT 3 0
GRUND Reason for Variance CO_AGRND TRUG CHAR 4 0
PERNR Personnel number CO_PERNR NUMC 8 0
ISDD Confirmed date for start of execution RU_ISDD DATS 8 0
ISDZ Confirmed time for 'Execution start' RU_ISDZ TIMS 6 0
IERD Confirmed date for 'Setup finish' RU_IERD DATS 8 0
IERZ Confirmed time for 'Setup finish' RU_IERZ TIMS 6 0
ISBD Confirmed date for 'Processing start' RU_ISBD DATS 8 0
ISBZ Confirmed time for 'Processing start' RU_ISBZ TIMS 6 0
IEBD Confirmed date for 'processing finish' RU_IEBD DATS 8 0
IEBZ Confirmed time for 'processing finish' RU_IEBZ TIMS 6 0
ISAD Confirmed date for 'teardown start' RU_ISAD DATS 8 0
ISAZ Confirmed time for 'teardown start' RU_ISAZ TIMS 6 0
IEDD Confirmed date for execution finish RU_IEDD DATS 8 0
IEDZ Confirmed time for 'Execution finish' RU_IEDZ TIMS 6 0
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
PEDZ Forecast finish time of operation from confirmation CO_PEDZ TIMS 6 0
AUERU Activation of Final Confirmation AUERU CHAR 1 0
NULL Partial confirmation
X Final confirmation
1 Automatic final confirmation
AUSOR Clear Open Reservations AUSBU CHAR 1 0
X Yes
NULL No
STNDR Indicator: Standard confirmation STNDR CHAR 1 0
X Yes
NULL No
MANUR Indicator for type of confirmation MANUR CHAR 1 0
1 Confirmation was entered manually
2 Automatic confirmation due to milestone confirmation
3 Automatic conf. due to sub-operation degree of processing
4 Autom.confirmation from cumulative confirmation
MEILR Indicator: Milestone confirmation carried out MEILR CHAR 1 0
X Milestone
D Dynamic milestone
NULL No
AUFNR Order Number AUFNR AUFK CHAR 12 0
APLFL Sequence PLNFOLGE CHAR 6 0
VORNR Operation/Activity Number VORNR CHAR 4 0
OFM01 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE01 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK01 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM02 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE02 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK02 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM03 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE03 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK03 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM04 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE04 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK04 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM05 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE05 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK05 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFM06 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFE06 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
LEK06 Indicator: No remaining activity expected CO_LEIKZ CHAR 1 0
X Yes
NULL No
OFMNW Remaining work REMNW QUAN 7 1
OFMNE Unit of measure for remaining work OFMNE T006 UNIT 3 0
LEKNW Indicator: No Remaining Work Expected LEKNW CHAR 1 0
X Yes
NULL No
ODAUR Remaining duration of activity ODAUR QUAN 5 1
ODAUE Unit for remaining duration ODAUE T006 UNIT 3 0
SMENG Operation Quantity MGVRG QUAN 13 3
SPLIT Split number CY_SPLIT INT1 3 0
ZAUSW Time Recording ID Number DZAUSW NUMC 8 0
KAPAR Capacity category KAPART TC26 CHAR 3 0
UVORN Suboperation UVORN CHAR 4 0
CATSBELNR Document Number CATSBELNR CHAR 10 0
CATSPRICE Price in Transaction Currency CATSPRICE CURR 11 2
CATSTCURR Transaction Currency TWAER CUKY 5 0
CATSPEINH Price Unit PEINH DEC 5 0
RMNGA Current rework quantity to be confirmed RU_RMNGA QUAN 13 3
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
PRZ01 Business Process CO_PRZNR CHAR 12 0
IPRZ1 Current quantity to be confirmed for the business process RU_IPRZS QUAN 13 3
IPRE1 Unit of measurement for conf. quantity for business process RU_IPRZE UNIT 3 0
IPRK1 No remaining quantity expected for business process RU_IPRZK CHAR 1 0
X Yes
NULL No
OPRZ1 Remaining quantity for business process OPRZ1 QUAN 13 3
OPRE1 Unit for remaining quantity of business process OPRE1 UNIT 3 0
SCRID ID for collective entry input list RU_SCRID CHAR 1 0
1 Confirmation number as fixed column
2 Order/sequence/operation as fixed column
NODAT Do not update actual date in the operation NODAT CHAR 1 0
X Yes
NULL No
ISMNW_2 Actual Work ISMNW_2 QUAN 8 2
OFMNW_2 Remaining Work REMNW_2 QUAN 8 2
ISMNU Unit for work ARBEITE T006 UNIT 3 0
OFMNU Unit for work ARBEITE T006 UNIT 3 0
PACKNO Package number PACKNO NUMC 10 0

AFRD foreign key relationships

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