After selecting ‘Rule based’ in the Kind of field, the tab is automatically switched to Rules.
Rule-based where conditions can be defined based on the mappings ‘IDENT MAPPED_TO IDENT’, ‘LP_ID MAPPED_TO LP_ID’, or a combination of both. The upper section in combination with the lower left section of the Rules tab is used for defining the criteria for IDENT MAPPED_TO IDENT. The upper section in combination with the lower right section of the Rules tab is used for defining the criteria for LP_ID MAPPED_TO LP_ID.
If you create a where condition based on ‘IDENT MAPPED_TO IDENT’, only modules with the Mapped to Column IDENT can be assigned to the where condition in the Modules field in the first (Where Conditions) block.
If you create a where condition based on ‘LP_ID MAPPED_TO LP_ID’, only modules with the Mapped to Column LP_ID can be assigned to the where condition in the Modules field in the first (Where Conditions) block.
If you create a combination of both ‘IDENT MAPPED_TO IDENT’ and ‘LP_ID MAPPED_TO LP_ID’, no validation of the module will be carried out.
The allowed modules with the mapped column are defined on A.60.05 Where Condition Modules and listed above in the Where Condition Header Definition section.
After selecting ‘Rule based’ in the Kind of field, the tab is automatically switched to Rules.
Now you can insert the criteria on the Rules tab. The upper section can be used for all mapping types. To limit the number of idents selected by the view, you can enter entries in the fields of this section.
The fields point to the corresponding tables as listed below.
Field |
Table |
---|---|
Group |
M_COMMODITY_GROUPS |
Part |
M_PARTS |
Master Table |
M_DICT_TABS |
Table Name |
M_DICT_TABS |
Table Group |
M_TABLE_GROUPS |
Table Detail |
M_TABLE_DETAILS |
Commodity Code |
M_COMMODITY_CODES |
Ident Code |
M_IDENT_CODES |
Input1 |
M_IDENT_CODES |
Input2 |
M_IDENT_CODES |
Input3 |
M_IDENT_CODES |
Input4 |
M_IDENT_CODES |
Input5 |
M_IDENT_CODES |
If you insert values into the Table Name, Table Group, and/or Table Detail fields, the MV_WHERE-View will only find ‘Table Detail based’ commodity codes and associated idents. In this case, it is not possible to make entries in the lower left block of this tab.
On the other hand, if you have already made entries in the lower left block, it is no longer possible to insert values into any one of the following fields: Table Name, Table Group, and Table Detail.