Skip to Content

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

Procudure for GR Data with Batch Detail

Hi Experts ,

I need a query which return the GRPO Data and the Batch no of the item Involved it .

Where parameter will be GRPO Docnum .

Thanks in advance



Try to start with this:

SELECT r.DocNum,r.DocDate,r.CardCode,r.CardName, 
 l.[ItemCode],l.ItemName,bb.DistNumber,  b.[Quantity],
 l.[DocType], l.[DocNum], l.[DocQty], --l.[DocEntry],
'Bt',  b.[Quantity], b.[AllocQty], b.[MdAbsEntry]
 Inner join OITL  l on l.DocType=20 and  l.DocEntry=r.DocEntry 
 inner join ITL1 b ON b.LogEntry = l.LogEntry
 inner join OBTN bb on b.MdAbsEntry=bb.AbsEntry
Where r.DocNum=[%0]

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question