Query for Authorization

[Former Member]

Hi Experts,

I would like to ask help to create a query for authorization, I have two approver which will aprrove inventory documents that will be triggered when satifies the query if the item is set to property 20 it will be approve by approver B if not the approver A will be the approver.

Here's my query for approver B: for approver template B

SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END

and for approver A: for approver tempale A

SELECT CASE WHEN Qrygroup20='N' THEN 'TRUE' ELSE 'FALSE' END

But it  doesn't work.

Regards,

Lean

[kothandaraman_nagarajan]

Hi John,

Include from clause in your query.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan,

Should it be SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END FROM OITM?

Thanks

[Former Member]

Hi Nagarajan,

Should it be SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END FROM OITM?

Thanks

[KennedyT21]

Hi John...

Here's my query for approver B: for approver template B

SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END

and for approver A: for approver tempale A

SELECT CASE WHEN Qrygroup20='N' THEN 'TRUE' ELSE 'FALSE' END

If both are seperate process why you need case

try with simple query

Select True from oitm where Qrygroup20='Y'

Correct me if am worng

Regards

Kennedy

[Former Member]

Hi Kennedy,

I used your query but still there's an error.

Regards,

Lean

[kothandaraman_nagarajan]

Hi John,

Paste the  error here.

[Former Member]

Hi Nagaran,

Here's the error message upon adding good receipt:

"Could not commit transaction: Error -1 detected during transaction"

But when I use SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END FROM OITM it seems that the approval is not working. Cause i can add the GR.

Regards,

Lean

[kothandaraman_nagarajan]

Hi John,

Please check with this SAP notes:

1570031 - Not able to update User-Defined Values

Symptom

There are many User-Defined Values(Formatted Search) configured in your
company database. When trying to update one of them, the error message below is
shown: Could not commit transaction: Error -1 detected during
transaction.

Cause

Application error.

Solution

SAP intends to provide a patch or patches in order to solve the problem
described.
The section Reference to Related Notes below will
list the specific patches once they become available.
The
corresponding Info file of the patches in SAP Service
Marketplace will also show the SAP Note number.
Be aware that these
references can only be set at patch release date.
SAP will deliver patches
only for selected releases at its own discretion, based on the business impact
and the complexity of the implementation

Hope helpful.

[Former Member]

Hi Naga Rajan,

Thanks for that, the SAP B1 version 8.8 PL11.

So what workaround you can suggest to me for my approval?

Regards,
Lean