topic SQL Query Modification in Application Development and Automation Discussions

SQL Query Modification

Former Member — Sat, 07 Feb 2009 11:48:45 GMT

Hi ,

I have created a SQL query using SQVI.

But I need to write some additional conditions in the logic which are not possible through SQVI / SQ01.

Therefore I am wondering ......

if we have some functionality where we can add my own logic/conditions in the SQL program generated by Std SAP.

Also I would appreciate if you could let me know the difference between SQVI and SQ01 and how to conver a SQL query to transaction code.

Regards

Shrey

Re: SQL Query Modification

Former Member — Sat, 07 Feb 2009 11:58:48 GMT

Hi,

Check With this link.

thanks,

Neelima.

Re: SQL Query Modification

Former Member — Sat, 07 Feb 2009 12:41:11 GMT

Thx for your reply .... but I am some different query.

I have created a SQL query using SQVI.

The purpose of this query was to extract data from two tables.The query is working fine , till the time linked data is available is both tables

I am giving below example to explain my problem. I have two tables A and B with below fields

Table A

S.No

Student Name

Class

Table B

S.No

Teacher name

Education

both the tables are are linked thru common S.No field in my query and I am extracting data fields ,

S.No | Student Name| Class | Teacher Name

My Query is working fine till the time data record of respective S.No is available in both the tables. But there are cases when data is only available in TABLE A, such cases are not being extract through my SQL query.

Therefore i wanted to change the PROGRAM of my SQL query so that system should extract the data even when data is available in ONE TABLE only.

Therefore , is it possible to change the program generated by SAP through my SQL Query (SQVI) or this can only be achieved through a T.Code ?

If It is possible thru SQVI , then how should be proceed ?

Sorry for asking such a foolish query.

Regards

Shrey

Re: SQL Query Modification

SantoshKallem — Sun, 08 Feb 2009 06:54:28 GMT

Copy the generated program into z/y program and chage the required.

Regards,

santosh

Re: SQL Query Modification

Former Member — Tue, 17 Feb 2009 06:50:29 GMT

thx