QUERY

Former Member — Tue, 05 Sep 2006 10:38:09 GMT

hi friends

plz help me how to fetch data with below information

Get LFIMG (actual quantity) from LIPS where [LIPS-MATNR (material number)= VBAP-MATNR and LIPS-VGBEL&LIPS-VGPOS=VBAP-VBELN&VBAP-POSNR and VBFA-VBTYP_N=”J” (document category)] and [VBUP-WBSTA ne “C” (goods movement status) where VBUP-VBELN&VBUP-POSNR=VBAP-VBELN&VBAP-POSNR].

regards,

divya

Re: QUERY

Former Member — Tue, 05 Sep 2006 10:51:36 GMT

SELECT LIPS~LFIMG

FROM VBAP INNER JOIN LIPS ON VBAP_{VBELN = LIPS}VGBEL

AND VBAP_{POSNR = LIPS}VGPOS

INNER JOIN VBFA ON VBAP_{VBELN = VBFA}VBELV

AND VBAP_{POSNR = VBFA}POSNV

INNER JOIN VBUP ON VBAP_{VBELN = VBUP}VBELN

AND VBAP_{POSNR = VBUP}POSNR

WHERE VBAP_{MATNR = LIPS}MATNR

AND VBFA~VBTYP_N = 'J'

AND VBUP~WBSTA = 'C'.

topic Re: QUERY in Application Development and Automation Discussions

QUERY

Re: QUERY