cancel
Showing results for 
Search instead for 
Did you mean: 

Inward / Outward Register

former_member218051
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member218051
Active Contributor
0 Kudos

Hi All,

Please help me to re frame this query. I'm badly stuck in this

Thanks

Malhaar

Former Member
0 Kudos

Hi Malhaar..........

For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.

This will give you proper details of what you expect. But this would be the data entry........

Regards,

Rahul

former_member218051
Active Contributor
0 Kudos

Hi Rahul,

I'm trying to use SAP's packaging list. and with the help of that i want to extract the details by framing a query.

I do not understand what you are trying to say.

Pls expalin.

Thanks

Malhaar

Former Member
0 Kudos

Hi Malhaar..........

For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.

This will give you proper details of what you expect. But this would be the data entry........

Regards,

Rahul

Former Member
0 Kudos

Hi Malhaar..........

For Inward and Outward Register you can have those details in UDO where you have to create the Fields in Sequenec order as you mentioned in your thread.

This will give you proper details of what you expect. But this would be the data entry........

Regards,

Rahul

former_member196081
Active Contributor
0 Kudos

hi,

which document you are using for inword and outword the quantity..

Regards

Deepak tyagi

former_member218051
Active Contributor
0 Kudos

Hi Deepak,

For inward we are referring Goods Receipt PO

and for outward we are referring Invoice

Thanks

Malhaar