Item structure

Administration > System Initialization > Configuration Wizard > Master data > Item > View > Item structure

Top  Previous  Next
Expand/Collapse Toggles

Settings for Item structure – View.

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)

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

 

beas 9.1 PL: 08

 


Help URL:http://www.beascloud.net/docs/help/online_eng/index.html?setupitemstructureview.htm