FMS does not Work, $[$4.0.0] replaced with *RSRC*ButtonCloseBox ?

[Former Member]

Hello Experts,

I use a simple FMS to get some info from BP (UDF). Target is another UDF on document. The FMS is:

select userfield from OCRD where cardcode=$[$4.0.0]

The FMS sometimes does not work. I checked it by running the FMS from menü, cursor in the UDF, and I saw that the system has replaced the

$[$4.0.0]

with RSRCButtonCloseBox. The is no such cardcode, and so the FMS does not gie any result. And there is no error.

Any idea ? Thanks

Edited by: Andreas Schlingmann on Jul 3, 2009 12:17 PM

Edited by: Andreas Schlingmann on Jul 3, 2009 12:19 PM

Edited by: Andreas Schlingmann on Jul 3, 2009 12:19 PM

[Former Member]

Hi,

When you are working with UDF for FMS You Should use like $[$-4.0.0]

Thanks and Regards,

NIvasini VM

Team Work Never Fails

[Former Member]

I know, but also -4 does not solve the problem.

I think it is a error in SAP. There are a lot of user fields in document, all with FMS from Cardcode. Some are working fine every time, 2 not. All FMS are same code.

Think I will add a message

[ulisescalderon]

This is the solution

[Former Member]

You may not run the FMS query in the query manager. If you run it this way, it indeeds replace the $ variable to something weird most of the time if the query did not get error message. FMS query is used for Formated Search only. You would be better to change your query as:

select T0.userfield from dbo.OCRD T0 where T0.cardcode=$[$4.0.0\]

Thanks,

Gordon