QUERY

[Former Member]

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

[Former Member]

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

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