You can specify a user-defined where condition to further restrict the property. To refer to the base table of the property, use the prefix BASE_TABLE.
Where condition criteria definition
You must define the selection criteria for the selected where condition in the Properties tab of the Where Condition Details page. Use the following operators for selection criteria:
Operator |
Description |
---|---|
MAPPED TO |
This is a system internal operator used to define the column mapping. Mapping can be created to the database columns IDENT, LP_ID, LN_ID, RLI_ID. Example: IDENT MAPPED TO IDENT This creates the relation of the alias (property) IDENT to the database column IDENT. |
= <> < <= > >= |
These operators perform comparisons. Examples: ATTR = 'XA' -> matches only values equal to XA ATTR <= 5 -> matches any value less than or equal 5 |
BETWEEN NOT BETWEEN |
For these operators, you must define a range as a comparison value. Example: ATTR BETWEEN 2 AND 4 -> matches any values greater than 2 and less than 4 ATTR NOT BETWEEN 10 AND 50 -> matches any values less than 10 and greater 50 |
LIKE NOT LIKE |
These operators perform SQL wildcard matching. You can use _ (underscore) as the placeholder for exactly one character, or % (percent) to match any combination of characters. Examples: ATTR LIKE 'X%' matches any value beginning with X. ATTR LIKE 'B_M' matches any three character value beginning with B and having M as the third character. ATTR NOT LIKE ‘A%’ matches any value not beginning with A. |
IN |
When using this operator, you must define a list of values to be included in the selection as the corresponding value. Example: ATTR IN ('XX', 'YY', 'ZZ') -> will only fetch records with the assigned values ‘XX’, ‘YY’, or ‘ZZ’. |
NOT IN |
When using this operator, you must define a list of values to be excluded from the selection as the corresponding value. Example: ATTR NOT IN ('AB', 'AC', 'AD') -> will only fetch records not having the values ‘AB’, ‘AC’, or ‘AD’ assigned. |
IS |
This operator checks for empty fields. You must define either NULL or NOT NULL as the corresponding value. Example: ATTR IS NOT NULL |
INPUT |
Can be used to create parameters for formulas. This Property will become a field in the view definition. Refer to the online help of the A.60.08 Define Formulas page for a detailed explanation. |
OUTPUT |
Can be used to create an updateable Property for use in a formula. Internally, this will include the ROWID of the base table record in the result set of the view. Refer to the online help of the A.60.08 Define Formulas page for a detailed explanation. |
DISPLAY |
Can be used to include an Property for display only as a column in the view definition. |
Use quotes and parentheses for values of type VARCHAR2.
The predefined columns are IDENT, LN_ID, LP_ID and RLI_ID and refer to the primary key columns of tables M_IDENTS (Ident Data), M_LIST_NODES (BOM structure data), M_LIST_POS (BOM positions data) and M_REQ_LINE_ITEMS (Requisition line items data), respectively.
Predefined column |
Linked table |
Primary key |
Comment |
---|---|---|---|
IDENT |
M_IDENTS |
IDENT |
Ident data |
LN_ID |
M_LIST_NODES |
LN_ID |
BOM structure data |
LP_ID |
M_LIST_POS |
LP_ID |
BOM positions data |
RLI_ID |
M_REQ_LINE_ITEMS |
RLI_ID |
Requisition line items data |
You must map at least one of these columns, which from a logical point. This specifies that that you are selecting specific data from one of the mentioned tables. The other properties that are not involved in mapping serve to restrict this data according to the selection criteria.
You are not free to choose any mapping, however. Instead, specific modules need a specific column mapped, because their functionality depends on the presence of a primary key column of a specific table in the result set of the view. You must pay attention to the following requirements:
Requisition templates
Requisition templates must have the column IDENT mapped, because template views perform a selection based on the kind of material for a particular requisition.
Requisition split criteria
Requisition split conditions must have the column LP_ID mapped, because split sets define how BOM position data is split up so that they make up different requisitions.
BOM Rules
These rules define how assembly structures are exploded in different stages of a project. You need to map the column IDENT for conditions that you wish to assign to these rules, because the parts that make up an assembly are identified by their idents.
Conditions for other BOM tools
The BOM tools operate on the table M_LIST_POS, so in order to define the data they should operate upon, you must have the column LP_ID mapped.
The MAPPED_TO record in the second block will automatically be generated when saving the new where condition, based on the assigned module and in relation to the definition of the A.60.05 Where Condition Modules page, as described above in the Where Condition Header Definition section.
There must be at least one column mapping defined for the where condition. Duplicate mappings are not allowed.
Using the Boolean field, you can connect two conditions with a Boolean operator. Only the operators ‘AND’ and ‘OR’ are allowed; the negation NOT is handled using the comparison operator.
Select the Case check cell to define this condition as a case-sensitive condition.
Grouping of Properties
To group properties, select the Grp check cell of two properties to be grouped.
Mapping properties cannot be grouped.