Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inward / Outward Register

Hi All,

We want GOODS INWARD AND OUTWARD REPORT IN FOLLOWING FORMAT.

INWARD

DATE PARTY INV NO# PRODUCT QTY TOTAL CARTONS TRANSPORTER

SAME FOR OUTWARD

IN ORDER TO CREATE THE REPORT I CREATED A PACKAGING LIST IN TEST DB ON DELIVERY.

AND TRIED FOLLOWING QUERY BUT IT IS NOT GIVING ME THE DESIRED RESULT.

SELECT I0.DOCDATE , I0.CARDNAME , I0.DOCNUM , I1.DSCRIPTION , SUM(D3.QUANTITY) , COUNT(D2.PACKAGENUM) , D2.PACKAGETYP

FROM OINV I0 INNER JOIN INV1 I1 ON I0.DOCENTRY = I1.DOCENTRY

LEFT OUTER JOIN ODLN D0 ON I1.BASEENTRY = D0.DOCENTRY

INNER JOIN DLN1 D1 ON D0.DOCENTRY = D1.DOCENTRY

INNER JOIN NNM1 S0 ON I0.SERIES - S0.SERIES

INNER JOIN NNM1 S1 ON D0.SERIES = S1.SERIES

LEFT OUTER JOIN DLN7 D2 ON D0.DOCENTRY = D2.DOCENTRY

INNER JOIN DLN8 D3 ON D2.DOCENTRY = D3.DOCENTRY

GROUP BY I0.DOCDATE , I0.CARDNAME , I0.DOCNUM , I1.DSCRIPTION , D2.PACKAGETYP

PLEASE HELP ME IN THIS QUERY

THANKS

MALHAAR

Former Member
Not what you were looking for? View more on this topic or Ask a question