Beas determines whether the parameter is a number or a string depending on the value.
•If the value is a number or "0", Beas interprets this parameter as a number.
•If the value is empty or not a number, Beas interprets this parameter as a string.
Example 1:
Parameter: "color" is "red"
Formula: 'the color is ' || [color]
HANA SQL: select 'the color is' || 'red' -> all ok
Formula: 10 + [color]
SQL: 10 + 'red'-> produce error
Example 2:
Parameter: "color" is "5.3"
Formula: 'the color is ' || [color]
HANA SQL: select 'the color is' || 5.3 -> produce error
Formula: 10 + [color]
SQL: 10 + 5.3 -> all ok
The evaluation of a formula is always dependent on the contents of the parameter.
All configurations created with beas 9.2 PL 5 Build 32 or older, use parameter type "Auto" as standard.
Working with Beas system variables or custom defined variables starting with "e_", the parameter can be interpreted as a string or number. With the following Beas script setup the type can be permanently defined as string type, if the value is a Beas variable. This must be executed only once per database or client.
setsetup=config_default_e_type=c
String
This parameter type allows a string. If working with formulas, Beas inserts a ‘ (single quotation mark) at the left and right side of the parameter.
If you create a new parameter, the string type is the default option.
Example 1:
Parameter: "color" is "red"
Formula: 'the color is ' || [color] (HANA SQL)
MS SQL: select 'the color is' + N'red'
HANA SQL: select 'the color is ' || ' red'
Example 2:
Parameter: "color_number" is "5,3"
Formula: '10' + [color_number]
MS SQL: '10' + '5,3' -> all ok
Formula: 'the color is ' + [color]
DataWindow Syntax: 'the color is' + 'red'
Number
This parameter type allows numbers only. If the content is not a number, Beas replaces it with “0”. The decimal delimiter is based on what it is defined in the system, but Beas internally replaces it with decimal point.
Example:
Parameter: "color_number" is "5,3" (Regional setting is Germany)
Formula: [color_number] * 3
SQL: 5.3 * 3
If you use a parameter both as a string or numeric value, then it is advantageous to specify this directly in the formula.
String formula: 'color is ' || [color,dbstring]
Number formula: if [color_number,dbnum] > 10 then 1 else 100 end
A picture to be displayed at this group. When the user selects the group, the picture is displayed. To select a picture, click on the drop-down arrow in the field and a screen opens to browse for the required image. Beas saves the image in the SAP Picture share folder.
The image display size can also be defined.
The size parameter is not supported fin the WEB version and in the WEB Configurator the image is always the original size.
The following sizes are supported in the internal view:
This option can be used for check box, radio box, or drop-down selection.
You can insert the SQL statement clicking the SQL icon or you can create a Cross Reference and can insert the link to this Cross Reference.
Cross Reference: SQL Statement or manual values are supported
SQL Command
The generated SQL Command must return 3 string parameters:
•return value
•description
•picture (only for radiobox)
Tip
If a SQL statement is used, the configuration can be easily copied from one database to another.
SQL example:
Create a list of all Items starting with "SofaCloth".
Use SQL Editor or type the commands:
[select id,description,bitmapname from table where ...]
For all items starting with "SofaCloth":
[select "ItemCode","ItemName" from "OITM" where "ItemCode" like 'SofaCloth%']
The result of using this statement for radio box and selection drop-down:
Default Value
If a default value is defined, it is assigned to the parameter. Note, that this filed is case sensitive.
•Variables, which are defined before opening in the Configurator window (that is, with Beas script in "Windowevent open"). These variables must be defined with "e_".
Example:[e_cardcode]
•As empty value
Choose [CurrentEntry]
•Previously defined parameters. These defaults are dynamically changed.
Example:[so_mysetobject]
Fixed value
A fixed value is set if:
•a new configuration is loaded
•if a previously invalid default value becomes valid
Example of an invalid default value becoming valid again:
A radio box is defined with 3 elements: red, yellow, green. The default value is yellow. But the visibility rule specifies that yellow is invisible, and therefore invalid. In this case, "yellow" is invalid,so there is no default. Every time the configuration is changed, the system checks whether yellow is valid. If it becomes visible again, the parameter is set if the default has not yet been overwritten.
Default is a parameter
If the default value is a parameter, it is always reset if something is changed before the parameter.
Example:
WheelSize
defcolor (set object): case when[WheelSize] <30 then 'red' else 'blue' end
Color (Default=[defcolor])
If WheelSize is changed, the content of Color is also reset because WheelSize is BEFORE Color. If values are changed after Color, Color the value is not set again.
Manual changes have priority
If Color is changed manually, the manual change takes precedence, that is even if WheelSize is changed, the default value of Color is not reset, except, if the manually selected value loses its validity.
Example:
Color is a radio box
// Red only available, if WheelSize < 30
// Blue only available, if WheelSize>24
Red = case when [WheelSize] <30 then 1 else 0 end
Blue= case when [WheelSize] >24 then 1 else 0 end
If Blue is manually selected and then WheelSize is set to 22, Blue becomes invalid, so the manual entry loses its priority and the default value is set. In this case red and the entry is marked as "not changed manually".
If the default value is also invalid, the entry is marked as "not set".
- Use a special price list of a customer if it is selected from "Default price list" drop-down in the Calculation Header. (previously "Use BP price list" radio box).
Supports all price list rules, but unit groups are not supported.
If you insert [cprice] in a formula, you see the price determination result by Price List in this parameter.
No
Price determination is not activated for this entry.
Price
Use the entered price, if price determination is set to Manually.
The logo of the actual currency (for example "$" or "€") is displayed right of the field.
Some rules can be defined to display the block with specific values or parameters. The rules determine whether a configuration option is presented to the operator, based on previous configuration selection. This way, it is possible to restrict options. The rule is created in SQL syntax.
Field
Description
Parameter Insert
Parameters and Set Objects that are already defined, are displayed in a selection list. They can be used to create of a rule.
Script
The language syntax that the rule is written in. Available options are: