Item structure

PATH: Administration > System Initialization > Configuration wizard > Master data > Item > Item structure.

Name

Description

Expand max. levels

Refers to the function "expand completely" in item structure.

This is computationally extensive and can take long for large structures. Use the structure report as an alternative.

The maximum number levels to be expanded has been limited to 5. It can be changed here.

(beas 9.1 PL: 08,Variable itemstrmaxlevel)

Support SAP Bill of Materials

If activated, the system displays linked Bill of Materials entries which were defined in SAP Business One: Production > Sales Set-Bill of Materials.

Note: If you change this setting for the item structure view level, the system changes the identical setting in the precalculation area, as well.

Allow Item-copy

Beas has a proprietary function for copying items that differs slightly from the SAP Business One function. You can use this to decide whether the copy function should be available.

See

Item generation

Create new

Extension Step

- Item

- BOM

- Routing

The item structure can be adjusted. As in all structure views, templates are not supported because different data sources are read (Tables) depending on type (Item, BOM, routing).

The following is possible with this view:

1. Definition of which SQL-Fields should be loaded with (SQLField1, SQLField2)

2. Setup of the short description or activity. (Use DataWindow-Syntax!)

See Video

At the definition of the to be loaded fields it is indicated which SQL-sequence should be imported in the column "SQLField1".

Note: The return value must always be from the type "varchar(x)". You can access the fields of the following tables:

Linkage SQL-Fields – Table

Area	Tables
Item	OITM, BEAS_ITEM_VERSION, BEAS_STL_HEADER Note: Always check return on ZERO. Return must always be of type "varchar(x)". e.g. coalesce("OITM"."FrgnName",'')
BOM	BEAS_STL, BEAS_ITEM_VERSION, BEAS_STL_HEADER, BEAS_ME, BEAS_APL Note: Return must always be of type "varchar(x)". A NULL-Check is not necessary.
Routing	BEAS_APL, BEAS_APLATZ, BEAS_AGTYP Note: Return must always be of type "varchar(x)". A NULL-Check is not necessary.

At definition of the output an expression - object will be filled with one of the available formula fields

Area	Expression Object Name	Default
Item	citemname	itemname
BOM	cbezstl	bez
Routing	cbezapl	bez

Example:

Foreign language name FrgnName + Item description is to be shown additionally.

SqlField 1 (SQL)= coalesce("OITM"."FrgnName")

SqlField 1 (SQL)= coalesce("OITM"."ItemName")

Setup item description: (DW-Syntax): sqlfield1 +' ' + sqlfield2