1. Home
  2. Resources
  3. SAP Tables
  4. IOCSEL - Filter/selection criteria for order reporting

SAP Table IOCSEL

Filter/selection criteria for order reporting

IOCSEL (Filter/selection criteria for order reporting) 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 IOCSEL to other SAP tables.

IOCSEL table fields

Field Data element Checktable Datatype Length Decimals
ECKST No. of days from today's date CO_DAT_REL QUAN 5 0
ECKEN No. of days from today's date CO_DAT_REL QUAN 5 0
TERST No. of days from today's date CO_DAT_REL QUAN 5 0
TEREN No. of days from today's date CO_DAT_REL QUAN 5 0
TERFR No. of days from today's date CO_DAT_REL QUAN 5 0
ISTST No. of days from today's date CO_DAT_REL QUAN 5 0
ISTEN No. of days from today's date CO_DAT_REL QUAN 5 0
ISTFR No. of days from today's date CO_DAT_REL QUAN 5 0
PERTR No. of days from today's date CO_DAT_REL QUAN 5 0
ZEINH Time unit MAIZE UNIT 3 0
EINHEIT Unit of measure MEINA UNIT 3 0
FLG_REWORK Display complete rework FLG_REWORK CHAR 1 0
X Yes
NULL No
FLG_MSTUF Display complete collective order FLG_MSTUF CHAR 1 0
X Yes
NULL No
FLG_LOEKZ Display deleted orders FLG_LOEKZ CHAR 1 0
X Yes
NULL No
SEL_TYP Production/Process/Planned Order SEL_TYP CHAR 1 0
NULL Only Production/Process Orders
1 Planned, Production and Process Orders
2 Only Planned Orders
AV_CLEAR Reset Availability Data AV_CLEAR CHAR 1 0
NULL Do not set flag
X Set flag
AV_CHECK Execute availability check AV_CHECK CHAR 1 0
NULL Do not set flag
X Set flag
AV_CHECK_DEF Execute availability check (session) AV_CHECK_O CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AV_CHECK_ATP Execute availability check (session) AV_CHECK_O CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AV_CHECK_VPL Execute availability check (session) AV_CHECK_O CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AV_FIX_PL Firm planned orders AV_FIX_PL CHAR 1 0
NULL Do not set flag
X Set flag
AV_NO_MONT Do not select any assembly orders AV_NO_MONT CHAR 1 0
NULL Do not set flag
X Set flag
AV_KAPFX Only select capacity planned orders AV_KAPFX CHAR 1 0
NULL Dispatched and not yet dispatched orders
1 Only dispatched orders
2 Only orders not yet dispatched
ORDNUM Maximum Number of Orders CO_ORDNUM INT4 10 0
FLG_NO_ALT_SEQ General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
FLG_NO_REL Do Not Display Released Orders FLG_NO_REL CHAR 1 0
X Yes
NULL No
FLG_COIS_FILTER Reduced Reading FLG_COIS_FILTER CHAR 1 0
X Yes
NULL No
FLG_COIS_PRESUC Indicator: Read Predecessor/Successor Information FLG_COIS_PRESUC CHAR 1 0
X Yes
NULL No
FLG_COIS_PRETAB Indicator: Return Predecessor/Successor Table FLG_COIS_PRETAB CHAR 1 0
X Yes
NULL No
FLG_COIS_AUFFX Selection of firmed planned orders FLG_AUFFX_S CHAR 1 0
X Yes
NULL No
FLG_COIS_FULLAV Availability checked, fully confirmed COD_FULL_COMMIT CHAR 1 0
X Yes
NULL No
FLG_COIS_PARTAV Indicator: Availability checked, partly confirmed COD_PART_COMMIT CHAR 1 0
X Yes
NULL No
FLG_COIS_NOCONF Indicator: Availability checked, not confirmed COD_NO_COMMIT CHAR 1 0
X Yes
NULL No
FLG_COIS_NCHECK Availability not checked COD_NO_CHECK_AVAIL CHAR 1 0
X Yes
NULL No
FIXOF Firm planned order: days difference from planning time fence FIXOF INT4 10 0
TIME_FENCE Take Planning Time Fence Into Account FLG_COIS_TIME_FENCE CHAR 1 0
X Yes
NULL No
FTS_FLG_FUZZY Fuzzy Search COIS_FLG_FTS_FUZZY CHAR 1 0
X Yes
NULL No
FTS_KEYWORDS Keywords for Full Text Search COIS_FTS_KEYWORDS CHAR 45 0
FLG_WIPB_DEVIATION Indicator: Display Orders with Different WIP Batches Only CO_FLG_WIPBDEV CHAR 1 0
X Yes
NULL No