topic SQ01 in Application Development and Automation Discussions

SQ01

Former Member — Fri, 02 Jan 2009 05:22:02 GMT

Hi all,

I want to create infoset by using sq02 with 3 table : mara , mard , makt.

where i want to put condition using hardcode the value how is this posible.

because , it gives me all table from mara.

plz help me..

Re: SQ01

Former Member — Fri, 02 Jan 2009 05:28:38 GMT

Hi Ankita.

One there is an option in SQ02 where you can write your program line.

but i will suggest you is take the fields that you want to hardcode in Selection list and then assign a selection variant where you can give values to input variables.

this way you report can be saved from any hardcoding actvity, also it can be used for other purpose also

Regards,

Gaurav

Re: SQ01

Former Member — Fri, 02 Jan 2009 05:29:02 GMT

Hi,

for a query whatever code you want to write, everything will done in the Infoset only.

after entering 'SQ02' provide the infoset name and click on change button, it will navigate to next screen.

in this u can see the buttons 'EXTRAS, SELECTIONS, CODE, ENHANCEMENTS' in application tool bar.

by pressing CODE button it opens an editor, here you can write the condition whatever u wnat.

Kindly let me know if u need any further help!!

Hope it helps for ur Question!!!

Regards,

Pavan

Re: SQ01

Former Member — Fri, 02 Jan 2009 05:54:45 GMT

Hi Vishnu,

But output is not according what i want, it is not considering the condition value..

code id like..

select mara_{matnr mard}werks mard~lgort

into (mara-matnr,mard-werks,mard-lgort)

from mara

inner join mard on mard_{matnr = mara}matnr

where mara~spart = '90'.

endselect.

Plz help me.