2-0sbo learning experience (formatting search)

Most business documents of SbO are the relationship structures of the master and slave tables, similar to the relationship between a single header and a single table.

The format search principle is to capture any value displayed on the current activation page (document.

Capture method:

1. For the header: $ [Table name. Field name] or $ [$ item.0]
2. for table bodies: $ [$ item. column.0/number/currency/date], the two most common parameters are 0 and number.

For example, in the purchase order, take the material number in the table body, $ [$38.1.0/number].

38 indicates the table body, 14 indicates 14th columns, and 0 indicates taking the value in this grid.

Usage After capturing the value:

This value is mainly used for databases as SQL parameters. Open the tool-query wizard.

Write the following statement:

Select * From por1 where itemcode = $ [$38.1.0/number]

Before this statement is passed into the database, the SBO system automatically resolves it to select * From por1 where itemcode = 'a0001 '(where a0001 is assumed to be the material number ).

Note: formatted search must be used in the query wizard mentioned above. Otherwise, it cannot be parsed and cannot be run.

Application 1 (there are a lot of applications, which will be unexpected at half past one ):

Automatically bring out relevant information. For example, each item has a warranty period field. When preparing a purchase order, enter the material number to automatically bring out the warranty period.

Method:

(1) when preparing the purchase order, the purchase order screen is activated and formatted to search for the entered material number.

(2) Compile an SQL statement in the query wizard to find the shelf life corresponding to this item number.

(3) add an event to the shelf life text box: when the value of the material number text box changes, the SQL statement in (2) is triggered and the retrieved value is bound to the shelf life text box.

Application 2:

Reduce the search range. For example, if the company has 20 thousand pieces of materials, the business personnel do not know the number of the materials to be found. They only know about large and small materials.

Method:

(1) format the search to capture the category options, bring out the middle class, and so on bring out the small class.

(2) After selecting a small category, you can go to the database to find all the materials belonging to this small category, which can greatly narrow the scope.

Application 3:

For approval control, the next article details.