Purpose
This section explains how to define commodity attributes (properties). These property values, which are needed to create commodity codes, are stored in tables of type commodity attribute.
Exercise
-
Open the A.50.02 Tables screen from the Administration > A.50 Database Structure menu branch. The screen opens in query mode; all fields are empty and displayed with a yellow background.
-
Select COMMATTR from the drop-down list in the Type field.
-
Click the Run Query button to display the selected table type.
-
Click in the Name field in the second (Table Names) block.
-
Click the Enter Query button.
-
Enter P_END_PREP into the Name field, or select it from the LOV using the List of Values button.
-
Click the Run Query button to display the selected table. This table represents the End Preparation property; we will further use it in this exercise.
-
Close the screen by selecting File > Close or Close All from the main menu
-
Open the S.20.01 Tablenames with Groups screen from the Smart Reference Data > S.20 Commodity Attributes menu branch. If the screen is not in query mode (all fields empty and displayed with a yellow background), click the Enter Query button.
-
Enter P_END_PREP in the Tablename field in the first block, or select it from the LOV using the List of Values button.
-
Click the Run Query button to display the selected tablename with its groups.
The second (Table Groups) block shows the existing groups of the selected table. Click the WELD group; it will be used later in this exercise.
-
The purpose of the WELD group is to contain all values for the End Preparation property for butt weld components.
-
At least one group must exist for a table to make this table available on S.20.02 for defining the table details (property values).
-
-
Close the screen by selecting File > Close or Close All from the main menu.
-
Open the S.20.02 Tablenames with Details screen from the Smart Reference Data > S.20 Commodity Attributes menu branch. The screen opens in query mode; all fields are empty and displayed with a yellow background.
-
Enter P_END_PREP in the Tablename field and WELD in the Group field, or select both values from the LOV using the List of Values button.
-
Click the Run Query button to display the selected tablename and group with its details.
-
The second (Details) block shows the existing table details (property values) of the selected table and group.
-
The table details represent the property values; for example, the purpose of detail BE is to define the value ‘Bevelled End’ of the End Preparation property.
-
-
Close the screen by selecting File > Close All from the main menu.