|Home • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Dynamic SELECT Statement (Enhanced functionality of Transaction SE16 and Index Identifier)
By Arnab Ganguly, Capgemini
The purpose of this document is to
briefly describe a development, which will dynamically retrieve data from
database tables, based upon user input. Here, table name can be specified by the
use or which field needs to be displayed can be put into selection screen, even
which will be the restricting criteria, also can be specified. The output will
be displayed in simple report format.
Along with the report, it will also
notify the user whether Primary / Secondary index is being used or not during
In production system, there can be two ways of checking data
from standard table / Custom table.
The following section will briefly describe what are the
steps followed to check data using Conventional method:
Run transaction SE16 & put
table name as selection criteria.
Choose the fields which will be the selection criteria for
data selection from settings > Fields for selection
Put the selection criteria:
Report will be displayed in the following format:
Choose the desired output fields from Settings > Format
list > Choose Fields.
final report will be displayed:
Number of entries in the table can also be checked using SE16
Whether the data selection is done using primary / secondary
index can also be checked using transaction SE11 / ST05.
Dynamitic select statements
this method we have written a program, which will take selection criteria
dynamically (Table name, filter criteria, display fields) and produce a report
with single user intervention. It will also display whether primary / secondary
index is being used or not during data selection.
the report ZDYN_ALV (for source code, click here).
the field names for the selection criteria.
the selection criteria as below.
The output will be shown in the below format.
This program will display data in a single step execution. When we are trying to access live system from remote location each step execution (Dialog step) is very time expensive. This program will reduce the steps taken to display desired data. Also it will analyze the particular select statement is optimized or not by specifying the Index.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards