SQADB04_S SAP (Dialog answer structure) Structure details
Description: Dialog answer structure
Structure field list including key, data, relationships and ABAP select examples
SQADB04_S 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 "Dialog answer structure" 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_SQADB04_S TYPE SQADB04_S.
The SQADB04_S table consists of various fields, each holding specific information or linking keys about Dialog answer structure data available in SAP. These include QUEID (Unique question ID), ANSWERTYPE (Answer type), ANSGLOBAL (Unique answer flag), FSTUSER (Created by).. 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 SQADB04_S 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 |
QUEST | 0 | ||||||||
QUEID | Unique question ID | SQUEID | CHAR | 20 | SQUEID | SQA | |||
ANSWERTYPE | Answer type | SANSTYPE | CHAR | 1 | SANSTYPE | ||||
ANSGLOBAL | Unique answer flag | SGLOBAL | CHAR | 1 | UFFLAG | ||||
FSTUSER | Created by | UDFUSER | CHAR | 12 | UDUSER | ||||
FSTTSTAMP | Last changed on/by | UFTSTAMP | DEC | 15 | TZNTSTMPS | ||||
FSTREL | First Release | UFFSTREL | CHAR | 4 | RELE | UFRELE | |||
LSTUSER | Changed by | UDLUSER | CHAR | 12 | UDUSER | ||||
LSTTSTAMP | Last changed on/by | UFTSTAMP | DEC | 15 | TZNTSTMPS | ||||
LSTREL | Last Changed in Release | UFLSTREL | CHAR | 4 | RELE | UFRELE | |||
CHTAB | Possible selection table | SQACHTAB | CHAR | 30 | AS4TAB | ||||
CHFIELD | Possible selection table field | SQACHFIELD | CHAR | 30 | FDNAME | ||||
STATUS | Modeling status | UFSTATUS | CHAR | 2 | UFSTATUS | ||||
SQADB02CH | 0 | ||||||||
CURSOR_IX | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
DEL_CHOICE | 0 | ||||||||
SQADB01CAT | 0 | ||||||||
SQADB01CON | 0 | ||||||||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
ADDON | Name of an Add-On Product | ADDONID | CHAR | 10 | ADDONID | ||||
VERSION | 0 | ||||||||
ADDONID_N | QADB write R/3 industry sector enhancement | SQAWADDON | CHAR | 15 | SBRANCH | SQAWADDON | |||
ADDONID_O | QADB read procedures R/3 industry enhancement | SQARADDON | CHAR | 15 | SBRANCH | SQARADDON | |||
NAMESPACE | QADB write procedure name space name | SQANAME | CHAR | 10 | NAMESPACE | SQANAME | |||
QTEXT | Question text | SQTEXT | CHAR | 255 | TEXT255 | ||||
RB_FREI | Answer type free format answer | S_RB_FREI | CHAR | 1 | RADIOFIELD | ||||
RB_FORMAT | Radio button answer type formatted answer | S_RB_FMT | CHAR | 1 | RADIOFIELD | ||||
RB_RATING | Radio Button: Valuation Answer Type | S_RB_RATE | CHAR | 1 | RADIOFIELD | ||||
RB_YES | Radio button answer type Yes/No decision | S_RB_YES | CHAR | 1 | RADIOFIELD | ||||
RB_SINGLE | Radio button answer type single selection | S_RB_SINGL | CHAR | 1 | RADIOFIELD | ||||
RB_MULTI | Radio button answer type multi-selection | S_RB_MULTI | CHAR | 1 | RADIOFIELD | ||||
RB_GLOBAL | Answer applies in all instances | S_RB_GLOB | CHAR | 1 | RADIOFIELD | ||||
RB_LOKAL | Radio button answer locally valid | S_RB_LOKL | CHAR | 1 | RADIOFIELD | ||||
FSTTSTAMPS | Time stamp created in local processing | S_FSTAMPS | NUMC | 15 | TSTPS | TZNTSTMPSL | |||
LSTTSTAMPS | Last change time stamp processed locally | S_LSTAMPS | NUMC | 15 | TSTPS | TZNTSTMPSL | |||
FSTDATE | Created on | S_FSTDATE | DATS | 8 | DATUM | ||||
FSTTIME | Time created | S_FSTTIME | TIMS | 6 | UZEIT | ||||
LSTDATE | Changed on | S_LSTDATE | DATS | 8 | DATUM | ||||
LSTTIME | Last changed at | S_LSTTIME | TIMS | 6 | UZEIT | ||||
RB_INTERN | Radio Button: Internal Use of SAP Review Program | S_RB_INT | CHAR | 1 | |||||
RB_EXTERN | Radio Button: External Use of SAP Review Program | S_RB_EXT | CHAR | 1 | |||||
RB_OBL | Radio Button: Mandatory Question for SAP Review Program | S_RB_OBL | CHAR | 1 | |||||
RB_OPT | Radio Button: Optional Question for SAP Review Program | S_RB_OPT | CHAR | 1 | |||||
DOCU | 0 | ||||||||
D_CHANGED | Data changed in dialog flag | SQACHANGE | CHAR | 1 | |||||
T_MODE | Dialog processing mode | SQAMODE | CHAR | 3 | SQAMODE | ||||
ENQUED | Flag: Object is locked | SQAENQ | CHAR | 1 | |||||
RC | Return Code | SYSUBRC | INT4 | 10 | SYST_SHORT | ||||
TS_DYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
TS_REPID | ABAP Program: Current Main Program | SYREPID | CHAR | 40 | PROGRAMM | ||||
TS_ATAB | Function Code | SYUCOMM | CHAR | 70 | SYCHAR70 | ||||
STERM | 0 | ||||||||
E_PARENT | 0 | ||||||||
EDITOR | 0 | ||||||||
DOCU_IN_EC | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
EC_DYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
EC_REPID | ABAP Program: Current Main Program | SYREPID | CHAR | 40 | PROGRAMM | ||||
TXT_PARENT | 0 | ||||||||
TEXT_EC | 0 | ||||||||
TEXT_IN_EC | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
TXT_DYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
DEVCLASS | Package | DEVCLASS | CHAR | 30 | DEVCLASS | DVC | DEVCLASS | ||
QTYP | Question Type | SQATYP | CHAR | 1 | SQATYP | ||||
PROB | Risk Probability | SREVPROB | INT1 | 3 | SREVPROB | ||||
PRIO | Priority | SREVPRIO | CHAR | 1 | SREVPRIO | ||||
USAG | Use | SREVUSE | CHAR | 1 | SREVUSE | ||||
AGENDA | Length of Review | SREVAGENDA | INT1 | 3 | SREVAGENDA | ||||
SUBJAREA | SAP Review Program Topic (Category) | SREV02 | CHAR | 3 | ALPHA | SREV02 | |||
SUBJECT | Topic (Subcategory) for SAP Review Program | SREV03 | CHAR | 3 | ALPHA | SREV03 | |||
MEMO | Notes Field for Review Questions | SREVMEMO | CHAR | 50 | SREVMEMO | ||||
SQADB01DOC | 0 | ||||||||
TC_DOC | 0 | ||||||||
ADDON | 0 | ||||||||
ADDONID | QADB write R/3 industry sector enhancement | SQAWADDON | CHAR | 15 | SBRANCH | SQAWADDON | |||
ORIG_ADDON | QADB read procedures R/3 industry enhancement | SQARADDON | CHAR | 15 | SBRANCH | SQARADDON | |||
NAMESPACE | QADB write procedure name space name | SQANAME | CHAR | 10 | NAMESPACE | SQANAME | |||
ANSID | Answer (32 byte GUID) | SANSID | CHAR | 32 | SYSUUID_C | ||||
QUEID | Unique question ID | SQUEID | CHAR | 20 | Assigned to domain | SQUEID | SQA | ||
OCCID | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | SYCHAR32 | ||||
PROID | Project Name | PROJECT_ID | CHAR | 10 | Assigned to domain | ALPHA | PROJECT_ID | ||
TEMPLATE | Template ID | TEMP_ID | CHAR | 20 | Assigned to domain | TEMP_ID | |||
DOANS | Dominant answer (32 byte GUID) | SDOANSID | CHAR | 32 | SYSUUID_C | ||||
STATUS | Answer status | SANSSTAT | CHAR | 1 | SANSSTAT | ||||
FSTUSER | Created by | UDFUSER | CHAR | 12 | UDUSER | ||||
FSTTSTAMP | Last changed on/by | UFTSTAMP | DEC | 15 | TZNTSTMPS | ||||
FSTREL | First Release | UFFSTREL | CHAR | 4 | RELE | UFRELE | |||
LSTUSER | Changed by | UDLUSER | CHAR | 12 | UDUSER | ||||
LSTTSTAMP | Last changed on/by | UFTSTAMP | DEC | 15 | TZNTSTMPS | ||||
LSTREL | Last Changed in Release | UFLSTREL | CHAR | 4 | RELE | UFRELE | |||
DOCU_ID | ID for documents and relations | SDOK_DOCID | CHAR | 32 | SDOK_DOCID | ||||
CHOICE | 0 | ||||||||
TC | Flag: Modular table control used | SQATC | CHAR | 1 | |||||
TC_HANDLE | Encapsulated table control handle | STC_HANDLE | CHAR | 40 | STC_HANDLE | ||||
TC_DYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
TC_REPID | ABAP Program: Current Main Program | SYREPID | CHAR | 40 | Assigned to domain | PROGRAMM | |||
D_CHANGED | Data changed in dialog flag | SQACHANGE | CHAR | 1 | |||||
T_MODE | Dialog processing mode | SQAMODE | CHAR | 3 | SQAMODE | ||||
ENQUED | Flag: Object is locked | SQAENQ | CHAR | 1 | |||||
RC | Return Code | SYSUBRC | INT4 | 10 | SYST_SHORT | ||||
OK_CODE | Function Code | SYUCOMM | CHAR | 70 | SYCHAR70 | ||||
ANSDYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
ANSREPID | ABAP Program: Current Main Program | SYREPID | CHAR | 40 | Assigned to domain | PROGRAMM | |||
ATEXT | 0 | ||||||||
TS_DYNNR | Dynpro Number | SYDYNNR | CHAR | 4 | SYCHAR04 | ||||
TS_REPID | ABAP Program: Current Main Program | SYREPID | CHAR | 40 | Assigned to domain | PROGRAMM | |||
TS_ATAB | Function Code | SYUCOMM | CHAR | 70 | SYCHAR70 | ||||
DOM_MODE | Indicator for Dominant/Subordinate/Local/Global | SQADOM | CHAR | 1 | SQADOM | ||||
TAKE_OVER | Unique ID - 32 characters | HIER_GUID | CHAR | 32 | SYCHAR32 | ||||
PLANGU | Language Key | SYLANGU | LANG | 1 | ISOLA | SYLANGU |
Key field | Non-key field |
How do I retrieve data from SAP structure SQADB04_S using ABAP code?
As SQADB04_S 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 SQADB04_S as there is no data to select.How to access SAP table SQADB04_S
Within an ECC or HANA version of SAP you can also view further information about SQADB04_S 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