Select Statement

[Former Member]

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.

[Former Member]

Hi

Try this....

select matnr prctr from marc into corresponding fields of table it_marc

where matnr in so_matnr and

prctr NE ' ' .

[Former Member]

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 ' ' .

[Former Member]

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?

[Former Member]

Hi,

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

Regards

Md.MahaboobKhan

[Former Member]

select matnr prctr from marc

into corresponding fields of table it_marc

where matnr in so_matnr and

prctr EQ SPACE .

[Former Member]

Thanks a lot friends.i managed to solved that.