ue_api_wobom

api_wobom is a Object for Administration of Work order bill of material

 

NOTE:

Please use BeasServiceLayer WorkorderBom for manage / change Bill of Material positions

This object is only available for compatibility.

 

 

You can declare the object with:

declare=<wobomobjectname>=ue_api_wobom

 

example

declare=wobom=ue_api_wobom
wobom.getbykey=1244=10
wobom.addline
wobom.itemcode=A001
wobom.quantity=2
wobom.udf1=hello world
wobom.save

 

if you want to insert a new line, work with sorting by "POS_TEXT"

Example: you have bom position 10 and 20 and want insert position 15

 

declare=wobom=ue_api_wobom
wobom.getbykey=1244=10
wobom.addline
wobom.itemcode=A001
wobom.quantity=2
// define the position (text information)
wobom.pos_text=15
// sort (beas use numberic sort, means: convert information to numberic 
wobom.sortbypostext
// save
wobom.save

 

Methods

Methoode

Description

getbykey=<belnr_id>=<belpos_id>

 

 

This function load the bill of material ist from this work order position

 

Attention:

if you execute the load function 2 times with same work order position, beas don't reload the bill of material

 

Example

// load work order bill of mateiral
wobom.getbykey=1244=10 
// try to load again -> beas do nothing, because it's loaded
wobom.getbykey=1244=20
// reload first bom -> beas load it again, because curent Position 20 is loaded
wobom.getbykey=1244=10

 

Attention:

if you want to insert a new line, you must execute

wobom=addline

new=<belnr_id>=<belpos_id>

Create a new bom.
Attention: Better is always to load a bom, otherwise you can have a primary key problem


addline

Add a new bill of material row

setrow=<row>

Set the actual Row

update

save

 

if the program can't save it, it return an error message and

value <wombom.ret_code> = -1

 

if all ok, beas return <wobom.ret_code> = 1

 

Attention

beas insert all not existing information (sorting information,

 

goto_pos=<pos_id>

if position not found, api_wobom will return -1 in variable <wobom.ret_code> otherweise it return in <wobom.ret_code> = 1 an din <wobom.ret_value> the current row

 

Example

wobom.getbykey=<belnr_id>=<belpos_id

wobom.goto_pos=10

if <wobom.ret_code> n= 1 then

 //...

end if

goto_postext=<pos_text>

if position not found, api_wobom will return -1 in variable <wobom.ret_code> otherweise it return in <wobom.ret_code> = 1 an din <wobom.ret_value> the current row

 

Example

wobom.getbykey=<belnr_id>=<belpos_id
wobom.goto_postext=10
if <wobom.ret_code> n= 1 then
  //...
end if

sortbypostext

 

 

if you want to insert a new line, work with sorting by "POS_TEXT"

Example: you have bom position 10 and 20 and want insert position 15

 

declare=wobom=ue_api_wobom
wobom.getbykey=1244=10
wobom.addline
wobom.itemcode=A001
wobom.quantity=2
// define the position (text information)
wobom.pos_text=15
// sort (beas use numberic sort, means: convert information to numberic 
wobom.sortbypostext
// save
wobom.save

sortbyposid

 

if you want to insert a new line, work with sorting by "POS_ID"

Example: you have bom position 10 and 20 and want insert position 15

 

this is only working, if you define always the pos_id!

 

declare=wobom=ue_api_wobom
wobom.getbykey=1244=10
wobom.addline
wobom.itemcode=A001
wobom.quantity=2
// define the position (text information)
wobom.pos_id=15
// sort (beas use numberic sort, means: convert information to numberic 
wobom.sortbyposid
// save
wobom.save

 

 

 

Property

You can use the property name OR the table column name

all other not documented properties: use direct the table name

attention: beas don't check the value. If you insert wrong values, you have this in the database!

 

Property

Columnname in Table BEAS_FTSTL

read

write

Description

rowcount

x

 

Count of all Rows. ReadOnly

currentrow

x

 

Actual Row. ReadOnly

pos_id

pos_id

x

x

Internal position number

Update: Don't change the pos_id. Please use the POS_TEXT

Attention: The pos_id don't define the sorting!

pos_text

pos_text

x

x

visible position number (alpha numeric)

sortid

sortid

 

x

 

Numberic value

Define the sorting. If you create new line, you can define special sort definition

- 1 = after position, which pos_id is lower as the pos_id from current line (good setting for integration hub)

- 2 = order by pos_id, resort the complete bill of material

- 3 = order by pos_text - alphanumeric

- 4 = order by pos_text - numberic

 

More information see integartion hub - Definition Target

 

example:

wobom.pos_id=10

wobom.sort_id=-2

...

wobom.save

 

itemcode

art1_id

 

x

 

the system get all information and write this in the bom position, example length, width, height, warehouse, rawmaterial and so on.

 

if you want to change this other properties, please define first the itemcode and then the other properties.

version

u_beas_ver

 

x

 

if version information available, beas insert the description and drawing number from this version.

 

variant

shortvariant

 

x

short variant (A-Z)

configuration

vri

 

x

configuration number

fixquantity

menge_verbrauch_ve

 

x

fix quantity. scrap quantity. beas calculate this quantity only 1 time and not per assembly

quantity

menge_verbrauch

 

x

quantity per assembly in use unit

per

menge_je

 

x

define "quantity per", example per 1000 assemblies

calcutatedscrap

ausschuss

 

x

calculated scrap quantity. See documentation. You can change, define this manually.

roundingtype

round_type

 

x

Define rounding type 0-4

roundingdec

round_dec

 

x

Rounding - count of decimal places

length, width, height

abm1,abm2,abm3

 

x

info

info

 

x

info line in bom

additionaltext

usertext

 

x

additional user text

warehouse

whscode

 

x

warehouse code

matchcode

match

 

x

matchcode from this item

beas insert automatically the additional costs information (fields VK_ZUSCHLAG, GK_ZUSCHLAG)

materialgroup

gruppe

 

x

material group of this item

rawmaterial

wst_id

 

x

rawmaterial of this item

density

dichte

 

x

density of this field

udf1 ... udf15

 

x

all udf fields