topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Wed, 21 Jan 2009 04:38:07 GMT

HI Experts,

My issue is i need to select data from marc table.

Example:

select matnr prctr from marc into corresponding fields of table it_marc

where matnr in so_matnr and

prctr is not initial. <----

My issue is i need to make sure prctr field dont have any value during my selection.

Thank you very much.

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:41:00 GMT

Try this....

select matnr prctr from marc into corresponding fields of table it_marc

where matnr in so_matnr and

prctr NE ' ' .

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:43:14 GMT

Hi Saravannan

select matnr prctr from marc into corresponding fields of table it_marc

where matnr in so_matnr and

prctr is not initial. <----

You can use...

SELECT matnr prctr FROM marc

INTO TABLE it_marc

WHERE matnr IN so_matnr

AND prctr eq ' ' .

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:44:51 GMT

Hi,


> HI Experts,
> My issue is i need to select data from marc table.
> Example:
> 
> select matnr prctr from marc into corresponding fields of table it_marc 
> where matnr in so_matnr and
>          prctr is not initial.       <----
> 
> My issue is i need to make sure prctr field dont have any value during my selection.
> 
> Thank you very much.

in select query you mentioned prctr is not initial,and you are saying it should not contain any value during the selection.

i didnt get you, can you explain?

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:49:07 GMT

Hi,

First collect data with check PRCTR. Next use read itab check PRCTR <> ' '.and move other internal table.

Regards

Md.MahaboobKhan

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:49:38 GMT

select matnr prctr from marc

into corresponding fields of table it_marc

where matnr in so_matnr and

prctr EQ SPACE .

Re: Select Statement

Former Member — Wed, 21 Jan 2009 04:50:45 GMT

Thanks a lot friends.i managed to solved that.