cancel
Showing results for 
Search instead for 
Did you mean: 

Merge queries in one query base on object type

Former Member
0 Kudos

I cretaed UDF in marketing document and linked it to following scripts:

in Godd recipt from PO :

SELECT T0.[U_NTX_ Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[PDN1.ItemCode]

In Good issue:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGE1.ItemCode]

in Good Transfer:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[WTR1.ItemCode]

In Good recipt:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGN1.ItemCode]

In porchase Orde:

SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[POR1.ItemCode]

I would like to merge this script in one query , how can I do it:??

Edited by: Farhadn on Apr 13, 2009 9:09 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try this one:

SELECT T0.U_NTX_Dsc FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0\]

Thanks,

Gordon

Former Member
0 Kudos

this works only in PO and Good recipt from PO, becasue their Item =38 but it did not work in Inventory transaction like good issue, good recipt and transfer

Edited by: Farhadn on Apr 13, 2009 9:45 PM

Former Member
0 Kudos

You are right. You need different query for inventory transaction. Even though it is possible by one logic:

SELECT T0.U_NTX_Dsc FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0\] or T0.ItemCode = $[$13.1.0\]

It may not be a good solution because the simpler the query, the better.

Former Member
0 Kudos

Thanks

It works by adding following sentence:

T0.ItemCode = $[$23.1.0] for inventory transfer

Answers (1)

Answers (1)

JesperB1
Advisor
Advisor
0 Kudos

Hi Farhadn,

Use UNION between each query.

I hope I understood the intention correctly.

Jesper