topic Re: problem in selection in Application Development and Automation Discussions

problem in selection

Former Member — Mon, 19 Feb 2007 12:11:44 GMT

Hi all,

i am using the folowing select query.

SELECT VBELN POSNR PS_PSP_PNR FROM VBRP INTO CORRESPONDING FIELDS OF TABLE IT_VBRP

FOR ALL ENTRIES IN IT_ZDN3 WHERE VBELN = IT_ZDN3-INVNO.

vbrp contains diff value of ps_psp_pnr for vbeln but the data that is getting selecting

in it_vbrp has diff value of ps_psp_pnr.

plz reply soon, its urgent

thnx

Re: problem in selection

Former Member — Mon, 19 Feb 2007 12:16:54 GMT

Hi,

VBRP has both vbeln and POSNR as key fields use both and retrieve data.

nake sure that u r comparing teh correct fields of IT_ZDN3 against VBELN adn POSNR.

SELECT VBELN POSNR PS_PSP_PNR 
              FROM VBRP
              INTO CORRESPONDING 
              FIELDS OF TABLE IT_VBRP
              FOR ALL ENTRIES IN IT_ZDN3 
             WHERE VBELN = IT_ZDN3-INVNO.
             AND   POSNR = it_zdn3-????

Re: problem in selection

Former Member — Mon, 19 Feb 2007 12:32:00 GMT

same prb is occuring even after taking posnr in select statement

Re: problem in selection

Former Member — Mon, 19 Feb 2007 12:42:33 GMT

Provide me the code for the structure IT_ZDN3.