This functionality allows you to view the properties in the Multi Ident View according to the property group selected. The functionality can be accessed through the Display Idents command available on the shortcut menu of the classification tree view as shown below.
The Display Idents command has one or more sub menus. The default sub menu is called All Properties. The other sub menus are populated dynamically according to the number of property groups.
You can select All Properties to view all the properties for a selected ident. A selected group displays the idents with only the properties assigned to that group.
When creating an ident, you have the option to view the mandatory and unique columns assigned to other groups by right-clicking on the grid as shown below. This option is available only if you are viewing a property group and is not available when you are viewing all the properties.
Display Mandatory Properties - All mandatory properties of other property groups appear.
Display Unique Properties - All unique properties of other groups appear.
Display Mandatory and Unique Properties - Both unique and mandatory properties from all the property groups appear.
Display Properties (Other Classes) - The ident properties associated with other classes appear as read-only columns in a light blue color. The data from these columns can be copied to the properties of this class. This command acts as a toggle and changes to Hide Properties (Other Classes) when it is clicked, and vice versa.
If you click the Display Properties (Other Classes) command, the expanded multi ident view looks like the following:
The properties from the other classes are shown in a light blue color, and these columns cannot be edited. When you right-click the light blue cells and select Copy Data To, you can then select a property column (destination column) of the present class to which data is copied.
A pop-up for Paste Options appears (shown below) to enable you to choose whether to paste either only the cell data or the entire column data from the source column. The copied (cell or entire column) data from the read-only source column is pasted to the destination cell or column, depending on your selection. The data is copied if both source and destination column types are the same. If not, a message appears.
Columns in Grid
Ident Code: You can enter the ident code in this field while creating the new record. If this field is left blank, the software builds the ident code using the existing logic. You can insert data but cannot update data in this column.
Class Layout: This is a read-only field. The value in this field is generated and populated based on the defined class layout and the ident's property values. This field is available in the grid in non-edit mode only.
Ident Layout: This is a read-only field. The value in this field is generated and populated based on the defined ident layout and ident values. This field is available in the grid in non-edit mode only.
Property Columns: You can have one or more columns in the grid depending on the properties that are associated with the class. You can enter data for all of these properties. The columns that appear with the icon are the properties of the class that have the mandatory column checked. The value for these columns is mandatory.
When you enter data for ident property values, the software provides an auto-complete mechanism.
You can double-click on a column to automatically size the column width to the width of the column label or the short description (whichever is greater). The software remembers this column sizing and displays it when you re-open the grid.
Grid Toolbar Buttons
In order to operate on the data displayed in the grid, you can click one of the buttons provided on the grid toolbar. The main buttons and their operations are as given below:
Edit Mode: To edit the grid, a commodity code must be assigned to the class. A default commodity code can be assigned on A.20.12 for the project default ZX_DFPIMCC. When type mapping is assigned to a class system, the default commodity code created at the class level is used.
On click of the Edit Mode button, this will set the grid for edit operation. If you want to add / modify / delete data, click this button first. Note that the software tries to lock the record. If the software cannot lock the record, a message appears, saying the record cannot be modified.
When you edit a cell and then click out of the cell, the software validates the data in the cell.
-
For a property of type attribute, the software checks to see if the value entered is the correct data type.
-
For a property of type attribute, the software checks to see if the value entered is less than the maximum data length.
-
The software checks to see if the ident value entered is in the Selection list .
-
For ident values of type date, the software checks for the correct format.
-
For mandatory fields, the software checks to see if values were provided.
Read Only Mode: By default, the grid appears in read-only mode. After edit operations are done and you have saved your data, click this button to set the grid again in read-only mode. Please note that when grid is in edit mode, all other controls are disabled; those controls are enabled again when you set the grid in read-only mode by clicking this button. Do not close the window when the grid is in edit mode; all the menu options remain in a locked condition.
Add Row: Click this button to add a blank row in the grid to create a new record.
Check Grid: Once you are done with your modifications in the grid, you can click this button to evaluate any possible errors in the data before you save. This operation also checks that the values for all mandatory properties are supplied for the modified and newly inserted rows.
Save: Saves the modifications done on the grid data. The custom procedure CMS_IDENT_PROP_VAL_POST_INSUPD in M_PCK_STD_CUSTOM is called when the grid is saved. This procedure is called when you perform the following:
-
When an ident is created or updated
-
When an ident property value is inserted or updated
The flow of control is as shown below:
-
Build ident code
-
Insert or update ident property value
-
Call procedure CMS_IDENT_PROP_VAL_POST_INSUPD
-
Build class layout
-
Build ident NLS
This procedure is called when the transaction is made through CMS screens and not when the data is imported (for example, from XML).
All validations that are carried out by the Check Grid button are also done for the added or changed records before saving the data. These validations are carried out as per the Unique Key Violation Setting made at the class level.
-
Warning: When the class level setting is Warning, a message appears for any entries of duplicate values. The duplicate data is highlighted for you to correct it. If you try to save the data without correcting the duplicate values, a warning appears, but the data is saved.
-
Error: When the class level setting is Error, an error message appears for any entries of duplicate values. The duplicate data is highlighted for you to correct it. The data is not saved until you correct all the duplicate values.
For new rows, idents are not created if the data violates the unique key. The following message appears.
Change NLS: Allows you to change the NLS setting of the current login. On click, it pops up a list of languages so that you can select one.
Selection list :This button is available only in edit mode when the cursor is in the column that has a selection list associated to it. Click this button to select a valid value for that field.
If the selected field on which the selection list is invoked is a property and the type of the property is Table, the selection list window can have a cascading effect, which means once you choose a value in the selection list it automatically opens up another selection list depending upon the value chosen in the previous selection list. In the case of properties of type Table, the selection list displays a list of valid table details. Table details can be arranged in a hierarchical tree manner. The first time the selection list pops up, it displays all root level table details. Once a selection is made either by clicking OK or double-clicking, another selection list pops up with all its child table details. This sequence continues until a table detail that has no child table details is selected.
If the selected field on which the selection list is invoked is a property of type Attribute, and if the attribute is derived from a query, then:
-
The query must have two columns only. The first column must have the ID field. The software expects the ID field to be numeric. The second column could be any column in the query.
-
Note that in the case of an attribute having a data type character, the character value from the selection list itself is stored in the database.
-
In the case of a number, the number value and in the case of a date, the date value from the selection list is saved.
-
In the case of an attribute having data type graphics, the corresponding symbol ID is saved.
If the property is of type Attribute and it does not have restrictions either from the attribute value or from an associated query, the values in the selection list are all the existing values for the property for the same class.
Sort: Click this button to define a sort condition for the grid data.
Filter: Click this button to define a filter condition for the data displayed in the grid.
Selection list
The selection list associated with any field normally have the following fields.
Find: Provide a sub string for the value you are looking for, and the software filters the selection list with the possible matches.
Values: Displays possible values applicable for the field. You can select one of them either by double-clicking that value or by selecting it and clicking OK.
OK: Selects the highlighted value for the field.
Cancel: Closes the selection list without making any selection.
Compute Physical Attributes: You can compute the physical attributes for a class to which a Smart 3D sheet is mapped and also the class properties are mapped to Smart 3D attributes. When the mapping is available for the class properties on the SP3D 10.07 Sheet Configs screen, the values in the Physical Attribute column can be computed by clicking this button.
This button is only enabled if the selected class is mapped to a Smart 3D sheet. If the class is not mapped to a Smart 3D sheet, this button is not available.
The values for physical attributes are calculated by the software by default and are displayed below:
When you compute the physical attributes from the CMS Multi Article View for a class, the software uses the property name and maximum length of the property values given in the MAV and re-calculates the physical attribute.
Grid Shortcut Menu
The following commands are available when you select a row and click the right mouse button.
Edit: You can select this command to perform all edit operations for the selected row. This command has further sub menu items as shown in the picture below. You can see the shortcut key combinations for each command on the menu.
-
Add: Similar to adding a row, adds a blank row below the selected row, setting the grid in edit mode if not already set. The shortcut is F6.
-
Copy: Copies the selected row in the grid. The shortcut is CTRL+C.
-
Copy with Column Names: Copies data along with the corresponding column names. The shortcut is CTRL+SHIFT+C.
-
Paste (Insert Rows): Pastes data from the copy buffer into the grid by creating new rows for the pasted data. The shortcut is CTRL+SHIFT+V.
-
Paste (Overwrite): Pastes data from the copy buffer into the grid by overwriting the existing data. The shortcut is CTRL+V.
-
Find and Replace: Searches for data in the grid. The shortcut is CTRL+H. For more information, see Find and replace data.
-
Delete: Deletes the row selected in the grid.
-
Undo: Undo the changes in the selected row. This sub menu is available only when the grid is in edit mode. The shortcut is CTRL+Z.
An Undo on a modified row rolls back the changes to the original values.
An Undo on a newly added row clears the data in the selected row. Before the data is cleared, a message appears, asking if you want to undo the changes in the new row (that is, clear the data).
Undo is also available on a cell, by right-clicking. The shortcut is CTRL+Z.
-
Undo Deleted Rows: Provides an option to recover deleted rows. This sub menu is only available when the grid is in edit mode. The shortcut is CTRL+SHIFT+Z.
A dialog box containing all the deleted rows appears. You can select rows and then click Undo Delete.
Re-classify Ident: Re-classifies or additionally classifies idents.
View: This command has further sub menu items as shown in the picture below.
-
Show NLS: Opens the grid view displaying ident values for all the properties in all the languages defined in the software. Please note that only those languages for which corresponding class system descriptions exist are considered in this grid. You can filter the properties whose value is exclusively dependent on language using the right-click shortcut menu.
You can modify the NLS values for the properties. Not all properties are modifiable, however. When you click the Edit toolbar button, the grid turns to edit mode. In edit mode, only those cells that meet the following conditions are editable:
Table details and their NLS: You are not able to modify them in edit mode.
Layout: You are not able to modify them in edit mode.
Attributes:
-
Having valid values: The short description is modifiable by choosing a value from the selection list. The description is not modifiable (a comment appears in this field).
-
Having valid value as query: Because they do not appear in the grid, modification is not possible.
-
Having no selection list: You can modify the short description; the description is not modifiable (empty).
-
-
Supplier Details: Opens a read-only dialog box that displays the details of the suppliers linked to the ident. All the suppliers are shown in a pre-defined sort order according to the supplier code. The dialog box displayed is shown below.
You can scroll through the suppliers using the navigation bar at the bottom of the dialog box. Shortcuts such as Page Up and Page Down are listed in the status bar. You can add, remove, and modify the suppliers for the ident using the icons beside the navigation bar.
In the first block with the supplier contact information, all the fields except Supplier Code are read-only. When you enter or select a supplier code, all the other fields are auto-populated.
The Supplier Code field has an auto-complete feature, in addition to the selection list.
In the second block, in the Manufacture Details section, all the fields are editable.
The units in the unit group CURRENCY from A.10.12 are made available in the Unit selection list.
When you save the data, the software performs validations, including:
-
The Manufacture Lead Time value is considered to be days. The Manufacture Lead Time and Market Price values must be greater than or equal to zero.
-
The Expire Date and Approve Date values must be greater than or equal to the Current Date value.
-
The Expire Date value must be greater than the Approve Date value.
-
-
Commodity Template: Opens a read-only grid as shown in the figure below. This grid displays the commodity template details associated with the ident.
Check Non CMS Idents: This functionality enables you to check the values of the properties of non-CMS idents (classical idents) transferred to CMS against the Selection list defined for that property in CMS. It also checks data type and data length defined for that attribute. If any error is found, that cell is highlighted and a consolidated error message appears in a child window.
Transfer Idents: You can select this command to transfer the idents. For more information, see Transfer idents.
Manage Documents: This functionality allows you to attach multiple documents to an ident.