1. Home
  2. Resources
  3. SAP Tables
  4. RS38Q - SAP Query: Screen Fields for Transactions SQ02 and SQ09

SAP Table RS38Q

SAP Query: Screen Fields for Transactions SQ02 and SQ09

RS38Q (SAP Query: Screen Fields for Transactions SQ02 and SQ09) 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 RS38Q to other SAP tables.

RS38Q table fields

Field Data element Checktable Datatype Length Decimals
NAME SAP Query: InfoSet AQ_SGNAME CHAR 24 0
MARK SAP Query: Checkbox AQ_MARK CHAR 1 0
ZIELNAME SAP Query: Target InfoSet AQ_SGNAME1 CHAR 24 0
ORGNAME SAP Query: Source InfoSet AQ_SGNAME2 CHAR 24 0
LOGDB SAP Query: Name of a logical database AQ_LOGDB CHAR 20 0
RLOGDB SAP Query: Data retrieval using log. database AQ_RLDB CHAR 1 0
SGTEXT SAP Query: InfoSet text AQ_SGTEXT CHAR 63 0
DDNAME SAP Query: Tables AQ_TAB CHAR 30 0
RFILE SAP Query: Data retrieval by program AQ_RFILE CHAR 1 0
SEQU SAP Query: Read sequential dataset AQ_RSEQU CHAR 1 0
SEQDDNAME SAP Query: Tables AQ_TAB CHAR 30 0
RPROGINT SAP Query: Data retrieval by program AQ_RFILE CHAR 1 0
RPROGEXT SAP Query: Data retrieval by program AQ_RFILE CHAR 1 0
PROG SAP Query: Report name AQ_REPORT CHAR 30 0
FILDDNAME SAP Query: Tables AQ_TAB CHAR 30 0
DIRECT SAP Query: Direct table read AQ_DIRECT CHAR 1 0
TJOIN SAP Query: Table join AQ_JOIN CHAR 1 0
JOINDDNAME SAP Query: Tables AQ_TAB CHAR 30 0
SECU SAP Query: Authorization group for starting queries AQ_SECU CHAR 8 0
DBSAINDEX SAP Query: No./index of fields (internal type P) AQ_NUMBERP DEC 5 0
DBSAMAX SAP Query: Number/index of fields (internal type C) AQ_NUMBERC NUMC 8 0
DBSGINDEX SAP Query: Number/index of fields (internal type C) AQ_NUMBERC NUMC 8 0
DBSGMAX SAP Query: No./index of fields (internal type P) AQ_NUMBERP DEC 5 0
SEGNAME SAP Query: Table name AQ_SEGNAME CHAR 30 0
SEGTEXT SAP Query: Logical database table text AQ_SEGTXT2 CHAR 40 0
DBFINAME SAP Query: Field name AQ_FINAME CHAR 70 0
DBFITEXT SAP Query: Field text AQ_FITEXT CHAR 60 0
DBFITEXTS SAP Query: Field text AQ_FITEXT CHAR 60 0
DBFISGNA SAP Query: Logical database table AQ_SEG CHAR 30 0
DBFIINDEX SAP Query: No./index of fields (internal type P) AQ_NUMBERP DEC 5 0
DBFIMAX SAP Query: No./index of fields (internal type P) AQ_NUMBERP DEC 5 0
DBSANUMB SAP Query: Field group AQ_SANAME CHAR 2 0
DBSANAME SAP Query: Functional group text AQ_SATEXT CHAR 80 0
DBSFNUMB SAP Query: Field assignment to field group AQ_SANAMEF CHAR 2 0
DSNNAME SAP Query: Sequential dataset AQ_SEQU CHAR 60 0
SC1 SAP Query: Text line AQ_DYLINE CHAR 132 0
SC2 SAP Query: Text line AQ_DYLINE CHAR 132 0
SCTEXT SAP Query: Error info with syntax errors AQ_SCLINE CHAR 6 0
SCLINE SAP Query: Error info with syntax errors AQ_SCLINE CHAR 6 0
DBZTNAME SAP Query: Tables AQ_TAB CHAR 30 0
IBUFF SAP Query: Checkbox AQ_MARK CHAR 1 0
A01 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F01 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A02 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F02 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A03 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F03 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A04 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F04 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A05 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F05 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A06 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F06 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A07 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F07 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A08 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F08 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A09 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F09 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
A10 SAP Query: SAP table argument AQ_TABARG CHAR 70 0
F10 SAP Query: Condition for SAP table argument AQ_TABBED CHAR 70 0
DBZFSGNA SAP Query: Logical database table AQ_SEG CHAR 30 0
DBZFNAME SAP Query: Additional field AQ_ZFNAME CHAR 21 0
DBZFTEXT SAP Query: Text AQ_ZFTEXT CHAR 60 0
DBZFTYPE SAP Query: Internal ABAP type AQ_TYP CHAR 1 0
DBZFLENG SAP Query: Field length AQ_LENG CHAR 3 0
DBZFOLENG SAP Query: Output length AQ_OLENG CHAR 3 0
DBZFDECIMA SAP Query: Decimal places in field output AQ_DEC CHAR 2 0
DBZFORDER SAP Query: Sequence of code AQ_ORDER NUMC 2 0
DBZFCODE SAP Query: Checkbox AQ_MARK CHAR 1 0
DBZFCHKTXT SAP Query: Checkbox AQ_MARK CHAR 1 0
DBZFHEADL SAP Query: Header text AQ_HEAD30 CHAR 30 0
DBZFHEAD1 SAP Query: Header text AQ_HEAD30 CHAR 30 0
DBZFHEAD2 SAP Query: Header text AQ_HEAD30 CHAR 30 0
DBZFHEAD1S SAP Query: Header text AQ_HEAD30 CHAR 30 0
DBZFHEAD2S SAP Query: Header text AQ_HEAD30 CHAR 30 0
DBZFHEAD1T SAP Query: Field text AQ_FITEXT CHAR 60 0
PARHEAD1 SAP Query: Program selection text AQ_PARHEAD CHAR 30 0
DBZFLIKE SAP Query: Reference field AQ_LIKE CHAR 70 0
I00 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I01 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I02 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I03 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I04 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I05 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I06 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I07 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I08 SAP Query: ABAP code line AQ_CODE CHAR 72 0
I09 SAP Query: ABAP code line AQ_CODE CHAR 72 0
DBPANAME SAP Query: Program Selection (Parameter/Selection Criteria) AQ_PARAM CHAR 8 0
PARORDER SAP Query: Standard selection screen sequence AQ_PORDER NUMC 2 0
DBPAPAR SAP Query: Checkbox AQ_MARK CHAR 1 0
DBPASEL SAP Query: Checkbox AQ_MARK CHAR 1 0
DBPASTD SAP Query: Checkbox AQ_MARK CHAR 1 0
DBPANODISP SAP Query: Checkbox AQ_MARK CHAR 1 0
DBPADISP SAP Query: Checkbox AQ_MARK CHAR 1 0
DBPAOBLIG SAP Query: Checkbox AQ_MARK CHAR 1 0
CNAM SAP Query: Author AQ_CNAM CHAR 12 0
CDAT SAP Query: Creation date AQ_CDAT DATS 8 0
UNAM SAP Query: Last changed by AQ_UNAM CHAR 12 0
UDAT SAP Query: Date of last change AQ_UDAT DATS 8 0
FIXPOINT SAP Query: Checkbox AQ_MARK CHAR 1 0
MARKBG SAP Query: Checkbox AQ_MARK CHAR 1 0
BGNUM SAP Query: User group AQ_BGNAME CHAR 12 0
BGTEXT SAP Query: User group text AQ_BGTEXT CHAR 30 0
SEARCH SAP Query: Search criterion AQ_SEARCH CHAR 30 0
DOMNAME SAP Query: Domain name AQ_DOM CHAR 30 0
DTYPE Data Type in ABAP Dictionary DATATYPE_D 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
CLENG SAP Query: Number of characters in search AQ_CLENG CHAR 3 0
DECNUMB SAP Query: Number of decimal places in search AQ_DECNUMB CHAR 2 0
SEARCHTEXT SAP Query: Checkbox AQ_MARK CHAR 1 0
SEARCHDOM SAP Query: Checkbox AQ_MARK CHAR 1 0
SEARCHTYPE SAP Query: Checkbox AQ_MARK CHAR 1 0
SEARCHFIR SAP Query: Checkbox AQ_MARK CHAR 1 0
SEARCHLINE SAP Query: Checkbox AQ_MARK CHAR 1 0
SEARCHCUR SAP Query: Checkbox AQ_MARK CHAR 1 0
SELSCREEN SAP Query: Selection screen version AQ_SELVER CHAR 3 0
DBJOTAB SAP Query: Table name AQ_SEGNAME CHAR 30 0
DBJOLOUT SAP Query: Link for table join AQ_OUTER CHAR 1 0
DBJOINN SAP Query: Link for table join AQ_OUTER CHAR 1 0
DBJOROUT SAP Query: Link for table join AQ_OUTER CHAR 1 0
DBJOMARK SAP Query: Checkbox AQ_MARK CHAR 1 0
DBJOLIND SAP Query: Index for table join AQ_JIND CHAR 2 0
DBJOLTAB SAP Query: Table name AQ_SEGNAME CHAR 30 0
DBJOLFELD SAP Query: Database field name or table prefix AQ_TFNAME CHAR 30 0
DBJOLTEXT SAP Query: Field text AQ_FITEXT CHAR 60 0
DBJORIND SAP Query: Index for table join AQ_JIND CHAR 2 0
DBJORTAB SAP Query: Table name AQ_SEGNAME CHAR 30 0
DBJORFELD SAP Query: Database field name or table prefix AQ_TFNAME CHAR 30 0
DBJORTEXT SAP Query: Field text AQ_FITEXT CHAR 60 0
SGNAME1 SAP Query: InfoSet AQ_SGNAME CHAR 24 0
DAT1 SAP Query: Data source of a query AQ_DAT CHAR 35 0
DAT2 SAP Query: Data source of a query AQ_DAT CHAR 35 0
SGTEXT1 SAP Query: InfoSet text AQ_SGTEXT CHAR 63 0
TEXT SAP Query: General text AQ_TEXT CHAR 60 0
ART SAP Query: Type of selection/ Additional information AQ_ART CHAR 20 0
STDSEL SAP Query: Checkbox AQ_MARK CHAR 1 0
ETEXT SAP Query: General text AQ_TEXT CHAR 60 0
ENAME SAP Query: Name of additional table/field/structure AQ_ENAME CHAR 30 0
EARTTAB SAP Query: Checkbox AQ_MARK CHAR 1 0
EARTFELD SAP Query: Checkbox AQ_MARK CHAR 1 0
EARTSTRUC SAP Query: Checkbox AQ_MARK CHAR 1 0
EARTCODE SAP Query: Checkbox AQ_MARK CHAR 1 0
DDICTAB SAP Query: Tables AQ_TAB CHAR 30 0
ALIASTAB SAP Query: Tables AQ_TAB CHAR 30 0
WSTEXT SAP Query: Text for query area AQ_WSTEXT CHAR 50 0
REFFELD SAP Query: Reference field for a field AQ_REFFELD CHAR 30 0
FUNCTION SAP Query (S): Function module name AQS_FUNC CHAR 30 0
XIKEY SAP Query (S): Name of additional function AQS_XIKEY CHAR 30 0
IFTYPE SAP Query (S): Interface type AQS_IFTYPE NUMC 2 0
ACTIV SAP Query: Active function flag in enhanced folders AQS_ACTIV CHAR 1 0
FNUMB SAP Query (S): Function sequence in enhanced folders AQS_FNUMB NUMC 4 0
TEXT_ED SAP Query (S): Text of length 60 AQS_TXT60 CHAR 60 0
TUSED SAP Query: Checkbox AQ_MARK CHAR 1 0
PUSH Carrier field for icons ICON_TEXT CHAR 132 0
CODNAM SAP Query (S): Code area AQS_CODNAM NUMC 2 0
01 DATA
02 START-OF-SELECTION
03 GET
04 GET LATE
05 Record processing
06 END-OF-SELECTION (before List)
07 END-OF-SELECTION (after List)
08 TOP-OF-PAGE
09 AT SELECTION-SCREEN
10 Additional field/structure
11 Free coding
12 INITIALIZATION
13 AT SELECTION-SCREEN OUTPUT
OBJ_SEL SAP Query: Checkbox AQ_MARK CHAR 1 0
NO_SUM SAP Query: Checkbox AQ_MARK CHAR 1 0
TXTFELD SAP Query: Text field name AQ_TXTNAM CHAR 70 0
ABGR_ART SAP Query (S): Type of selection AQS_PARSEL CHAR 1 0
P Parameters
S Select option
DBIFIFNAME SAP Query (S): Class name AQS_CLSNA CHAR 30 0
DBIFACTION SAP Query (S): Text of length 30 AQS_TXT30 CHAR 30 0
DBIFCLSNAM SAP Query (S): Class name AQS_CLSNA CHAR 30 0
DBIFTXTID SAP Query (S): Class name AQS_CLSNA CHAR 30 0
DBIFGENER SAP Query (S): Class name AQS_CLSNA CHAR 30 0
NO_TEXTS SAP Query: Checkbox AQ_MARK CHAR 1 0
SRCHGLOB SAP Query: Checkbox AQ_MARK CHAR 1 0
SRCHSTD SAP Query: Checkbox AQ_MARK CHAR 1 0
WORKSPACE SAP Query (S): Work Area ID AQS_WSID CHAR 1 0