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
|
|
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
|
|
|
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
|