topic Re: two select options in Application Development and Automation Discussions

two select options

Former Member — Mon, 19 Sep 2005 07:54:26 GMT

hi to all,

can any one tell me hwo can i code for two select statements in one report.

thanks in advance.

raju

this post is closed

Message was edited by: mpr raju

Former Member — Mon, 19 Sep 2005 08:02:53 GMT

Your question is not clear . You can write as many select statements in your report ,

Former Member — Mon, 19 Sep 2005 08:03:12 GMT

Can you please tell the exact requirement ?? Your subject is on select-options

Message was edited by: Aadarsh K

Vinod_Chandran — Mon, 19 Sep 2005 08:03:36 GMT

Hi Raju,

You can write as many SELECT statement in your report. If you are talking about JOIN here is a sample code.

select mard_{matnr mard}werks

sum( mard_{labst ) sum( mard}insme ) sum( mard~speme )

sum( mard_{retme ) sum( mslb}lblab )

into table wt_mard

from mard as mard

left outer join mslb as mslb on mard_{matnr = mslb}matnr

and mard_{werks = mslb}werks

where mard~matnr in s_matnr

and mard~werks in s_werks

group by mard_{matnr mard}werks.

Thanks

Vinod