For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Use this to synchronize the BoM with external programs.
You can add and change Bill of materials positions of existing work order positions.
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.
Imports Work Order Bill of Materials definitions.
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 checks if the Item Version exists and not locked.
But it is 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
|
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
|
|
WO BoM
Field
|
Name
|
M
|
Type
|
Description
|
SortId
|
Sort
|
|
int(4)
|
Internal sort id. beas sort the bom list by this number
Integration hub
-1 = sort by POS_ID, fast solution
-2 = sort by POS_ID, beas sort the complete bill of material list
-3 = sort by Position Text - alphanumeric
-4 = sort by Position Text - Numeric
More information see documentation
object ue_api_wobom
- beas check the sortid and all special rules too, if you save this with wobom.save
|
BELNR_ID
|
Work order Number
|
X
|
int(4)
|
|
BELPOS_ID
|
Work order Position
|
X
|
int(4)
|
|
POS_ID
|
internal bom position
|
|
int(4)
|
Internal Position number. You can't change it.
This is not the sort number. Sorting is defined by SortId
Integration hub
- use POS_ID=0 - beas create the next number
- if you define a POS_ID, beas update the existing position number or create a new line, if not existing
ue_api_wobom
- the object don't check, if the pos-id is existing. if you insert a existing pos_id a second time, you create a primary key error.
|
POS_TEXT
|
Bill of Material Position
|
|
nvarchar(20)
|
|
ART1_ID
|
Itemcode
|
X
|
nvarchar(50)
|
|
U_beas_ver
|
Version
|
|
nvarchar(20)
|
|
INPUT_QTY
|
Quantity in input unit
|
X
|
numeric(4)
|
|
INPUT_UNIT
|
Unit for Input Quanitty
|
|
nvarchar(20)
|
define separate Input unit id
|
INPUT_FACTOR
|
Factor between Input and prodiction unit
|
|
numeric(4)
|
|
AUSSCHUSS
|
Calculated Scrap
|
|
numeric(4)
|
|
MENGE_VERSCHNITT_LA
|
Cut-Off in Warehouse Unit
|
|
numeric(4)
|
|
APLANPOS_ID
|
Routing-position
|
|
int(4)
|
Link to Routing position
Database - NULL: Related to first or last routing position (related to setting)
|
ROUND_TYPE
|
Rounding type
|
|
int(4)
|
Valid values: Rounding at .5=0
Rounding up=1
Rounding Down=2
Multiple of=3
No rounding=-1
|
ABM1
|
Length
|
|
numeric(4)
|
|
ABM2
|
Width / o.d
|
|
numeric(4)
|
|
ABM3
|
H / i.d
|
|
numeric(4)
|
|
INFO
|
Info
|
|
nvarchar(50)
|
|
UserText
|
Additional text
|
|
nvarchar(255)
|
|
WhsCode
|
Warehouse
|
|
nvarchar(20)
|
|
BINCODE
|
Bin Location
|
|
nvarchar(228)
|
|
ROUND_DEC
|
Rounding dec.
|
|
int(4)
|
|
Match
|
Match code
|
|
nvarchar(50)
|
|
SHORTVARIANT
|
Variant
|
|
nchar(1)
|
|
GRUPPE
|
Material Group
|
|
nvarchar(20)
|
|
VRI
|
Configuration
|
|
int(4)
|
|
WST_ID
|
Raw material
|
|
nvarchar(20)
|
|
DICHTE
|
Density
|
|
numeric(4)
|
|
OnlyReservation
|
Only Reservation Booking
|
|
int(4)
|
Valid values: Yes=1
No=0
|
PlaningSysNoSubMaterial
|
Planning method
|
|
int(4)
|
Valid values: Automatically=0
No=1
|
BITMAPNAME
|
Picture
|
|
nvarchar(50)
|
Valid values: bmp=bmp
|
COLORID
|
Color
|
|
int(4)
|
|
DontBookScrap
|
Don�t post scrap
|
|
int(4)
|
Valid values: Yes=1
No=0
|
MENGE_VERSCHNITT_VE
|
Fixed quantity surcharge
|
|
numeric(4)
|
|
MENGE_JE
|
Per
|
|
decimal(9)
|
|
DIN
|
DIN
|
|
nvarchar(50)
|
|
ABGKZ
|
Closed
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
UDF1
|
User Field 1
|
|
nvarchar(100)
|
|
UDF2
|
User Field 2
|
|
nvarchar(100)
|
|
UDF3
|
User Field 3
|
|
nvarchar(100)
|
|
UDF4
|
User Field 4
|
|
nvarchar(100)
|
|
UDF5
|
User Field f5
|
|
nvarchar(100)
|
|
UDF6
|
User Field f6
|
|
nvarchar(100)
|
|
UDF7
|
User Field f7
|
|
nvarchar(100)
|
|
UDF8
|
User Field f8
|
|
nvarchar(100)
|
|
UDF9
|
User Field f9
|
|
nvarchar(100)
|
|
UDF10
|
User Field f10
|
|
nvarchar(100)
|
|
UDF11
|
User Field f11
|
|
nvarchar(100)
|
|
UDF12
|
User Field f12
|
|
nvarchar(100)
|
|
UDF13
|
User Field f13
|
|
nvarchar(100)
|
|
UDF14
|
User Field f14
|
|
nvarchar(100)
|
|
UDF15
|
User Field f15
|
|
nvarchar(100)
|
|
PrjCode
|
Project Code
|
|
nvarchar(20)
|
|
BBD_OPTION
|
BBD Option
|
|
nchar(1)
|
Valid values: Due date=D
Pickdate=P
Best before date=B
|
Help URL: https://help.beascloud.com/beas202304/index.html?dih_work_order_bom.htm
|