SAP Reports / Programs
SAPMS38R SAP ABAP dialog Program - Maintain queries
SAPMS38R is a standard Module pool for a dialog screen ABAP Program available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SAPMS38R into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
SQ00 - SAP Query: Start queries
SQ01 - SAP Query: Maintain queries
SQVI - QuickViewer
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SAPMS38R. "Basic submit
SUBMIT SAPMS38R AND RETURN. "Return to original report after report execution complete
SUBMIT SAPMS38R VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: Maintain queries
Text Symbol: J02 = Overwrite?
Text Symbol: J03 = Copy Query Report
Text Symbol: L00 = **List texts
Text Symbol: L11 = Sum of ______________________________________________________________________________________________
Text Symbol: L12 = Count ______________________________________________________________________________________________
Text Symbol: L13 = _______________________________________________________________________________________________________________________________--___
Text Symbol: L15 = Overall Total
Text Symbol: L16 = Total Number
Text Symbol: L31 = Page Header
Text Symbol: L32 = Page Footer
Text Symbol: L41 = Totals
Text Symbol: L42 = Total count
Text Symbol: MF0 = **Context menu tree: Fields
Text Symbol: MF1 = Find field in list
Text Symbol: MF2 = Insert into list
Text Symbol: MF3 = Delete from list
Text Symbol: MF4 = Switch off selection field
Text Symbol: MF5 = Switch on selection field
Text Symbol: MF6 = Technical information
Text Symbol: MF7 = Switch on totaling
Text Symbol: MF8 = Switch off totaling
Text Symbol: MF9 = Switch on counting
Text Symbol: MG0 = Switch off counting
Text Symbol: P00 = **Query Painter
Text Symbol: P01 = Insert header text here
Text Symbol: P02 = Insert footer text here
Text Symbol: P21 = Field information
Text Symbol: P22 = Delete Field
Text Symbol: P23 = List line options
Text Symbol: DU3 = Data retrieval program:
Text Symbol: DU4 = Table/View/Structure
Text Symbol: DU5 = Table join
Text Symbol: DU6 = Simple Table
Text Symbol: DU7 = HR InfoSet/logical database
Text Symbol: DU8 = Sequential file
Text Symbol: E00 = **Initial screen
Text Symbol: E41 = Data retrieval program
Text Symbol: E42 = Sequential dataset
Text Symbol: E43 = Database
Text Symbol: E44 = **Selection help: InfoSet type
Text Symbol: E45 = Table join
Text Symbol: E46 = Logical database
Text Symbol: E47 = SAP Query InfoSet
Text Symbol: E48 = Table
Text Symbol: E51 = List Output
Text Symbol: E52 = SAP List Viewer
Text Symbol: E53 = Word
Text Symbol: E54 = Excel
Text Symbol: E55 = Graphics
Text Symbol: E56 = Display as Table
Text Symbol: E57 = ABC analysis
Text Symbol: E58 = Executive information system(EIS)
Text Symbol: E59 = local file
Text Symbol: E71 = Line __
Text Symbol: E81 = Change join
Text Symbol: E82 = Display join
Text Symbol: G01 = Basic List
Text Symbol: J01 = Target Report Already Exists
Text Symbol: P24 = Format fields justified left
Text Symbol: T51 = Background (intensified)
Text Symbol: T52 = Header (intensified)
Text Symbol: T53 = Normal (intensified)
Text Symbol: T54 = Sum totals (intensified)
Text Symbol: T55 = Keys (intensified)
Text Symbol: T56 = Positive (intensified)
Text Symbol: T57 = Negative (intensified)
Text Symbol: T58 = Control lev.(intensified)
Text Symbol: T63 = Sort fields
Text Symbol: T64 = Totaling fields
Text Symbol: T65 = Counting fields
Text Symbol: T71 = Horizontal
Text Symbol: T72 = Vertical
Text Symbol: T73 = Deactivate
Text Symbol: T75 = Heading
Text Symbol: TR5 = Table join
Text Symbol: U02 = Interim count at control level no.**.
Text Symbol: U03 = Interim sum at control level no.**.
Text Symbol: U04 = Column header for list line no.**
Text Symbol: U05 = List line no.**
Text Symbol: V01 = Total
Text Symbol: V02 = Number
Text Symbol: V03 = *Total number
Text Symbol: V11 = Proportion
Text Symbol: V12 = in %
Text Symbol: V13 = *Percentage
Text Symbol: V21 = Average
Text Symbol: V22 = Value
Text Symbol: V23 = *Average value
Text Symbol: P25 = Field template
Text Symbol: P26 = List options
Text Symbol: Q01 = QuickViews for user: &1
Text Symbol: Q03 = Save QuickView &1 now?
Text Symbol: Q04 = Exit QuickView Maintenance
Text Symbol: R01 = Sequence
Text Symbol: R03 = *Rank
Text Symbol: T00 = **Toolbars
Text Symbol: T03 = Select data source
Text Symbol: T11 = Insert line
Text Symbol: T12 = Tool box
Text Symbol: T13 = Colors
Text Symbol: T14 = Trash can
Text Symbol: T16 = Sort fields
Text Symbol: T17 = Totals field
Text Symbol: T20 = **List colors
Text Symbol: T21 = Background
Text Symbol: T22 = Heading
Text Symbol: T23 = Normal
Text Symbol: T24 = Subtotals
Text Symbol: T25 = Key Columns
Text Symbol: T26 = Positive
Text Symbol: T27 = Negative
Text Symbol: T28 = Control Levels
Text Symbol: T29 = Line color
Text Symbol: T31 = Delete
Text Symbol: T32 = Total
Text Symbol: T41 = Totaling
Text Symbol: T42 = Separators
Text Symbol: DTE = Name of field's previous field group
Text Symbol: 116 = Save InfoSet?
Text Symbol: 117 = Generate InfoSet first?
Text Symbol: 140 = Delete a parameter
Text Symbol: 141 = Parameter
Text Symbol: 142 = : Delete from InfoSet?
Text Symbol: 143 = Delete selection criterion
Text Symbol: 144 = Selection criterion
Text Symbol: 145 = should be deleted from the InfoSet?
Text Symbol: 150 = Basic List
Text Symbol: 151 = Statistic &
Text Symbol: 152 = Ranked list &
Text Symbol: 156 = Delete an alias table
Text Symbol: 157 = Alias table
Text Symbol: 158 = should be deleted from the InfoSet?
Text Symbol: 210 = Delete statistic
Text Symbol: 211 = Delete statistic?
Text Symbol: 216 = F4 Help
Text Symbol: 220 = Delete ranked list
Text Symbol: 221 = Delete ranked list?
Text Symbol: 230 = Delete basic list
Text Symbol: 231 = Delete basic list?
Text Symbol: 300 = Condition
Text Symbol: 305 = Formula
Text Symbol: 310 = otherwise
Text Symbol: 350 = Enter arguments for all key fields
Text Symbol: 400 = Delete a used field
Text Symbol: 410 = Field '
Text Symbol: 420 = ' is used in lists. Cancel selection anyway?
Text Symbol: 425 = ' is used. Delete anyway?
Text Symbol: 115 = Exit InfoSet processing
Text Symbol: 001 = Total
Text Symbol: 002 = Overall Total
Text Symbol: 003 = Number of
Text Symbol: 004 = Total Number
Text Symbol: 005 = Comments
Text Symbol: 007 = Short Description
Text Symbol: 008 = Basis mode
Text Symbol: 009 = Layout mode
Text Symbol: 010 = Line Color
Text Symbol: 011 = in ascending order
Text Symbol: 012 = Slash before
Text Symbol: 013 = Slash after
Text Symbol: 014 = Space before
Text Symbol: 015 = Space after
Text Symbol: 016 = Line
Text Symbol: 017 = Field Selected
Text Symbol: 018 = Field Not Selected
Text Symbol: 020 = Name
Text Symbol: 030 = Title
Text Symbol: 035 = InfoSet
Text Symbol: 040 = Logical Database
Text Symbol: 050 = Table/View/Join
Text Symbol: 060 = InfoSet Title
Text Symbol: 100 = Queries of user group $: $
Text Symbol: 101 = Dummy field group
Text Symbol: 102 = QuickView &1 (Generated InfoSet).
Text Symbol: 105 = InfoSet
Text Symbol: 110 = Control level &
Text Symbol: 114 = Changes will be lost
Text Symbol: 950 = Delete query
Text Symbol: 951 = Query
Text Symbol: 952 = Delete?
Text Symbol: CT1 = **Context menu tables
Text Symbol: CT2 = Insert additional field
Text Symbol: CT3 = Display table fields in list
Text Symbol: CT5 = Highlight hierarchy
Text Symbol: D00 = ****Data source **********************************
Text Symbol: D03 = QuickView &1 does not exist.
Text Symbol: D04 = Do you want to create a QuickView?
Text Symbol: D05 = Create
Text Symbol: D06 = Cancel
Text Symbol: D07 = Create Quickview?
Text Symbol: D52 = List
Text Symbol: D53 = Selection
Text Symbol: D54 = Sort
Text Symbol: DT1 = Data fields
Text Symbol: DT2 = Data source hierarchy with fields
Text Symbol: DT3 = List fields
Text Symbol: DT4 = Fields displayed in list
Text Symbol: DT5 = Selection Fields
Text Symbol: DT6 = Fields appearing on the selection screen
Text Symbol: DT7 = Sort fields
Text Symbol: DT8 = Fields displayed in list
Text Symbol: DT9 = Additional Fields
Text Symbol: DTA = Technical Name
Text Symbol: DTB = Technical name for table or field
Text Symbol: DTC = Local additional fields
Text Symbol: DTD = Field group description
Text Symbol: 814 = Do you want to display the InfoSet without adjusting it first?
Text Symbol: 450 = Delete a local field
Text Symbol: 460 = Local field '
Text Symbol: 470 = ': Delete?
Text Symbol: 600 = Page header (headers and column headers)
Text Symbol: 605 = Line structure
Text Symbol: 610 = Page Footer
Text Symbol: 615 = Help texts
Text Symbol: 650 = Page header: Maintain fixed header lines by specification
Text Symbol: 651 = Maintain column header of a field with the function
Text Symbol: 652 = 'Maintain column header'
Text Symbol: 653 = _ Insert/delete complete lines of the column header with the
Text Symbol: 654 = Function 'Insert/delete column header line'
Text Symbol: 660 = Line structure: Display fields on individual lines
Text Symbol: 670 = Page footer: Maintain page footer lines by specification
Text Symbol: 680 = Blank lines in the page header and page footer are not output in the
Text Symbol: 681 = list
Text Symbol: 700 = Cancelling query processing
Text Symbol: 702 = Terminate QuickView processing
Text Symbol: 705 = Cancel Processing?
Text Symbol: 710 = Save query first?
Text Symbol: 720 = Return to initial screen
Text Symbol: 730 = Changes will be lost
Text Symbol: 800 = Query not current
Text Symbol: 801 = Difference between query and InfoSet.
Text Symbol: 802 = Continue processing?
Text Symbol: 810 = Due to changes in the Data Dictionary some fields in the InfoSet are
Text Symbol: 811 = different to fields in the Data Dictionary. Use the "Adjust" function,
Text Symbol: 812 = to adjust the InfoSet so that it matches the Data Dictionary.
Text Symbol: 813 = Do you want to maintain the InfoSet without adjusting it first?
INCLUDES used within this REPORT SAPMS38R
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
No SAP FUNCTION MODULES are executed within this report code!
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SAPMS38R or its description.