topic Query in Application Development and Automation Discussions

Query

Former Member — Wed, 14 Mar 2007 19:10:14 GMT

I am developing a query and want to select from a table with one particular field value. I created a parameter in infoset SQ02. How do I use the parameter? Where do I need to put in Query??

Thanks,

Re: Query

ferry_lianto — Wed, 14 Mar 2007 19:33:38 GMT

Hi AP,

I never work on SAP Query but please check this PDF document and link.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

http://help.sap.com/saphelp_47x200/helpdata/en/bf/1d4645bf3211d296000000e82de14a/frameset.htm

Hope this will help.

Regards,

Ferry Lianto

Re: Query

Former Member — Thu, 15 Mar 2007 12:15:15 GMT

Hi,

I hope u r goin for direct read from table ie using only one table.I suggest you to use select options instead of parameter in infoset,then it will work.

The steps are:

1.Create infoset with select-option and generateSQ02.

2.assign to user group SQ03.

3.create query for infoset SQ01.

Else.if you insist on single input...then do:

create infoset with the table.dont go for selections in it.just generate.

assign to user group.

create query..then use the 2nd button in app toolbar(Next screen F6).

select the function group -> go F6

select the input parameter -> go F6

check the input parameter ,save and now check 'SV'(Single input)

Now go to basic list button and do the layout

save and execute.

See its working or not?

Respond...

Anju

Re: Query

Former Member — Wed, 18 Apr 2007 10:42:37 GMT

Of course you could select data using that parameter or selection options of your own! You could get any data of any table and/or call functions, subroutines of another program etc. from infoset. You could also code inoset totally using "data retriaval by program" option.

Just create additional field in SQ02 (extras button) which have data type you want to select. Then in additional field code select data from table.

Ex. your additional field name is lv_additional and your parameter name is p_parameter and your table name is table.

code:

clear: lv_additional.

select single field into lv_additional from table where

field2 = p_parameter.