1. Home
  2. Resources
  3. SAP Tables
  4. IQIFIELD - InfoSet Query API: Field Description in InfoSet

SAP Table IQIFIELD

InfoSet Query API: Field Description in InfoSet

IQIFIELD (InfoSet Query API: Field Description in InfoSet) 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 IQIFIELD to other SAP tables.

IQIFIELD table fields

Field Data element Checktable Datatype Length Decimals
TAB Table Name TABNAME CHAR 30 0
FIELD Field Name FIELDNAME CHAR 30 0
FTYPE InfoSet Query: Field Type IQFTYPE CHAR 4 0
DSRC Data source field
ATAB Field for an additional table
AFLD Additional field
ASTR Field for an additional structure
FGROUP InfoSet Query: Field Group IQFGROUP CHAR 2 0
FTEXT InfoSet Query: Long Text for Objects IQOTXT CHAR 60 0
LIKETAB Table Name TABNAME CHAR 30 0
LIKEFIELD Field Name FIELDNAME CHAR 30 0
ROLLNAME Data element (semantic domain) ROLLNAME CHAR 30 0
DOMNAME Domain name DOMNAME CHAR 30 0
LENG Length (No. of Characters) DDLENG NUMC 6 0
INTLEN Internal Length in Bytes INTLEN NUMC 6 0
DECIMALS Number of Decimal Places DECIMALS NUMC 6 0
DATATYPE ABAP/4 Dictionary: Screen data type for Screen Painter DYNPTYPE CHAR 4 0
ACCP Posting period YYYYMM
CHAR Character String
CLNT Client
CUKY Currency key, referenced by CURR fields
CURR Currency field, stored as DEC
D16D Decimal Floating Point, 16 Digits, DEC on Database
D16R Decimal Floating Point, 16 Digits, RAW on Database
D16S Decimal Floating Point. 16 Digits, with Scale Field
D34D Decimal Floating Point, 34 Digits, DEC on Database
D34R Decimal Floating Point, 34 Digits, RAW on Database
D34S Decimal Floating Point, 34 Digits, with Scale Field
DATS Date field (YYYYMMDD) stored as char(8)
DEC Counter or amount field with comma and sign
FLTP Floating point number, accurate to 8 bytes
INT1 1-byte integer, integer number <= 255
INT2 2-byte integer, only for length field before LCHR or LRAW
INT4 4-byte integer, integer number with sign
LANG Language key
LCHR Long character string, requires preceding INT2 field
LRAW Long byte string, requires preceding INT2 field
NUMC Character string with only digits
PREC Obsolete data type, do not use
QUAN Quantity field, points to a unit field with format UNIT
RAW Uninterpreted sequence of bytes
RSTR Byte String of Variable Length
SSTR Short Character String of Variable Length
STRG Character String of Variable Length
TIMS Time field (hhmmss), stored as char(6)
UNIT Unit key for QUAN fields
VARC Long character string, no longer supported from Rel. 3.0
INTTYPE ABAP data type (C,D,N,...) INTTYPE CHAR 1 0
C Character String
N Character String with Digits Only
D Date (Date: YYYYMMDD)
T Time (Time: HHMMSS)
X Byte Seq. (heXadecimal), in DDIC metadata also for INT1/2/4
I Integer number (4-byte integer with sign)
b 1-byte integer, integer number <= 254
s 2-byte integer, only for length field before LCHR or LRAW
P Packed number
F Floating point number to accuracy of 8 bytes
g Character string with variable length (ABAP type STRING)
y Byte sequence with variable length (ABAP type XSTRING)
u Structured type, flat
v Structured type, deep
h Table type
V Character string (old Dictionary type VARC)
r Reference to class/interface
l Reference to data object
a Decimal Floating Point Number, 16 Digits
e Decimal Floating Point Number, 34 Digits
j Static Boxed Components
k Generic Boxed Components
REFTABLE Table for reference field REFTABLE CHAR 30 0
REFFIELD Reference field for currency and qty fields REFFIELD CHAR 30 0
MEMORYID Set/Get parameter ID MEMORYID CHAR 20 0
TEXTFIELD InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
OUTPUTLEN Output Length OUTPUTLEN NUMC 6 0
ROUND InfoSet Query: Rounding Factor IQROUND CHAR 4 0
HEADLEN Maximum length of heading HEADLEN NUMC 2 0
SCRLEN1 Max. length for short field label SCRLEN_S NUMC 2 0
SCRLEN2 Max. length for medium field label SCRLEN_M NUMC 2 0
SCRLEN3 Max. length for long field label SCRLEN_L NUMC 2 0
FIELDTEXT Short Description of Repository Objects AS4TEXT CHAR 60 0
REPTEXT Heading REPTEXT CHAR 55 0
SCRTEXT_S Short Field Label SCRTEXT_S CHAR 10 0
SCRTEXT_M Medium Field Label SCRTEXT_M CHAR 20 0
SCRTEXT_L Long Field Label SCRTEXT_L CHAR 40 0
NOSUMM InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
CURRYPOS InfoSet Query API: Postion of the currency/unit IQCURRPOS CHAR 6 0
AFTER Display Currency after Field
NO No Currency Display
BEFORE Display Currency Before Field
SELOPT InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
SELNAME ABAP/4: Name of SELECT-OPTION / PARAMETER RSSCR_NAME CHAR 8 0
NOINTERVAL InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
NOEXTENS InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
OBLIGATORY InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
NODISPLAY InfoSet Query: Boolean Value IQBOOL CHAR 1 0
X True
NULL False
ORDERNR InfoSet Query: Sequence Number IQORDER NUMC 6 0
SELTEXT InfoSet Query: Long Text for Objects IQOTXT CHAR 60 0