topic Re: SELECTING DATA FROM TABLE in Application Development and Automation Discussions

SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 07:54:54 GMT

Hi all,

I have a doubt.

example. select * from mara where matnr = 1234 and werks = ' * ' . where werks i want to keep werks * ie any value how to do it.

I have to use werks field. can i use just %.

Kindly help .

thanks

mahesh

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 07:59:33 GMT

Hi,

In that case don't use werks in select query.Just query the table on matnr.

in this case it will fetches the material in different locations.

Thanks,CSR.

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 08:01:15 GMT

use like this

select * from mara where matnr = '1234'.

this will solve ur problem

Re: SELECTING DATA FROM TABLE

former_member404244 — Fri, 02 Nov 2007 08:03:39 GMT

Hi,

In mara table there is no werks use marc table and try like this

select * from marc where matnr = '1234' .

Reward if helpful

Regards,

Nagaraj

Re: SELECTING DATA FROM TABLE

former_member386202 — Fri, 02 Nov 2007 08:04:45 GMT

Hi,

Do like this

select * from mara where matnr = 1234. No need to give the werks in where condition.

Reagrds,

Prashant

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 08:09:22 GMT

HI THERE,

IF YOU WANT TO SELECT ANY PLANT THEN NO NEED TO USE IT IN THE QUERY. AND BE AWARE THAT YOU DON'T HAVE WERKS FIELD IN MARA TABLE YOU HAVE TO SELECT THAT FROM MARC TABLE.

REGARDS

THARANATHA

Re: SELECTING DATA FROM TABLE

Nawanandana — Fri, 02 Nov 2007 08:13:24 GMT

hai

data: m_mara type mara.

SELECT * FROM mara

INTO TABLE m_mara

WHERE matnr = '1234'.

i think u can help

regard

nawa

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 08:49:47 GMT

hI ALL,

but my requirement is matnr = 1234 and the werks field for example if it is H101 in the begining if sy-subrc NE 0 i will keep reducing in this manner

h10%

h1&

% untill all characters are searched in the table .My question is finally for any plant is there any option such as * or %.

thanks ,

mahesh

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 18:51:12 GMT

As Nagaraj stated aboev, WERKS is not a field in the MARA Table. Why Query for WERKS? What are requirements and what are your trying to accomplish with your results?

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 18:59:23 GMT

in mara table u wont find werks.....

u will find it marc table....

select a_{matnr b}werks from mara as a join marc as b on b_{matnr = a}matnr

whwre a~matnr = '1234' and werks = '1%'.

it will retrive the data from mara and marc which the material number is 1234 and werks that start with 1.....

Re: SELECTING DATA FROM TABLE

Former Member — Fri, 02 Nov 2007 19:01:37 GMT

Hello Mahesh,

Your query, "select * from mara where matnr = 1234 and werks = ' * ' .", won't fetch any data since MARA doesn't have WERKS field.

Instead you need to write like this "<b>select * from MARC where matnr = 1234"</b>" this will fetch all the data for all Plants for which MATNR = 1234

Hope this will be useful

Kindly reward points if it helps.

Regards

Sujay

Re: SELECTING DATA FROM TABLE

former_member194669 — Fri, 02 Nov 2007 19:06:36 GMT

Hi,

Try this way


  data : v_like(4) type c.
  concatenate 'H__%' space into v_like.
      select * from marc into table i_marc
         where matnr eq '1234'
           and werks like v_like.

a®