urgent , abap select statement error VBPA ...

[Former Member]

hi gurus,

please tell me what is the wrong in the following select statment:

it returns 4 dispite that the data is there in the table VBPA

like this :

VBPA

****************************************

Cl. : 200

Document : 0010002449

Item :

Funct : PE

Pers.No. : 100820

*********************************************

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ '0010002449'

and kunnr EQ 'PE'.

[Former Member]

.

[Former Member]

HI,

I think yuo need to change the code as below :

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ '0010002449'

and kunnr = '100820'.

Thanks,

Sriram Ponna.

[Former Member]

.

[George_Lioumis]

Hi, check this:

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ '0010002449'

and parvw EQ 'PE'

Regards,

George

[Former Member]

hi

good

wrong one ->

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ '0010002449'

and kunnr EQ 'PE'.

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ 0010002449

and kunnr EQ PE.

change like this and check the difference.

thanks

mrutyun^