Customization WO structure viewProduction > Work order general > WO structure > WO Print > Customization WO structure view |
Top
Previous
Next
|
The work order structure view cannot be changed with the normal settings and customizations which Beas offers, because different forms are nested. Each row type (work order, assembly, routing etc.) has its own SQL-statement and output form.
To make possible a limited customization nevertheless, to window settings some options have been added. For BoM and routing additional information can be called from database. The description can be changed for this line type. see Window settings - WO structure view
Note: Extended knowledge is required for customization. SQL-Template fields must be written in valid SQL syntax, for HANA environments we have to apply HANA sql rules.
Example: Display quality control plans in routing. Approach:
Window settings > Routing > SQL-Template field1: beas_ftapl.qs_id Window settings -> Routing -> Description: bez+ '(' + templatefield1 + ')'
Result: the activity is displayed in the view. Right of it, in brackets, you can see the quality control plan
Example: display current stock in material. Approach: (Query is HANA compatible)
Window settings -> Bill of materials -> SQL-Template field1: cast("OITM"."OnHand" as nvarchar(50)) Window settings -> Bill of materials -> Description: bez + ' (' + templatefield1 + ')'
Result: in the view the activity is displayed and next to it in brackets, the stock of current item
SQL-statement Direct access on the following tables BoM: beas_ftstl, beas_ftpos, oitm, beas_me Routing: beas_ftapl, beas_aplatz, beas_ftpos, beas_agtyp, beas_me
Statement needs to return a value of type "char" or "varchar". Other data types need to be converted using convert(varchar(50),[fieldname]). Sub-Select-statements need to be put n brackets: (select myfield from [@myTable] where "ItemCode"=beas_ftpos."ItemCode")
Description There you can determine, what to display as description. Enter in Datawindow-Syntax.
All fields in the window can be accessed. see Debug-Window - "Variable" tab > Button "Local" |