topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Tue, 10 Jul 2007 13:39:58 GMT

Hi all,

select objnr

kokrs

belnr

from covp

into table it_covp

where objnr = 'PR*'

here i need to select entries from COVP Table with objnr starting with PR

could any one suggest best way of doing this.

if use pattern its giving error.

Thanks in advance.

Re: Select statement

Former Member — Tue, 10 Jul 2007 14:00:44 GMT

Hi Sarala,

it should work with:

Select objnr kokrs belnr

from covp

into table it_covp

where objnr like 'PR%'.

Regards

Nicola

Re: Select statement

Former Member — Tue, 10 Jul 2007 14:07:32 GMT

select objnr

kokrs

belnr

from covp

into table it_covp

where objnr LIKE 'PR%'

Regards,

A.Singh

Re: Select statement

Former Member — Tue, 10 Jul 2007 14:26:32 GMT

Thank you.