APPROVAL PROCEDURE FOR DISCOUNT AT ROW LEVEL

[Former Member]

Dear Experts,

Please assist me set a query that triggers an approval procedure when discount at row level for an item group component exceeds a defined limit.

I have the following querywhich picks the discount violation at row level but it does not trigger the approval procedure

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DiscSum], T0.[GrosProfit], T1.[ItemCode], T1.[Quantity], T1.[DiscPrcnt], T2.[CstGrpCode], T2.[ItmsGrpCod] FROM [dbo].[OINV] T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T2.[ItmsGrpCod] = 104 and T1.[DiscPrcnt] >='0.2'

I have checked the following posts but am still in the dark.

I am using SB0 8.81 PL9.

Your assistance is appreciated.

George Njuguna

[Former Member · Accepted solution]

Dear George ,

An approval procedure will only work on document level or the first line. Do not waste your time for this.

Thanks,

Gordon

[Former Member]

You should check you user Discount % in general authorization setup because if it filled by 100 then SAP will not ask for any type of Approval.

And if your Client have statndard then setup in Approval setup using this (When the Following Applies) option.

have you try standard procedure in SAP ?

Try it and guide your client requirement in SAP is the best solution some time your question.

I think it will work according your requirement.

Thanks

Manvendra