Question Re: Sap business one hana query approval in Enterprise Resource Planning Q&A

Sap business one hana query approval

Alagasan — Tue, 21 Sep 2021 16:20:21 GMT

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

Re: Sap business one hana query approval

former_member751591 — Tue, 21 Sep 2021 16:20:40 GMT

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.

Re: Sap business one hana query approval

kothandaraman_nagarajan — Wed, 22 Sep 2021 09:50:06 GMT

Hi,

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

Regards,

Nagarajan

Re: Sap business one hana query approval

Alagasan — Sat, 25 Sep 2021 09:50:01 GMT

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

Re: Sap business one hana query approval

kothandaraman_nagarajan — Mon, 27 Sep 2021 10:08:41 GMT

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

Re: Sap business one hana query approval

user2001 — Mon, 26 May 2025 11:43:52 GMT

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