Need to link Lot Number with Delivery Note

[Former Member]

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

[Former Member · Accepted solution]

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

[kothandaraman_nagarajan]

Hi,

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

Regards,

Nagarajan

[Former Member]

Help full

[former_member233854]

Check OITL for DocEntry = YOURDOCENTRY and DOCTYPE = 15

[Former Member]

Dear Danio

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

regards