SAP Table RS38R
SAP Query: Screen Fields for Transactions SQ00 and SQ01
RS38R (SAP Query: Screen Fields for Transactions SQ00 and SQ01) 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 RS38R to other SAP tables.
RS38R table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
QNUM | SAP Query: Query name / QuickView name | AQ_QUNAME | CHAR | 14 | 0 | |||
PREFX | SAP Query: User group | AQ_BGNAME | CHAR | 12 | 0 | |||
VARIANT | SAP Query: Variant name | AQ_VARIANT | CHAR | 14 | 0 | |||
STDVARIANT | SAP Query: Variant name | AQ_VARIANT | CHAR | 14 | 0 | |||
BGNUM | SAP Query: User group | AQ_BGNAME | CHAR | 12 | 0 | |||
BGTEXT | SAP Query: User group text | AQ_BGTEXT | CHAR | 30 | 0 | |||
CQNUM | SAP Query: Query name / QuickView name | AQ_QUNAME | CHAR | 14 | 0 | |||
BNAME | SAP Query: User name | AQ_BNAME | CHAR | 12 | 0 | |||
CCLAS | SAP Query: InfoSet | AQ_SGNAME | CHAR | 24 | 0 | |||
EINST_GRAF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_JOIN | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_HILF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_OHNE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_ZAUF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_SYST | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_ICAT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
OLDMARK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
SA_MARK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
MARK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
DBSANAME | SAP Query: Functional group text | AQ_SATEXT | CHAR | 80 | 0 | |||
DBSFTEXT | SAP Query: Field text | AQ_FITEXT | CHAR | 60 | 0 | |||
KNAME | SAP Query: Short name of a field | AQ_KNAME | CHAR | 10 | 0 | |||
LFCOLTEXT1 | SAP Query: Column header | AQ_COLHEAD | CHAR | 40 | 0 | |||
LFCOLTEXT2 | SAP Query: Column header | AQ_COLHEAD | CHAR | 40 | 0 | |||
SFCOLTEXT1 | SAP Query: Column header | AQ_COLHEAD | CHAR | 40 | 0 | |||
SFCOLTEXT2 | SAP Query: Column header | AQ_COLHEAD | CHAR | 40 | 0 | |||
LFKNAMEREF | SAP Query: Short name of a field | AQ_KNAME | CHAR | 10 | 0 | |||
LFCNUM | SAP Query: Number of characters for a text field | AQ_CNUM | NUMC | 3 | 0 | |||
LFDNUM | SAP Query: Number of digits | AQ_DNUM | NUMC | 2 | 0 | |||
LFDECNUM | SAP Query: Number of digits | AQ_DNUM | NUMC | 2 | 0 | |||
LFCOMP1 | SAP Query: Formula | AQ_COMP | CHAR | 60 | 0 | |||
LFBED1 | SAP Query: Condition | AQ_BED | CHAR | 60 | 0 | |||
LFOBLIGAT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
OPOUT | SAP Query: Line number | AQ_LNUM | NUMC | 2 | 0 | |||
OPPOS | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
OPSORT | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
OPSUM | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
OPSELECT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
OPCNT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LINR | SAP Query: Line number | AQ_LNUMP | NUMC | 2 | 0 | |||
LISKIP1 | SAP Query: Line number | AQ_ROWNUM | NUMC | 2 | 0 | |||
LISKIP2 | SAP Query: Line number | AQ_ROWNUM | NUMC | 2 | 0 | |||
LIHEAD | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LITOP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LICOND | SAP Query: Line number | AQ_LNUMP | NUMC | 2 | 0 | |||
LINEWPA | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LILCOLOR | SAP Query: Color | AQ_LCOLOR | CHAR | 12 | 0 | |||
LIULINE1 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LIULINE2 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LICOLSEP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LNR01 | SAP Query: Line number | AQ_LNUMP | NUMC | 2 | 0 | |||
FMMASKE | SAP Query: Format template | AQ_FMASK | CHAR | 50 | 0 | |||
FFDLAENGE | SAP Query: Output length | AQ_FLENGP | NUMC | 3 | 0 | |||
FFLAENGE | SAP Query: Output length | AQ_FLENGP | NUMC | 3 | 0 | |||
FFPOSITION | SAP Query: Line length/position in line | AQ_LLENG | NUMC | 3 | 0 | |||
FFNOCURRY | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
FFAFCURRY | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
FFBECURRY | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
FFMASKE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
FFNOZERO | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
FFLCOLOR | SAP Query: Color | AQ_LCOLOR | CHAR | 12 | 0 | |||
FFROUND | SAP Query: Rounding factor | AQ_ROUNDP | NUMC | 1 | 0 | |||
COLHEAD1 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
COLHEAD2 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
COLHEAD3 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
COLHEADS1 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
COLHEADS2 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
COLHEADS3 | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
GRDESC | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRTOTAL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRCNT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRNEWPAGE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRSKIP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRFRAME | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
SESTEXT | SAP Query: Selection text | AQ_SELTEXT | CHAR | 30 | 0 | |||
HDTITLE | SAP Query: Title/notes | AQ_QUTEXT | CHAR | 60 | 0 | |||
HDLINSZ | SAP Query: Line length/position in line | AQ_LLENG | NUMC | 3 | 0 | |||
HDLINCT | SAP Query: Line number | AQ_ROWNUM | NUMC | 2 | 0 | |||
HDPAGENUM | SAP Query: Number of pages | AQ_PAGNUM | NUMC | 3 | 0 | |||
HDLINSZTAB | SAP Query: Line length/position in line | AQ_LLENG | NUMC | 3 | 0 | |||
HDLINSZBL | SAP Query: Line length/position in line | AQ_LLENG | NUMC | 3 | 0 | |||
HDSQFF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDSQUP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDDOWN | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDSSET | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDGRAF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDFILE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDPRIV | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDVIEW | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDABC | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDALV | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDLOCK | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDSTDTITEL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDMARGIN | SAP Query: Left margin for printing | AQ_MARGIN | NUMC | 2 | 0 | |||
HDTEXT1 | SAP Query: Title/notes | AQ_QUTEXT | CHAR | 60 | 0 | |||
HDTEXT2 | SAP Query: Title/notes | AQ_QUTEXT | CHAR | 60 | 0 | |||
HDTEXT3 | SAP Query: Title/notes | AQ_QUTEXT | CHAR | 60 | 0 | |||
HDFRAME | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDCOLSEP | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDTOTAL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDNOZOPT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDOLDSTRUC | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDFLAT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDNOMEMID | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
HDALVCNT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
DBVSNUM | SAP Query: Statistic or ranked list number | AQ_PARTNUM | DEC | 2 | 0 | |||
DBVSTEXT | SAP Query: Statistic/ranked list header | AQ_VSTEXT | CHAR | 50 | 0 | |||
DBVSCURRY | SAP Query: Reference unit in statistics/ranked lists | AQ_CURRY | CHAR | 5 | 0 | |||
GRAFWINDOW | SAP Query: Number of values displayed graphically | AQ_GWINDOW | NUMC | 2 | 0 | |||
GRAFDYN | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRAFCOLOR | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
GRAFTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSPOS | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
VSSORT | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
VSABST | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSSUBTOTAL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSNEWPAGE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSCNT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSSUM | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSAVG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSPER | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
VSOLEN | SAP Query: Output length | AQ_FLENG | NUMC | 2 | 0 | |||
VSROUND | SAP Query: Rounding factor | AQ_ROUNDP | NUMC | 1 | 0 | |||
VSTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
DBRLNUM | SAP Query: Statistic or ranked list number | AQ_PARTNUM | DEC | 2 | 0 | |||
DBRLTEXT | SAP Query: Statistic/ranked list header | AQ_VSTEXT | CHAR | 50 | 0 | |||
DBRLCURRY | SAP Query: Reference unit in statistics/ranked lists | AQ_CURRY | CHAR | 5 | 0 | |||
DBSGTEXT | SAP Query: Ranked list level | AQ_SEGTEXT | CHAR | 40 | 0 | |||
DBRLOCCU | SAP Query: Scope of ranked list | AQ_RLSIZE | NUMC | 3 | 0 | |||
RLPOS | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
RLPFIELD | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
RLAUFST | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
RLOLEN | SAP Query: Output length | AQ_FLENG | NUMC | 2 | 0 | |||
RLROUND | SAP Query: Rounding factor | AQ_ROUNDP | NUMC | 1 | 0 | |||
RLTEXT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
DELRANG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R1 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R2 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R3 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R4 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R5 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R6 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R7 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R8 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
R9 | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
QNAME1 | SAP Query: Query name / QuickView name | AQ_QUNAME | CHAR | 14 | 0 | |||
QUERIES1 | SAP Query: Query directory line | AQ_QLIST | CHAR | 72 | 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 | |||
SCALE | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
OUTPUTLINE | SAP Query: Text line | AQ_DYLINE | CHAR | 132 | 0 | |||
LINNO | SAP Query: Line number | AQ_LNUM | NUMC | 2 | 0 | |||
AQAVG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
AQCNT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
AQPER | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
AQRNG | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
LOGIC | SAP Query: Line number | AQ_LNUM | NUMC | 2 | 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 | |||
SEARCH1 | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | 0 | |||
SEARCH2 | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | 0 | |||
SEARCH3 | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | 0 | |||
SEARCH4 | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | 0 | |||
SEARCH5 | SAP Query: Search criterion | AQ_SEARCH | CHAR | 30 | 0 | |||
SEARCHF | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
SEARCHT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
SEARCHL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
UEHEAD | SAP Query: Header line | AQ_UEHEAD | CHAR | 255 | 0 | |||
UECOL | SAP Query: Column header | AQ_UECOL | CHAR | 255 | 0 | |||
UELINE | SAP Query: Line display | AQ_UELINE | CHAR | 255 | 0 | |||
UEFOOT | SAP Query: Footer | AQ_UEFOOT | CHAR | 255 | 0 | |||
LISTSORT | SAP Query: Sequence | AQ_LPOS | NUMC | 2 | 0 | |||
LISTNAME | SAP Query: Name of a sub-list | AQ_LNAME | CHAR | 15 | 0 | |||
LISTTEXT | SAP Query: Long text for a sub-list | AQ_LTEXT | CHAR | 70 | 0 | |||
WSTEXT | SAP Query: Text for query area | AQ_WSTEXT | CHAR | 50 | 0 | |||
DBACC | SAP Query: Maximum number of database accesses | AQ_DBACC | NUMC | 6 | 0 | |||
SEORDER | SAP Query: Sequence on selection screen | AQ_SEORDER | NUMC | 2 | 0 | |||
NO_IVAL | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
NO_EXTS | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_TREE | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_TECH | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_RDAT | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_OLDR | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_MEM | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 | |||
EINST_RRI | SAP Query: Checkbox | AQ_MARK | CHAR | 1 | 0 |