topic problem with SELECT SINGLE * in Application Development and Automation Discussions

problem with SELECT SINGLE *

Former Member — Tue, 23 Oct 2007 19:57:04 GMT

Hi experts,

SELECT SINGLE * FROM cosp WHERE objnr = g_objnr AND

gjahr = p_gjahr AND

wrttp = '01' AND

versn = p_ver AND

vrgng = 'RKP1'.

IF sy-subrc = 0.

if the values of

gjahr = KS500081A650

wrttp = '01'

versn = 'N0'

vrgng = 'RKP1'.

there are 18 recors exist in table 'cosp' then sysbrc= 0. its wrking fine

but if change verision versn = '01' then check in table 'cosp' there are 31 records exits but my select query not selecting any record and sy-subrc <> 0.

please tell me what is the reason?

regards

niru

Re: problem with SELECT SINGLE *

Former Member — Tue, 23 Oct 2007 20:00:12 GMT

Try:

versn = '001'

Rob

Re: problem with SELECT SINGLE *

Former Member — Tue, 23 Oct 2007 20:01:33 GMT

Hi Niru,

There must be something wrong in your analysis.Onc again check entries in table.

Regards,

Atish

Re: problem with SELECT SINGLE *

Former Member — Tue, 23 Oct 2007 20:03:20 GMT

Neeru,

The data element VERSN is of length. So as Rob suggested try


SELECT SINGLE * FROM cosp WHERE objnr = g_objnr AND
gjahr = p_gjahr AND
wrttp = '01' AND
versn = '001' AND
vrgng = 'RKP1'.

Regards

Aneesh.