two select options

[Former Member]

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]

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

[Former Member]

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

Message was edited by: Aadarsh K

[Vinod_Chandran]

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