topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Tue, 15 Jun 2010 05:43:40 GMT

hi all,

SELECT SINGLE bktxt "Document header text

FROM bkpf

INTO l_bktxt

WHERE bktxt = r_bktxt "Document header text - by user

and bukrs = c_comapny "Company Code

AND blart = 'PA' "Document Type

OR blart = 'PB'

OR blart = 'PC'

OR blart = 'PD'

OR blart = 'PE'

OR blart = 'PF'

OR blart = 'PH'

OR blart = 'CA'

OR blart = 'CB'

OR blart = 'CD'

OR blart = 'CE'

OR blart = 'CF'

OR blart = 'CK'

OR blart = 'CM'

OR blart = 'CN'.

i am checking the BKTXT against BKPF with r_bktxt, Whether it is there or not.

but the problem is, if the bktxt is not matched then it should not get any value.

but it is getting some other value matching with blart.

Please give me any suggestion.

Regards,

Sri

Re: Select statement

Former Member — Tue, 15 Jun 2010 05:53:29 GMT

Hi,

Try to use brackets in ur select querry as belwo.



SELECT SINGLE bktxt "Document header text
FROM bkpf INTO l_bktxt
WHERE bktxt = r_bktxt "Document header text - by user
and bukrs = c_comapny "Company Code
AND ( blart = 'PA' "Document Type
OR blart = 'PB'
OR blart = 'PC'
OR blart = 'PD'
OR blart = 'PE'
OR blart = 'PF'
OR blart = 'PH'
OR blart = 'CA'
OR blart = 'CB'
OR blart = 'CD'
OR blart = 'CE'
OR blart = 'CF'
OR blart = 'CK'
OR blart = 'CM'
OR blart = 'CN' )

Re: Select statement

syed_ibrahim5 — Tue, 15 Jun 2010 06:04:57 GMT

hi,

try to use IN ..


SELECT SINGLE bktxt "Document header text
FROM bkpf
INTO l_bktxt
WHERE bktxt = r_bktxt "Document header text - by user
and bukrs = c_comapny "Company Code
AND blart in ('PA','PB','PC','PD'.......).

regards,

syed

Re: Select statement

Former Member — Tue, 15 Jun 2010 06:29:35 GMT

Hi Sri,

you are checking multiple document type. so you have to mention in brackets. Pls try below code.

SELECT SINGLE bktxt "Document header text

FROM bkpf

INTO l_bktxt

WHERE bktxt = r_bktxt "Document header text - by user

and bukrs = c_comapny "Company Code

AND ( blart = 'PA' "Document Type

OR blart = 'PB'

OR blart = 'PC'

OR blart = 'PD'

OR blart = 'PE'

OR blart = 'PF'

OR blart = 'PH'

OR blart = 'CA'

OR blart = 'CB'

OR blart = 'CD'

OR blart = 'CE'

OR blart = 'CF'

OR blart = 'CK'

OR blart = 'CM'

OR blart = 'CN' ).

Rgds,

Arun