topic Re: Please validate my select stmt in Application Development and Automation Discussions

Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:17:52 GMT

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

Re: Please validate my select stmt

suresh_datti — Tue, 26 Sep 2006 12:19:43 GMT

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

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:20:57 GMT

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.

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:21:57 GMT

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

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:22:54 GMT

hi,

select did not end with a period.

Regards,

sailaja.

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:23:53 GMT

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

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:24:55 GMT

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

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:27:06 GMT

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.

Re: Please validate my select stmt

suresh_datti — Tue, 26 Sep 2006 12:28:55 GMT

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

Re: Please validate my select stmt

Former Member — Tue, 26 Sep 2006 12:32:25 GMT

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