topic using sq01 in Application Development and Automation Discussions

using sq01

Former Member — Tue, 17 Apr 2007 09:05:08 GMT

hi,

how can u use where conditions in sq01?? where do u write the sql statements?

i created the info sets and usergroups and basic query.. but didnt find a place to write the sql statements for more advance queries? ANy help is appreciated

Thanks

keshi

Re: using sq01

Former Member — Tue, 17 Apr 2007 09:11:43 GMT

Hi,

No need to write any code

Link the tables using Join Conditions as per the key fields that are linked together for the two tables.

Similarly join each and every table with another.

Select the fields from the infosets for output.

reward if useful

regards,

Anji

Re: using sq01

Former Member — Tue, 17 Apr 2007 09:18:20 GMT

keshini,

You can write sql statements under the event" RECORD PROCESSING".

You can write sql statement under the event START-OF-SELECTION.

what ever you are selecting the tables for query those will joined internally as inner join under the record processing event as loop.

One by one record will get process under "RECORD PROCESSING"

So if you want to check or validate any field you can write here.Here al the output data will be taken care by system itself in ALV GRID.

START-OF-SELECTION.

Here you can write all the code as in ABAP Editor .

Don't forget ot reward if useful...

here you