problem with SELECT SINGLE *

[Former Member]

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

[Former Member]

Try:

versn = '001' 

Rob

[Former Member]

Hi Niru,

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

Regards,

Atish

[Former Member]

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.