Skip to main content

xSuite Cube Release Notes

Determining the material number

If the material number of an order is not automatically recognized, an attempt is made to determine the appropriate material number using other numbers from the order. For example, the customer material number (KDMAT), manufacturer part number (MFRPN), and European article number (EAN11) fields are used to determine the material number.

Notice

The material number can only be determined if at least one of the following fields has been recognized:

  • Material Description (MAKTX)

  • Customer Material Number (KDMAT)

  • Manufacturer Part Number (MFRPN)

  • International Article Number (EAN/UPC) (EAN11)

The material number is determined once after the data has been imported. It is determined in the transfer method in two steps:

  1. The system attempts to find an exact match for the Customer Material Number (KDMAT), Manufacturer Part Number (MFRPN), or International Article Number (EAN/UPC) (EAN11) within the system. This step is always executed.

  2. If no match is found in the first step, the system performs a distance search in the second step.

    The distance search selects data from the material table that matches the first N digits of the existing number. The distance is then calculated. The option with the shortest distance is selected. The Levenshtein distance logic is used to calculate the distance.

    Notice

    The distance search must be activated via the record type parameter SD_DISTANCE_SEARCH (transaction /WMD/FP_RTYPE).

    The value of the parameter is the number of digits (1 to N) that must match the first digits of the found number exactly. The higher the parameter value, the fewer options are considered.

In this section: