Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formatted Search Numbering Wildcards

I've seen lots of numbers used in formatted search queries on these forums, and it looks like they are used as wildcards (as mentioned below) so that a single query can be used for all marketing documents for instance. Is there a list somewhere that shows which numbers correspond to which tables and fields?

"Note!!! You can replace the $[ORDR.CARDCODE] string (in the query) with the $[$-4.0.0] string, and the $[ORDR.NUMATCARD] string with $[$-14.0.0] string. Using these alternative strings will enable SAP Business One users to activate this query in other marketing documents, by changing only the name of the related table."

My specific question involves a UDF. I have a row level UDF in my marketing documents called "OrderType", which lets us specify if it is a Normal order, Sample order or a Service order. Depending on which is selected, my formatted search automatically changes the G/L Account field and COGS Account field on the same row. Can I use a single query for all marketing documents instead of having one for each table? Below is my query that is currently functional for sales orders.

SELECT 
  CASE $[RDR1.U_OrderType] 
    WHEN 'Normal' THEN 5000
    WHEN 'Sample' THEN 6125
    WHEN 'Service' THEN 5803
  END $[RDR1.U_OrderType] 
FROM RDR1 FOR BROWSE

Former Member
Former Member replied

As long as you do not include any table names in your query, it applies to all your marketing documnets. You can find this info by View - System Information.

Actually, you should create another UDF in the item master. The UDF in all your Marketing Row levels will get this info.

Your query will looks like:

SELECT 
  CASE $[$38.U_OrderType.0] 
    WHEN 'Normal' THEN 5000
    WHEN 'Sample' THEN 6125
    WHEN 'Service' THEN 5803
  END

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question