SQL Query Modification

[Former Member]

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

[Former Member]

Hi,

Check With this link.

thanks,

Neelima.

[Former Member]

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

[SantoshKallem]

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

Regards,

santosh

[Former Member]

thx