SQ01

[Former Member]

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..

[Former Member]

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..

[Former Member]

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

[Former Member]

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

[Former Member]

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.