problem in selection

[Former Member]

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

[Former Member]

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-????

[Former Member]

same prb is occuring even after taking posnr in select statement

[Former Member]

Provide me the code for the structure IT_ZDN3.