-
From the Data Explorer drop-down, select All Commodity Groups/Commodity Group/Part/Commodity Code.
-
Expand VBB, Ball Valves and double click the commodity part B, Swing Type.
-
Click Edit grid .
-
Click Add row .
-
In the new row, enter the following table details for the table names:
-
P_ALIAS (Group)– VB_US
-
P_ALIAS (Detail) – AAA
-
P_ALIAS_TRIM (Group)- VB_US
-
P_ALIAS_TRIM (Detail) – AAA
-
P_ DIM_STD (Group) – VB_US
-
P_DIM_STD (Detail) – AA
-
P_SYSTEM (Group) – US
-
P_SYSTEM (Detail) – A
-
P_MATERIAL (Group) – FORG_US
-
P_MATERIAL (Detail) – A4
-
P_MAT_SYSTEM (Group) - BZ
-
P_MAT_SYSTEM (Detail) – Z
-
P_RATING (Group) – RAT_US
-
P_RATING (Detail) – A
-
P_VLV_BODY_TYPE (Group) – VB_ALL
-
P_VLV_BODY_TYPE (Detail) – B
-
P_VLV_OPERATOR (Group) – ALL
-
P_VLV_OPERATOR (Detail) – B
-
P_END_PREP (Group) – VALVE
-
P_END_PREP (Detail) - FJ
-
-
Click Save grid .
-
Click Read-only grid to set the grid back to read-only mode.
Commodity code VBAAAAAZABBF is now generated. The following table shows how each character of the code is represented:
Commodity Code Generated |
Character |
Digit ID |
Table Name |
Table Detail |
---|---|---|---|---|
VBAAAAAADBCR |
V |
1 |
M_COMMODITY_GROUPS |
VBB |
B |
2 |
M_PARTS |
B |
|
A |
3 |
P_ALIAS |
AAA |
|
A |
4 |
P_ALIAS_TRIM |
AAA |
|
A |
5 |
P_DIM_STD |
AA |
|
A |
6 |
P_SYSTEM |
A |
|
A |
7 |
P_MATERIAL |
A4 |
|
Z |
8 |
P_MAT_SYSTEM |
Z |
|
A |
9 |
P_RATING |
A |
|
B |
10 |
P_VLV_BODY_TYPE |
B |
|
B |
11 |
P_VLV_OPERATOR |
B |
|
F |
12 |
P_END_PREP |
FJ |
Can you guess what will be the commodity code, if you add another P_VLV_BODY_TYPE key with the value Z?