Skip to Content
avatar image
Former Member

Need to link Lot Number with Delivery Note

Hi Experts

I need to attach lot number in delivery note print out, so can any one give me a querry to link lot number related or connected to the same Delivery note

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 27, 2017 at 06:26 AM

    Hi experts

    i got he solution, and its working

    select DISTINCT ODLN.DocNum,DLN1.ItemCode,DLN1.Dscription,OSRN.LotNumber from ODLN inner join DLN1 on ODLN.DocEntry = DLN1.DocEntry LEFT JOIN OSRN ON DLN1.ItemCode = OSRN.ItemCode

    Thanks for all support

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • May 24, 2017 at 07:34 PM

    Check OITL for DocEntry = YOURDOCENTRY and DOCTYPE = 15

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Danio

      Thanks for the support , can u pls give it as a query, as am not much exp in sql

      regards

  • May 26, 2017 at 01:17 PM

    Hi,

    Please check this thread https://archive.sap.com/discussions/thread/3678226

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded