Please validate my select stmt

[Former Member]

SELECT single bktxt from bkpf

INTO wa_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr

• AND ( bktxt+0(5) = 'ONPY'

• OR bktxt+0(5) = 'ONPO' )

What is wrong in my above stmt?

Thanks in advance

[suresh_datti]

the period is missing ie

SELECT single bktxt from bkpf

INTO wa_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr<b>.</b>

~Suresh

[Former Member]

data: lw_bktxt type bkpf-bktxt.

SELECT single bktxt from bkpf

INTO lw_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr.

Regards,

Prakash.

[Former Member]

hi Sam,

Except period i donot think there is any mistake in your select statement ..

SELECT single bktxt from bkpf

INTO wa_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr

• AND ( bktxt+0(5) = 'ONPY'

• OR bktxt+0(5) = 'ONPO' ).

Regards,

Santosh

[Former Member]

hi,

select did not end with a period.

Regards,

sailaja.

[Former Member]

Hi Sam,

The select statement is correct once the '.' is provided at the end. However if your select is not retreiving data then probably you need to run an Alpha routine to get the BELNR field in the excpected format.

Hope this helps.

Regards

[Former Member]

REALLY SORRY:

Please see below code which was commented before. I need them ....

SELECT single bktxt from bkpf

INTO wa_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr

AND ( bktxt+0(5) = 'ONPY'

OR bktxt+0(5) = 'ONPO' ).

What is wrong in my above stmt?

Thanks in advance

[Former Member]

SELECT single bktxt from bkpf

INTO wa_bktxt

where bukrs = lv_bukrs

AND belnr = lv_belnr

AND gjahr = lv_gjahr

AND <b>( bktxt like 'ONPY%'

OR bktxt like 'ONPO%' ).</b>

Regards,

Prakash.

[suresh_datti]

you cannot use offset in the where clause.. use pattersn ie the LIKE option..

SELECT single bktxt from bkpf
INTO wa_bktxt
where bukrs = lv_bukrs
AND belnr = lv_belnr
AND gjahr = lv_gjahr
AND ( bktxt like 'ONPY%'
OR bktxt like 'ONPO%' ).

~Suresh

[Former Member]

hi Sam

Use it like ...

SELECT single bktxt from bkpf
INTO wa_bktxt
where bukrs = lv_bukrs
  AND belnr = lv_belnr
  AND gjahr = lv_gjahr
  aNd ( <b>bktxt like 'ONPY%'
   OR bktxt like 'ONPO%' ).</b>

Regards,

Richa