Select statement

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Sarala,

it should work with:

Select objnr kokrs belnr

from covp

into table it_covp

where objnr like 'PR%'.

Regards

Nicola

[Former Member]

select objnr

kokrs

belnr

from covp

into table it_covp

where objnr LIKE 'PR%'

Regards,

A.Singh

[Former Member]

Thank you.