RS38Q SAP (SAP Query: Screen Fields for Transactions SQ02 and SQ09) Structure details
Description: SAP Query: Screen Fields for Transactions SQ02 and SQ09
Structure field list including key, data, relationships and ABAP select examples
RS38Q is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SAP Query: Screen Fields for Transactions SQ02 and SQ09" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RS38Q TYPE RS38Q.
The RS38Q table consists of various fields, each holding specific information or linking keys about SAP Query: Screen Fields for Transactions SQ02 and SQ09 data available in SAP. These include MARK (SAP Query: Checkbox), ZIELNAME (SAP Query: Target InfoSet), ORGNAME (SAP Query: Source InfoSet), LOGDB (SAP Query: Name of a logical database).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP RS38Q structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
NAME | SAP Query: InfoSet | AQ_SGNAME | CHAR | 24 | AQT_SGNAME | ||||
MARK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
ZIELNAME | SAP Query: Target InfoSet | AQ_SGNAME1 | CHAR | 24 | AQT_SGNAME | ||||
ORGNAME | SAP Query: Source InfoSet | AQ_SGNAME2 | CHAR | 24 | AQT_SGNAME | ||||
LOGDB | SAP Query: Name of a logical database | AQ_LOGDB | CHAR | 20 | AQT_LOGDB | SH_LDBD | |||
RLOGDB | SAP Query: Data retrieval using log. database | AQ_RLDB | CHAR | 1 | AQT_FLAG | ||||
SGTEXT | SAP Query: InfoSet text | AQ_SGTEXT | CHAR | 63 | AQS_C63K | ||||
DDNAME | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
RFILE | SAP Query: Data retrieval by program | AQ_RFILE | CHAR | 1 | AQT_FLAG | ||||
SEQU | SAP Query: Read sequential dataset | AQ_RSEQU | CHAR | 1 | AQT_FLAG | ||||
SEQDDNAME | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
RPROGINT | SAP Query: Data retrieval by program | AQ_RFILE | CHAR | 1 | AQT_FLAG | ||||
RPROGEXT | SAP Query: Data retrieval by program | AQ_RFILE | CHAR | 1 | AQT_FLAG | ||||
PROG | SAP Query: Report name | AQ_REPORT | CHAR | 30 | AQT_PGNAMS | ||||
FILDDNAME | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
DIRECT | SAP Query: Direct table read | AQ_DIRECT | CHAR | 1 | AQT_FLAG | ||||
TJOIN | SAP Query: Table join | AQ_JOIN | CHAR | 1 | AQT_FLAG | ||||
JOINDDNAME | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
SECU | SAP Query: Authorization group for starting queries | AQ_SECU | CHAR | 8 | SYCHAR08 | ||||
DBSAINDEX | SAP Query: No./index of fields (internal type P) | AQ_NUMBERP | DEC | 5 | AQS_P50 | ||||
DBSAMAX | SAP Query: Number/index of fields (internal type C) | AQ_NUMBERC | NUMC | 8 | AQS_N8 | ||||
DBSGINDEX | SAP Query: Number/index of fields (internal type C) | AQ_NUMBERC | NUMC | 8 | AQS_N8 | ||||
DBSGMAX | SAP Query: No./index of fields (internal type P) | AQ_NUMBERP | DEC | 5 | AQS_P50 | ||||
SEGNAME | SAP Query: Table name | AQ_SEGNAME | CHAR | 30 | AQT_TNAME | ||||
SEGTEXT | SAP Query: Logical database table text | AQ_SEGTXT2 | CHAR | 40 | AQS_C40K | ||||
DBFINAME | SAP Query: Field name | AQ_FINAME | CHAR | 70 | AQT_FNAME | ||||
DBFITEXT | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | AQT_FTEXT | ||||
DBFITEXTS | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | AQT_FTEXT | ||||
DBFISGNA | SAP Query: Logical database table | AQ_SEG | CHAR | 30 | AQT_TNAME | ||||
DBFIINDEX | SAP Query: No./index of fields (internal type P) | AQ_NUMBERP | DEC | 5 | AQS_P50 | ||||
DBFIMAX | SAP Query: No./index of fields (internal type P) | AQ_NUMBERP | DEC | 5 | AQS_P50 | ||||
DBSANUMB | SAP Query: Field group | AQ_SANAME | CHAR | 2 | AQT_NUMB | ||||
DBSANAME | SAP Query: Functional group text | AQ_SATEXT | CHAR | 80 | AQS_C80K | ||||
DBSFNUMB | SAP Query: Field assignment to field group | AQ_SANAMEF | CHAR | 2 | AQT_NUMB | ||||
DSNNAME | SAP Query: Sequential dataset | AQ_SEQU | CHAR | 60 | AQS_C60K | ||||
SC1 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | AQS_C132K | ||||
SC2 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | AQS_C132K | ||||
SCTEXT | SAP Query: Error info with syntax errors | AQ_SCLINE | CHAR | 6 | AQS_C6 | ||||
SCLINE | SAP Query: Error info with syntax errors | AQ_SCLINE | CHAR | 6 | AQS_C6 | ||||
DBZTNAME | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
IBUFF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
A01 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F01 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A02 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F02 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A03 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F03 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A04 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F04 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A05 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F05 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A06 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F06 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A07 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F07 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A08 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F08 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A09 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F09 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
A10 | SAP Query: SAP table argument | AQ_TABARG | CHAR | 70 | AQT_FNAME | ||||
F10 | SAP Query: Condition for SAP table argument | AQ_TABBED | CHAR | 70 | AQT_FNAME | ||||
DBZFSGNA | SAP Query: Logical database table | AQ_SEG | CHAR | 30 | AQT_TNAME | ||||
DBZFNAME | SAP Query: Additional field | AQ_ZFNAME | CHAR | 21 | AQT_ZFNAME | ||||
DBZFTEXT | SAP Query: Text | AQ_ZFTEXT | CHAR | 60 | AQT_FTEXT | ||||
DBZFTYPE | SAP Query: Internal ABAP type | AQ_TYP | CHAR | 1 | AQS_C1 | ||||
DBZFLENG | SAP Query: Field length | AQ_LENG | CHAR | 3 | AQS_C3 | ||||
DBZFOLENG | SAP Query: Output length | AQ_OLENG | CHAR | 3 | AQS_C3 | ||||
DBZFDECIMA | SAP Query: Decimal places in field output | AQ_DEC | CHAR | 2 | AQS_C2 | ||||
DBZFORDER | SAP Query: Sequence of code | AQ_ORDER | NUMC | 2 | AQS_N2 | ||||
DBZFCODE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBZFCHKTXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBZFHEADL | SAP Query: Header text | AQ_HEAD30 | CHAR | 30 | AQS_C30K | ||||
DBZFHEAD1 | SAP Query: Header text | AQ_HEAD30 | CHAR | 30 | AQS_C30K | ||||
DBZFHEAD2 | SAP Query: Header text | AQ_HEAD30 | CHAR | 30 | AQS_C30K | ||||
DBZFHEAD1S | SAP Query: Header text | AQ_HEAD30 | CHAR | 30 | AQS_C30K | ||||
DBZFHEAD2S | SAP Query: Header text | AQ_HEAD30 | CHAR | 30 | AQS_C30K | ||||
DBZFHEAD1T | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | AQT_FTEXT | ||||
PARHEAD1 | SAP Query: Program selection text | AQ_PARHEAD | CHAR | 30 | AQS_C30K | ||||
DBZFLIKE | SAP Query: Reference field | AQ_LIKE | CHAR | 70 | AQT_FNAME | ||||
I00 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I01 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I02 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I03 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I04 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I05 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I06 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I07 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I08 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
I09 | SAP Query: ABAP code line | AQ_CODE | CHAR | 72 | AQS_C72K | ||||
DBPANAME | SAP Query: Program Selection (Parameter/Selection Criteria) | AQ_PARAM | CHAR | 8 | AQT_PSNAME | ||||
PARORDER | SAP Query: Standard selection screen sequence | AQ_PORDER | NUMC | 2 | AQS_N2 | ||||
DBPAPAR | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBPASEL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBPASTD | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBPANODISP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBPADISP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBPAOBLIG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
CNAM | SAP Query: Author | AQ_CNAM | CHAR | 12 | SYCHAR12 | ||||
CDAT | SAP Query: Creation date | AQ_CDAT | DATS | 8 | SYDATS | ||||
UNAM | SAP Query: Last changed by | AQ_UNAM | CHAR | 12 | SYCHAR12 | ||||
UDAT | SAP Query: Date of last change | AQ_UDAT | DATS | 8 | SYDATS | ||||
FIXPOINT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
MARKBG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
BGNUM | SAP Query: User group | AQ_BGNAME | CHAR | 12 | AQT_BGNAME | ||||
BGTEXT | SAP Query: User group text | AQ_BGTEXT | CHAR | 30 | AQS_C30K | ||||
SEARCH | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | AQS_C30K | ||||
DOMNAME | SAP Query: Domain name | AQ_DOM | CHAR | 30 | AQT_DONAME | ||||
DTYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 4 | DTYPE | DATATYPE | |||
CLENG | SAP Query: Number of characters in search | AQ_CLENG | CHAR | 3 | AQS_C3 | ||||
DECNUMB | SAP Query: Number of decimal places in search | AQ_DECNUMB | CHAR | 2 | AQS_C2 | ||||
SEARCHTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SEARCHDOM | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SEARCHTYPE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SEARCHFIR | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SEARCHLINE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SEARCHCUR | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SELSCREEN | SAP Query: Selection screen version | AQ_SELVER | CHAR | 3 | AQS_C3 | ||||
DBJOTAB | SAP Query: Table name | AQ_SEGNAME | CHAR | 30 | AQT_TNAME | ||||
DBJOLOUT | SAP Query: Link for table join | AQ_OUTER | CHAR | 1 | AQS_C1 | ||||
DBJOINN | SAP Query: Link for table join | AQ_OUTER | CHAR | 1 | AQS_C1 | ||||
DBJOROUT | SAP Query: Link for table join | AQ_OUTER | CHAR | 1 | AQS_C1 | ||||
DBJOMARK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DBJOLIND | SAP Query: Index for table join | AQ_JIND | CHAR | 2 | AQS_C2 | ||||
DBJOLTAB | SAP Query: Table name | AQ_SEGNAME | CHAR | 30 | AQT_TNAME | ||||
DBJOLFELD | SAP Query: Database field name or table prefix | AQ_TFNAME | CHAR | 30 | AQT_TFNAME | ||||
DBJOLTEXT | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | AQT_FTEXT | ||||
DBJORIND | SAP Query: Index for table join | AQ_JIND | CHAR | 2 | AQS_C2 | ||||
DBJORTAB | SAP Query: Table name | AQ_SEGNAME | CHAR | 30 | AQT_TNAME | ||||
DBJORFELD | SAP Query: Database field name or table prefix | AQ_TFNAME | CHAR | 30 | AQT_TFNAME | ||||
DBJORTEXT | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | AQT_FTEXT | ||||
SGNAME1 | SAP Query: InfoSet | AQ_SGNAME | CHAR | 24 | AQT_SGNAME | ||||
DAT1 | SAP Query: Data source of a query | AQ_DAT | CHAR | 35 | AQS_C35K | ||||
DAT2 | SAP Query: Data source of a query | AQ_DAT | CHAR | 35 | AQS_C35K | ||||
SGTEXT1 | SAP Query: InfoSet text | AQ_SGTEXT | CHAR | 63 | AQS_C63K | ||||
TEXT | SAP Query: General text | AQ_TEXT | CHAR | 60 | AQS_C60K | ||||
ART | SAP Query: Type of selection/ Additional information | AQ_ART | CHAR | 20 | AQS_C20K | ||||
STDSEL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
ETEXT | SAP Query: General text | AQ_TEXT | CHAR | 60 | AQS_C60K | ||||
ENAME | SAP Query: Name of additional table/field/structure | AQ_ENAME | CHAR | 30 | AQT_TNAME | ||||
EARTTAB | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
EARTFELD | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
EARTSTRUC | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
EARTCODE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
DDICTAB | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
ALIASTAB | SAP Query: Tables | AQ_TAB | CHAR | 30 | AQT_TNAME | ||||
WSTEXT | SAP Query: Text for query area | AQ_WSTEXT | CHAR | 50 | AQS_C50K | ||||
REFFELD | SAP Query: Reference field for a field | AQ_REFFELD | CHAR | 30 | AQT_TFNAME | ||||
FUNCTION | SAP Query (S): Function module name | AQS_FUNC | CHAR | 30 | AQS_C30 | ||||
XIKEY | SAP Query (S): Name of additional function | AQS_XIKEY | CHAR | 30 | AQS_C30K | ||||
IFTYPE | SAP Query (S): Interface type | AQS_IFTYPE | NUMC | 2 | AQS_N2 | ||||
ACTIV | SAP Query: Active function flag in enhanced folders | AQS_ACTIV | CHAR | 1 | AQT_FLAG | ||||
FNUMB | SAP Query (S): Function sequence in enhanced folders | AQS_FNUMB | NUMC | 4 | AQS_N4 | ||||
TEXT_ED | SAP Query (S): Text of length 60 | AQS_TXT60 | CHAR | 60 | AQS_C60K | ||||
TUSED | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
PUSH | Carrier field for icons | ICON_TEXT | CHAR | 132 | SYCHAR132 | ||||
CODNAM | SAP Query (S): Code area | AQS_CODNAM | NUMC | 2 | AQS_CODNAM | ||||
OBJ_SEL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
NO_SUM | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
TXTFELD | SAP Query: Text field name | AQ_TXTNAM | CHAR | 70 | AQT_FNAME | ||||
ABGR_ART | SAP Query (S): Type of selection | AQS_PARSEL | CHAR | 1 | AQS_PASEL | ||||
DBIFIFNAME | SAP Query (S): Class name | AQS_CLSNA | CHAR | 30 | SEOCLSNAME | ||||
DBIFACTION | SAP Query (S): Text of length 30 | AQS_TXT30 | CHAR | 30 | AQS_C30K | ||||
DBIFCLSNAM | SAP Query (S): Class name | AQS_CLSNA | CHAR | 30 | SEOCLSNAME | ||||
DBIFTXTID | SAP Query (S): Class name | AQS_CLSNA | CHAR | 30 | SEOCLSNAME | ||||
DBIFGENER | SAP Query (S): Class name | AQS_CLSNA | CHAR | 30 | SEOCLSNAME | ||||
NO_TEXTS | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SRCHGLOB | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
SRCHSTD | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | AQT_FLAG | ||||
WORKSPACE | SAP Query (S): Work Area ID | AQS_WSID | CHAR | 1 | AQT_WSID |
Key field | Non-key field |
How do I retrieve data from SAP structure RS38Q using ABAP code?
As RS38Q is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RS38Q as there is no data to select.How to access SAP table RS38Q
Within an ECC or HANA version of SAP you can also view further information about RS38Q and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects