udf , fms

[former_member211473]

hello experts ,

i need a help, i created  2 header level udf in marketing document .1> name  2> title.  Name is for Employee Master Data First Name. and Title is for job title of that particular employee    .. i need fms query for selecting name of employee  and then in 2nd udf job title of that employee should automatically come based on employee name that i select in first udf. my sql query is working but not in udfs.

Thanks

[Former Member · Accepted solution]

Hi Ranu,

Can u post your query here

Regards,

Bhushan Verma

[former_member211473 · Accepted solution]

to select first name

" SELECT T0.[firstName] FROM OHEM T0" 

   and for  job title

" SELECT t0.jobTitle, t0.firstName from ohem t0 inner join oqut a ON t0.empID = a.OwnerCode where t0.firstname=  name field(udf) in marketting document.

but here i have to mention owner name , in marketting document , then it shows all job title

[former_member212181 · Accepted solution]

Hi Ranu Vijay,

If your main source to get Employee first name and Job title is Document Owner, then you can try below queries for Formatted search.

----First Name

Select FirstName from OHEM Where (LastName+ ', ' +FirstName) = $[$222.0.0]

----Job Title and First Name

Select JobTitle,FirstName from OHEM Where (LastName+ ', ' +FirstName) = $[$222.0.0]

Thanks

Unnikrishnan

[former_member211473 · Accepted solution]

Thanks Unnikrishnan

your query is working fine for row level udfs ,for header level it is showing internal error 3006.

I was trying for header level , can u help me out.

[former_member212181 · Accepted solution]

It is working in both header and row level in my system.

Please try one thing.

Assign same query in remarks field(SAP Standard remarks field) and let me know the results.

Thanks

Unnikrishnan

[former_member211473 · Accepted solution]

It is working in remarks field..

[former_member212181 · Accepted solution]

Then the issue is not with the query, but with the UDF field type.

Is those UDF's have sufficient strength to take this results in??

I mean Alphanumeric, Length etc.

Thanks

Unnikrishnan

[former_member211473 · Accepted solution]

applying "-" sign before 222 solved my problem thanks ..$[$-222.0.0] .. i read somewhere  - sign is required for header level udf.

THANKS UNNIKRISHNAN