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).
Available options 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
|
|
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 the definition of the output an expression-object is filled with one of the available formula fields:
|
|
|
Item
|
citemname
|
itemname
|
BoM
|
cbezstl
|
bez
|
Routing
|
cbezapl
|
bez
|
Example:
Foreign language name FrgnName + Item description is to be displayed additionally.
SqlField 1 (SQL)= coalesce("OITM"."FrgnName")
SqlField 1 (SQL)= coalesce("OITM"."ItemName")
Setup item description: (DW-Syntax): sqlfield1 +' ' + sqlfield2
|