on 01-23-2013 2:40 AM
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
Hi John,
Include from clause in your query.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
User | Count |
---|---|
95 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.