topic Re: urgent , abap select statement error VBPA ... in Application Development and Automation Discussions

urgent , abap select statement error VBPA ...

Former Member — Mon, 07 Jan 2008 14:48:38 GMT

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'.

Re: urgent , abap select statement error VBPA ...

Former Member — Mon, 07 Jan 2008 14:52:14 GMT

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.

Re: urgent , abap select statement error VBPA ...

Former Member — Mon, 07 Jan 2008 14:53:38 GMT

Re: urgent , abap select statement error VBPA ...

George_Lioumis — Mon, 07 Jan 2008 14:58:34 GMT

Hi, check this:

SELECT SINGLE

pernr

INTO w_pernr

FROM vbpa

WHERE VBELN EQ '0010002449'

and parvw EQ 'PE'

Regards,

George

Re: urgent , abap select statement error VBPA ...

Former Member — Mon, 07 Jan 2008 15:31:08 GMT

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^