Sap business one hana query approval

[Alagasan]

In purchase order based on the UDF filed needed approval query for sap business hana and SQL

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[kothandaraman_nagarajan · Accepted solution]

SELECT DISTINCT 'TRUE' FROM OPCH T0 WHERE $[OPCH.U_CHECKED] = 'S'

[kothandaraman_nagarajan]

Hi,

Share your approval condition with UDF details. For example, if your UDF is value set to Y, then need approval etc..

Regards,

Nagarajan

[Alagasan]

SELECT DocNum,CardName,NumAtCard,DocTotal FROM OPCH WHERE U_CHECKED='S'

[user2001]

I want to activate approval template only if drop down value is "PO".If it is "Good issue", I want to bypass approval.How can I do it