Production Order Batch Details Query

[Former Member]

Hi,

I need  a Query which should show in a Production Order the Finished  Product used and the batch and quantity for that product which was received . When I see the system information for receipt from production it is showing one table RITL but it is not showing in the Table List.Can somebody help in making this Query?

Thanks and Regards,

S.G.Sekar

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query:

SELECT T0.[ItemCode], T0.[ItemName], T0.[Quantity], T0.[BatchNum], T0.[CreateDate] FROM IBT1 T0 WHERE T0.[Direction]  = 0 and  T0.[BaseType] =59 and  T0.[BsDocType]  =202 and  T0.[ItemCode]  = [%0] GROUP BY T0.[ItemCode], T0.[ItemName], T0.[Quantity], T0.[BatchNum], T0.[CreateDate]

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagaraj,

This Query is OK but I want the Production order No. in the Query.Is it possible?

Thanks and Regards,

S.G.Sekar

[KennedyT21 · Accepted solution]

Hi Gamaliel Sekar

Try This

SELECT T0.[ItemCode], T0.[ItemName], T0.[Quantity], T0.[BatchNum], T0.[CreateDate] ,

BaseEntry, BaseNum, BaseLinNum

FROM IBT1 T0

WHERE T0.[Direction]  = 0 and  T0.[BaseType] =59 and  T0.[BsDocType]  =202

and  T0.[ItemCode]  = [%0]

Regards

Kennedy

[kothandaraman_nagarajan · Accepted solution]

Hi,

You can try with OINM and IGE1 table to get production order number. But you may not get batch number.

Since there is no direct link between IBT1 and OWOR.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

RSRN,RBTN,RITL,SBDR tables are virtual tables that are not displayed in query generator.

Let me try to create query as per above.

Thanks & Regards,

Nagarajan