How to Make Formatted Search SAP Business One

How to Make Formatted Search

Formatted Search

Formatted Search is a data Search Feature provided by SAP to assist Consultants in facilitating users in inputting Transactions.

Formatted Search Example

Now I will explain how to make the Formatted Search. The step that must be done is
1. Knowing the Item, Column, Table Name and Field Name to be used in a way

• Open the Function in View - System Information

• Opening the Document to be installed by Formatted Search, and directing the Cursor to the Field where the data will be retrieved. For example, I want to take the Document Number from the Purchase Order Form

When the cursor is approached, a text will appear like the picture above where we have got it
Item = 8
Name Table = OPOR
Name Field = Docnum

After knowing the Item, Column, Table Name and Field Name, I will now explain how to use it,

Example 1:
I want to take the No Document to enter the UDF (No Good Issue) that I have made, as shown below

To create a query, you can use 2 ways
Method 1.

Using the Item Format Like the following Example

SELECT $ [$ - 8.0.0]

Method 1.
By using Format Table Names and Field Names Like the following Example

SELECT $ [OPOR.DocNum]

2. After the Query has been created, it must be saved first in the Query manager, for the method can be seen in How to Make a Query

3. After the Query has been saved, please install the Formatted Search on the field that you will install. As an example I will install the Formatted Search on the UDF (No Good Issue). The trick is to place the cursor on the field then press

ALT + SHIFT + F2

Click Button Open Saved Query
Select the Query You Have Saved Before
Press the OK Button

Then FMS can be used

Tip 1
$ [Tablename.FieldName]
Tablename - identification of tables from active forms
Fieldname - identification of fields from the active form

Tip 2
$ [$ Field Index.Field Column.Number / Currency / Date / 0]

This syntax uses index in fields with table document specifications

To use Syntax this consists of 3 elements, namely:

1.Field index - Fill in the Index of items, can be seen in the system information

2.Field column - Field Column will be displayed only for the Detail section in the designated column. For the Header section you can fill in this section with 0

3.Number / Currency / Date / 0

This section is used to take more specific values

Example in the Unit Price Column

For this case I just want to take it

1. The 750.00 number in the Price Unit Column must use a Number

Example $ [$ 38.14.Number]



2. The USD Currency in the Price Unit Column must use a Currency

Example $ [$ 38.14.Currency]








3. If you want to retrieve the contents of the data with the date format, you must use Date

Example $ [$ 10.0.Date]



4. In addition to the above case it can be filled with 0

Formatted Search  For the HANA version

The formatted search used for the hana version is very Case Sensitive so friends must be more careful in reading table names and field names, and there are several syntax additions used and below are examples for Hana's version.

Scenario 1 - Take Post date on Sales Order document
SQL Server: SELECT $ [ORDR.DocDate]
SAP HANA: SELECT $ [ORDR. "DocDate"] From Dummy;

Scenario 2 - Take a post date on the Sales order document and add 3 days from the posting date
SQL Server: SELECT DATEADD (DD, 3, $ [ORDR.DocDate])
SAP HANA: SELECT ADD_DAYS (TO_DATE ($ [ORDR. "DocDate"], 'mm / dd / yyyy'), 3) From Dummy;

Scenario 3 - Combining 2 Fields
SQL Server: SELECT $ [$ 38.1.0] + '-' + $ [$ 38.3.0]
SAP HANA: SELECT $ [$ 38.1.0] || '-' || $ [$ 38.3.0] FROM DUMMY

Tweet