Link to Categories

For some master data imports it is possible to create a link to data objects from Data Administration (categories), i.e. using and assigning already existing master data objects (s. Assign master data). This is done by directly referencing their ID from Data Administration.

Overview on all import objects with possible category links:

Import object	Category to link
Workers	Work steps Manufacturing processes Origins Cost centers Activities Shift models
Manufacturing processes	Workers Cost models Cost centers Machines Additional costs
Semifinished parts	Shift models
Purchased parts	Raw materials
Cost centers	Workers Manufacturing processes Machines
Activities	Workers Machines
Machines	Work steps Manufacturing processes Origins Cost centers Activities Shift models
Shift models	Workers Machines Locations
Locations	Workers Basic data types Machines Shift models
Basic materials	Semifinished parts
Additional costs	Manufacturing processes Cost models

Note

The ID label can vary depending on the category in Data Administration. For example is it labeled as "Classificator" for basic data types, as "Inventory number" for machines, and as "Cost Model Id" for cost models.

The exact ID label is displayed in the Excel import dialog.

WARNING

In addition to the ID, the data field "Active" must be defined as "true" at the referenced object so that it can be recognized as an active link/assignment to be used in its full functional scope.

If this data field assignment is missing, the object is assigned as "inactive" (see example).

EXAMPLE: Linking a cost model in the manufacturing process import

Example: Excel file for importing manufacturing processes with cost model (active and inactive assignment)

Enter the following cost model data field settings in the "Excel Import (Manufacturing Process)" dialog:

Result:

Manufacturing process with assigned, active cost model:

Manufacturing process with assigned, inactive cost model: