how to list the user defined function in db in sap b1

[Former Member]

Hi Experts,

What is the sql query for displaying the list of user defined function in DB.

kindly tell this.

thanks

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query:

SELECT * FROM CUFD

Thank you.

[Former Member · Accepted solution]

Thanks . I am getting this. How to know all these query . Please suggest some study material for sql queries

[kothandaraman_nagarajan · Accepted solution]

Ways to learn SQL:

1. Create simple query in query generator.

2. Understand relationship between tables.

Please buy this book to learn SQL queries for B1:

Mastering SQL Queries for SAP Business One | PACKT Books

[Former Member]

Hi Kumar,

here is the below query.

in below query where condition depends on hana and MSSQL database.

there is a type column in MSSQL and OBJECT_TYPE in hana.

You can have where condition with below query.

SELECT * from sys.objects

a sample query for hana is written below.

SELECT * from sys.objects where "OBJECT_TYPE"='FUNCTION'

In MSSQL values for type coulmn for function are

FN = SQL scalar function

FS = Assembly (CLR) scalar-function

FT = Assembly (CLR) table-valued function

IF = SQL inline table-valued function

Regards

khagesh

[Former Member]

Hi friends,

I want this these fields to be needed . I am begineer , so iam asking.

using sap b1 9.0 using ssms V12

you have query for this