Skip to Content
0
Former Member
May 13, 2009 at 07:34 AM

Goods Issue ./ Serial Number Report

312 Views

Guys,

I want to create a report which gives me the Goods Issue details with the items in the goods issue and Serial Numbers processed in those particular goods issues.

The problem is that with the following coding, it is returning all the Serial Numbers related to the particular item available in SAP and not only those relating to that particular Goods Issue. So if I have a quantity of 2 Serial Numbers for one item, it is not returning to Serial Numbers for that Goods Issue, but it is returning all Serial Numbers of the System under that Item.

I suspect that it is a JOIN problem, what do you think?

Coding is:

Select
				T0.DocDate as 'Goods Issue Date'
,				T0.DocNum as 'Goods Issue Reference'
,				T1.ItemCode as 'Item Code'
,				T1.Dscription as 'Item Description'
,				T2.IntrSerial as 'Serial Number'
,				T1.OcrCode as 'Cost Centre'
,				T1.LineTotal as 'Total Cost'
,				T1.U_eReasonCode as 'Reason Code'
,				T0.Comments as 'Remarks'


From
				OIGE T0 JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry
						LEFT OUTER JOIN OSRI T2 ON T1.ItemCode = T2.ItemCode


Order By
				T0.DocNum

Many thanks for your work everyone.

Regards,

Vankri