topic select data from tables in Application Development and Automation Discussions

select data from tables

Former Member — Thu, 11 Dec 2008 10:14:22 GMT

Hi,

this is basic question but iam confusing.

in my selection contains two fields like matnr and werks.

if user give matnr only i will get all matnrs.

if user give matnr and werks i need matnr no's based on werks.

how can i write select statement based on mara and marc.

Regards,

Suresh.

Re: select data from tables

Former Member — Thu, 11 Dec 2008 10:15:41 GMT

search sdn with <select ... For all entries>

or even an F1 wud do.

Edited by: kartik tarla on Dec 11, 2008 3:45 PM

Re: select data from tables

GauthamV — Thu, 11 Dec 2008 10:16:11 GMT

select matnr werks from marc into table itab

where matnr in s_matnr and werks in s_werks.

Re: select data from tables

Former Member — Thu, 11 Dec 2008 10:16:42 GMT

hi,

Concatenate % sign at end of both matnr and werks.

write the selection statement as below.

select * from <tab-name> into table <itab>

where matnr like v_matnr

and werks like v_werks

Hope this helps,

Rajat

Re: select data from tables

former_member203501 — Thu, 11 Dec 2008 10:20:17 GMT

hi do like this ..

if p_matnr is not initial .

select matnr from marc into table itab where matnr = p_matnr .

elseif p_matnr is initial and p_werks is not initial.

select matnr

werks

from marc

into table itab1

where matnr = p_matnr

and werks = p_werks .

endif.

Re: select data from tables

Former Member — Thu, 11 Dec 2008 10:20:19 GMT

Hi,

For this when u enter only matnr details in select-options u get only matnrs.

so for select-option put if condition.

like this..

If s_matnr is not intitial .

select.....

endif.

if s_matnr is not intial and s_werks is not initial

select matnr werks......

endif.

for output printing also u use same if condition for both...

Try this....

Re: select data from tables

Former Member — Thu, 11 Dec 2008 10:20:39 GMT

This message was moderated.

Re: select data from tables

Former Member — Thu, 11 Dec 2008 11:38:41 GMT

Hi Suresh,

The following query may help you.

Here select option is used for both matnr and werks.

SELECT a~matnr
    INTO TABLE int_tab
    FROM mara AS a INNER JOIN marc AS b
    ON a~matnr = b~matnr
    WHERE a~matnr IN so_matnr AND
          b~werks IN so_werks.

Regards,

Manoj Kumar P

Edited by: Manoj Kumar on Dec 11, 2008 12:41 PM

Re: select data from tables

Former Member — Thu, 11 Dec 2008 15:03:58 GMT

Hi,

Select matnr werks from table name

where matnr in s_matnr

and werks in s_werks.

Thanks,

Krishna...