Each SKEY needs filter criteria to define the commodity codes belonging to the SKEY.
SKEYs can be mapped to commodity codes in different ways:
-
Group/Part only – Most useful for mapping an entire group or set of parts to a separate SKEY.
-
Group/Part with Table Details – Most useful for more complex environments where table details are required and have their own SKEY.
When you create filter criteria for table details, you must consider these rules:
-
Group - Rows with the same group number are enclosed in brackets when building the query.
-
Group Seq - Rows belonging to a group have a unique number within the group. This number is an order sequence used to sort the criteria when building the query.
-
Row Operator - Select AND or OR to determine how the table detail results are combined.
Within a group, the AND operator means that a commodity code must have both table details. The OR operator means that a commodity code must have at least one of the table details. All rows entered for a group must have the operator (AND/OR) except for the last row of this group.
-
Group Operator - Select AND or OR to determine how the results of each group are combined when calculating the total results.
The AND operator means that commodity codes must be in both groups. The OR operator means that commodity codes must be in one of the groups. The group operator (AND/OR) must be selected in the last row of all groups except for the last group.
-
-
Commodity Code – Most useful for mapping exceptions, which are all mapped to their own SKEY.
The following diagram explains the processing logic used to identify which SKEY belongs to a commodity code. Understanding this logic helps you to define SKEY mappings properly.
The "Yes, but 1:n" box means the mapping between the commodity code and SKEY is not
uniquely defined. More than one SKEY is defined, and the process does not know which
one to take.
-
Click Integration > XI10 SPIso > XI1020 Symbol Key Mappings.
-
On the Symbol Key Mapping tab (see bottom of window), map SKEYs to commodity codes.
When the SKEY mappings are done, it is possible that commodity codes are mapped to
more than one SKEY, or the SKEY mapping is missing for commodity codes. Before you
start an export, check the mapping. In addition, you can check the export log files.