Skip to Content
0
Former Member
May 03, 2014 at 10:00 AM

Query Approval not executing

54 Views

Dear All

Stuck at query approval:

SELECT DISTINCT 'TRUE' FROM POR1 INNER JOIN OITM ON POR1.ItemCode = OITM.ItemCode INNER JOIN OITB ON OITM.ItmsGrpCod = OITB.ItmsGrpCod

Where POR1.DocEntry = $[OPOR.Docentry]

Group By OITB.U_POLimit

HAVING OITB.U_POLimit < Sum(POR1.GTotal)

Value is coming properly in sap query manager but approval is not executing at the time of transaction