Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jul 19, 2011 at 08:47 AM

    hi,

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

    Regards

    Deepak tyagi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2011 at 08:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2011 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2011 at 09:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Jul 27, 2011 at 11:08 AM

    Hi All,

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

    Thanks

    Malhaar

    Add comment
    10|10000 characters needed characters exceeded