Definition data target

Administration > Data Integration Hub > Data integration hub > Import Definition > Definition Data Target

 Top  Previous  Next
Expand/Collapse Toggles

hmtoggle_plus1    Attendance

Attendance

Imports attendance data.

The following details are required:

•Personnel number

•Start date

•End date

 

Personnel numbers and start dates are matched during the update.

 

Attention:

It is not possible to link order times with attendance times if the attendance data is imported, because the order times are calculated at the time of the order time receipt and the attendance report is usually not imported at that point.

Personnel

Import Personnel Data for Beas Personnel data

Synchronize Human Resources -> Employee Master Data:

- If not existing, the system creates a new entry automatically

- if existing, the system update follow fields: First Name, Last Name, Middle Name, Date of Birth, Start Date, Termination Date

Absence

Imports absence areas, like holiday, sick leave, etc.

The primary keys are "Personnel Id" and "from date". It is also possible to update this data.

 

The following details are required:

•Personnel Id

•From Date

•To Date

•Absence Id
hmtoggle_plus1Factory data capture

Order times

Imports work order times.

This data can only be imported and it is not possible to change existing order time receipts.

 

The following details are required:

•Work order document number

•Work order position

•Routing number

•Employee

•Start/End

•Time (in minutes)

 

Dates have to be indicated in yyyy/mm/dd  format and time in hh:mm format. Example: 2016/05/17 09:00

 

Backflushing

The Disable backflushing filed is enabled by default. The backflushing process can be deactivated here. To activate, set the filed to Y.

Only material and assemblies can be posted, if the data could be identified automatically.

 

Important:

The time is not set, it must be indicated. All rules stored in the Configuration Wizard are applied.
hmtoggle_plus1Work order

A work order has the following objects:

•Work order header

•Work order position

•Work order bill of materials and routing position

 

Example:

The old system contains all item, bill of materials and routing information. This data can be imported with the integration hub. After this is complete, work orders can be imported.

Only the top level assembly can be defined. Beas reads bill of materials and routing information from imported master data.

 

It is not possible to import routing or bill of materials for every work order separately.

import_workorder1

 

A third-party application can define the work orders in Beas. You can use this option if you have an external planning tool for production in stock.

import_workorder2

import_workorder3

Example: A machine needs to be produced and while producing the technical planning continues. You can import and synchronize the bill of materials in the work order directly from the CAD program.

Area

Insert

Update

Work order header (BEAS_FTHAUPT)

Use this if you want to update the header information or if you want to create new work orders and  you need only the item code and quantity for the work order position.

Inserts all header information.

Inserts first work order position with item code and quantity.

Beas explodes the bill of materials, routing position and all order-related sub-assemblies.

Note:

Creating reference to other documents or changing any properties in the work order line is not possible.

You can change the work order type, but it is not possible to change the work order type related flags; Beas ignores these changes.

 

You cannot define the document number (BEAS_FTHAUPT.BELNR_ID), only the order number (BEAS_FTHAUPT.AUFTRAG).

Most properties are changeable, but you cannot change the created work order positions.

 

Beas will ignore the item code and quantity property.

 

Work order position (BEAS_FTPOS)

Use this to import work order positions with extended position information.

The assembly can be defined, but Beas always uses the BOM and routing information from item master data.

Add position to existing work orders.

Beas explodes the bill of materials, routing position and all order-related sub-assemblies.

If you do not define a work order number, Beas creates a new work order (BELNR_ID=0).

It is not possible to define additional information for work order header if the system creates a new work order.

 

Defines linked information.

It is not possible to update existing positions.

Bill of materials (BEAS_FTSTL)

Use this to synchronize the BOM with external programs.

you can add and change bill of materials position of existing work order positions.

The work order document number, work order position and bill of materials position are mandatory.

 

When trying to insert an exiting BOM position, Beas updates the position.

 

Beas does not explode order related assemblies. Multilevel work orders cannot be created.

All properties of an existing bill of materials position can be updated.

 

Beas does not change existing sub-position.

 

You can delete a BOM if you set the quantity to 0, but only if no related transaction or reservation exists.

Routing position

Not possible.

Not possible.

 

The following fields are mandatory:

•Document number, work order position number, bill of materials position number

•Quantity

Entries can only be changed if changes are allowed and the work order position is not closed.

 

Position numbers:

•The internal position number. If this is a new number or if it is 0, Beas creates a new position.

•If you do not set the position text, Beas sets the position number in position text.

•The internal position number does not define the sorting. You must define this separately. See Sorting rules.

 

Position text:

•If this is not set manually, Beas inserts the defined or generated internal position ID.

•It can be defined and changed every time.

 

ItemCode:

Item code is mandatory and the item must exist.

The integration hub does not check additional rules.

If you change the item and the related position, reservation or transactions exist, Beas does not change anything.

Note: If you insert an order-related item, Beas does not create an order-related sub-position.

 

ItemVersion:

The system check, if the Item Version is existing and not locked

But it's allowed to use it, if not released.

 

Quantity:

Rules for quantity in the BOM import:

•A value > 0 inserts a positive amount.

•A value < 0 inserts a negative amount.

•A value of 0 deletes an existing position. See Delete a bill of materials position.

•A value of +0 adds a position with 0 amount.

If you only have 0 quantity in the importfile, you can convert the value

DIH_import_zero

 

Delete a Bill of materials position:

It is possible to delete an existing Bill of materials position. Beas requires the following fields: BELNR_ID,BELPOS_ID and POS_ID and Quantity=0.

•If any transaction exists on this position, the position cannot be deleted.

•If a reservation exists, Beas deletes the reservation.

•If the position is an order-related assembly, Beas deletes all related sub-positions.

•If a deletion of a sub-position is not possible, Beas closes all related sub-positions.

 

Sorting (SortId):

Defines the sorting for the bill of materials positions. You can define a positive number or special sorting rules.

Sort Id

Description

-1

Order by internal position number. The system searches by position, and chooses a number that is lower than the current position and higher than the lowest existing position. It receives this sortid, increments it with 1 and defines it as a sortid from the current position.

 

Example:

Pos 10 – Sort 10

Pos 20 – Sort 20

 

You insert Pos 15

 

Pos 10 – Sort 10

Pos 15 – Sort 11

Pos 20 – Sort 20

 

This is a fast variant, because Beas must only insert Pos 15, but in other situations this can generate a problem.

 

Example:

Pos 10 – Sort 1

Pos 20 – Sort 2

 

You insert Pos 15

 

Result in MSSQL:

Pos 10 – Sort 1

Pos 15 – Sort 2

Pos 20 – Sort 2

 

Result in HANA:

Pos 10 – Sort 1

Pos 20 – Sort 2

Pos 15 – Sort 2

 

In this case Pos 20 and Pos 15 have the same Sort id and it is not clear which position is the first position.

-2

Order by internal position number.

 

In this case Beas sorts the complete bill of materials position by internal position number

Beas must save every change from every bill of materials position. In case a large number of positions must be inserted, this concept produces a lot of change requests. Do not use this for mass import.

 

Example:

Pos 10 - Sort 10

Pos 20 - Sort 20

Pos 30 - Sort 30

 

You insert Pos 15

 

Pos 10 – Sort 10

Pos 15 – Sort 20 <- insert

Pos 20 – Sort 30 <- update

Pos 30 – Sort 40 <- update

 

-3

Order by position text (alphanumeric).

 

Example

Pos Text A10 Sort 10

Pos Text A20 Sort 20

Pos Text A50 Sort 30

 

You insert position with Pos Text = A30

Pos Text A10 Sort 10

Pos Text A20 Sort 20

Pos Text A30 Sort 20 <- insert

Pos Text A50 Sort 30 <- update

 

Attention: You can encounter the following issue when working with numbers:

 

Example

Pos Text 10 Sort 10

Pos Text 20 Sort 20

Pos Text 100 Sort 30

 

Insert Position Pos Text = 50, and the result (alphanumeric sorting) is the following:

 

Pos Text 10 Sort 10

Pos Text 100 Sort 20 <- update

Pos Text 20 Sort 30 <- update

Pos Text 50 Sort 40 <- insert

 

-4

Order by position text (converted to number)

 

Example

Pos Text 10 Sort 10

Pos Text 20 Sort 20

Pos Text 100 Sort 30

 

You insert position with Pos Text = 50

Pos Text 10 Sort 10

Pos Text 20 Sort 20

Pos Text 50 Sort 30 <- insert

Pos Text 100 Sort 40 <- update

 

If you insert a position with alphanumeric position text, Beas sets this to first position.

Example: insert position with text A001

 

Pos Text A001 Sort 10 <- insert

Pos Text 10 Sort 20 <- update

Pos Text 20 Sort 30 <- update

Pos Text 100 Sort 40 <- update

 
hmtoggle_plus1Item

Item

Import and match items.

 

When a new item is imported, the "default item" from the Configuration Wizard is used as a reference. As an alternative, it can be set in the "e_sourceitem" variable (to define in conversion script from field "Itemcode") and an alternative default item can be used.

 

item import procedure:

1.Define the default item. Fill all fields (unit of measure, planning method, procurement method etc.).

2.Set the default item in the Configuration Wizard

3.Define and perform import

 

Note:

Material group, unit of measure and item group can be created automatically, if Extended / Create groups and units was enabled in the import . If the data is incomplete, the data set is not created.

 

The following fields have extended settings:

All unit of measure fields

In case a unit of measure that does not yet exist in the UoM table, is imported, it is automatically created.

Material group (u_BEAS_GRUPPE)

Material group is automatically created, if it does not exist.

Item group

When, instead of the item group ID, the item group description is indicated, the internal item group ID is determined and used automatically in the description.

 

When the item group is not found, it is automatically created.

Procurement method

If enabled, the scheduling ID is set to storage-related assembly, otherwise to it is set to Purchase item.

I-Version

If a version number is entered, an item version is created immediately. This is done independently of the Create groups and units settings.

Bill of materials header

Import the Bill of materials head. See Edit bill of materials.

Bill of materials position

Bill of materials is imported.

A bill of materials is always seen as a whole and can only be imported completely. In case of an update, the BOM is deleted first and re-inserted. It is not possible to update single positions, but synchronization can be done on position level.

 

An item needs to be defined which is used if the imported position has no valid item number. This is done in the Configuration Wizard.

 

The correct order for an import is:

•Item

•Routings

•Bill of materials head data

•Bill of materials

 

A bill of materials can also be imported directly. Positions numbers are assigned automatically if they are not set manually.

 

If the material number is not defined, the default item is inserted, and the bill of materials is set to manually.

If the stored material number is unknown, the default item is inserted, bill of materials position is set to manually and the transferred item number is inserted into the information field.

 

See Edit bill of materials.

 

Bill of materials alternative material

Import alternative items related to a BOM. See Alternative material.

Routing header

Import routing master data.

Routing position

Import the routing.

The standard operation type needs to be defined. Resources must be created. You can work with operation sequence catalog numbers. In this case, all default values are accepted.

 

A routing can only be imported or replaced completely. Single routing positions cannot be replaced.

 

Important:

When working with parallel resources, the input of the internal position number is necessary for linking.

Item parameter

Import the item parameter.

QC cross reference

Import item related QC orders.

 
hmtoggle_plus0Master data

Resource

Import master data resource.

Routing catalog

Import routing catalog or templates.

Warehouse areas

Import the bin warehouse areas.

Bin location

Import the bin location definitions.

Business partner

Import of the business partner master data, contact person billing address and delivery address.

Tools

Import of tool master data and tool BOM.

 
hmtoggle_plus1Quality control

QC Header

Import quality control header.

QC Position

Data import is also possible if no header data is created. The header data is created automatically.

During an update,  positions can only be added or changed, but not deleted.

QC Order results

The following information is mandatory (see image):

- Document number (red) or, alternatively, QC order + Document 2 (green)

- Position: Pos_ID (red) or Pos_text (blue)

 

DIH_QC_results_target

 

 
hmtoggle_plus1Transactions (Production, Bookings, Post manually etc.)

Material transactions are defined in a definition file: "Transaction plan lines".

Different transaction types like receipt and issue, goods receipt etc. can be executed here.

The transaction type is indicated in the "Transaction Type" field.

 

The following transaction are supported:

Transaction Typ

Description

WOIM

Production – Material issue

WORM

Production – Material / Assembly receipt (beas 9.3 PL 2 HF 2)

MANIN

Manual posting or stock re-taking

 

Link example for work order issue document
All this fields in this table are mandatory

Field

Value

Transaction Type

WOIM

Link Document Type

"WO"

Link Document

BEAS_FTSTL.BELNR_ID

Link Line 1

BEAS_FTSTL.BELPOS_ID

Link Line 2

BEAS_FTSTL.POS_ID

ItemCode

BEAS_FTSTL.ART1_ID

Quantity

the Issue Quantity in Inventory UoM

WareHouse

The WareHouse from the Item  OWHS.WhsCode

Bincode

Bincode, if warehouse is a bin managed warehouse

Supported: SAP, WMS and beas bin management

If this is a WMS or beas bin managed warehouse, the bincode is mandatory

BatchNumber

Normal Item: Empty

Batch Administration: OBTN.DistNumber

Serial Administration: OSRN.DistNumber

 
if this is a work order receipt or purchase receipt and batchnumber generation is activated, then it's not mandatory to fill it

 

Important:

The data must be checked for correctness before the import. There is no further check in the import process-

The values must be checked in the Import Preview function or all necessary checks must be defined in the Source – Target – Link.
Help URL: https://help.beascloud.com/beas202106/index.html?definitiondatenziel.htm