Skip to Content
author's profile photo Former Member
0
Former Member

Dynamic Sql Output

Posted on Jan 19, 2005 at 06:25 AM 11 Views

Dear All,

The user will write/enter a

sql query in the screen. The

program should give output of

that sql in the form of records/itab.

How can this be achieved ?

Thanks in advance.

Amit Mittal.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 07:36 AM
    0

    Hi,

    I wonder how you will carry out the syntax checks in this case. Any way, there are a couple of options available:

    1. Use statement GENERATE SUBROUTNE POOL to dynamically generate a transient program and obtain its output in your own program.

    2. The other way is that you can obtain column names, table name and where clause from the user in separate fields on screen and use them to construct an OpenSQL statement like <b>SELECT (fieldlist) FROM (tablename) INTO (targetarea) WHERE (whereclause)</b>.

    For both options, you can take a look at the document https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/advanced and generic programming in abap.pdf or TechEd session https://www.sdn.sap.com/sdn/elearning.sdn?class=/public/eclasses/teched04/ABAP351.htm> on generic programming.

    Hope this helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.