DIH Work Order BoM

Description	See	Table
Work order Bill of materials	Edit Work order BoM - General	BEAS_FTSTL

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.

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/beas202402/index.html?dih_work_order_bom.htm