APS Planning
APS edit Planing
Master data
Resources
Views
View
Sub view
Field description
Calculation type
Planning view
Following can be defined in detail in the tab "Field description":
1. Definition of the sum description and operation sequence description
2. Up to 4 additional freely definable fields
These pieces of information are determined directly using SQL-fragments. Although this method is not very simple, it is very flexible.
Designation information
The sum bar and operation sequences can be described in Gantt. The grouping and the description of the task can be done additionally at this information on the on the left side.
The grouping and so the view on the left side can be defined in the Sub view.
The designation can be defined using SQL-Instruction. The SQL-Instruction is allowed to recall only one Varchar-String. Numbers have to be converted in string via the convert-instruction. The field is formatted correctly and converted if it has been selected by adding. The result is displayed immediately in the field "Result". The green/red flag shows if the instruction is correctly.
Default setting designation:
Column
|
Document position, Resource, Activity
|
Sum 1
|
Document position, Item, Item description
|
Sum 2
|
Document position, Order, Customer name
|
There is an access to the following tables to insert additional fields:
BEAS_FTAPL
|
Operation sequence
|
BEAS_FTPOS
|
Assembly
|
BEAS_FTHAUPT
|
Work order
|
OITM
|
Item information of the assembly
|
An access to all others tables is also possible via sub instruction.
(select x from mytable where y=z)
Example:
Examples are displayed in HANA-Syntax. These examples can also be used in the MSSQL-environment, because Beas converts these in MSSQL-Syntax for runtime.
Operation sequence with item + describe material
Field - Description - Column "Sum 2"
RTTRIM("BEAS_FTPOS"."ItemCode") || ' '+rtrim("OITM"."U_WST_ID")
Work order position:
Statement position number, Item number, Description, Already posted in quantity, Total quantity
Cancellation or "manual complete" are no considered at this example.
'('||rtrim(CAST("BEAS_FTPOS"."BELPOS_ID" AS varchar(10)))||') ('||rtrim("BEAS_FTPOS"."ItemCode")||') '|| rtrim("BEAS_FTPOS"."ItemName")||' '||
CAST(CAST(ifnull(
(select sum("InvQty") from "IGN1" where "U_belnrid"="BEAS_FTPOS"."BELNR_ID" and "U_belposid"="BEAS_FTPOS"."BELPOS_ID" and ifnull("U_posid",0)=0)
,0) AS int) AS varchar(20)) || ' <spr:von> ' ||
CAST(CAST("BEAS_FTPOS"."MENGE" AS int) AS varchar(20))
||' '||rtrim("BEAS_FTPOS"."ME_LAGER")|| ' <spr:fertig>'
|
Relevant commands for formatting:
rtrim()
|
delete subsequent spaces
|
convert(varchar(10),field)
|
Convert number or date to characters
|
ifnull(field,'')
|
Pre-assginment of the result with space string, if it is not already assigned
|
Note:
Not all fields are always filled. You must ensure that a ZERO is not returned.
You can intercept this e.g. using is zero():
coalesce(rtrim("OITM"."U_BEASWST_ID"),'')
User-definable fields for APS view
Up to 4 freely definable fields can be defined for the graphic view and 4 fields can be defined for the APS Work order list.
Available fields:
Field name
|
Description of the field (will not be translated)
|
SQL - Checking - Flag
|
Display if the entered SQL-instruction is correctly
SQL-instruction is correct
An error was detected in the SQL-instruction
|
SQL Instruction
|
SQL - fragment. Here will be displayed which information has to be displayed.
Available tables:
In list and graphic view: Work order position BEAS_FTPOS, Work order BEAS_FTHAUPT as well as Item master OITM.
Only in the graphic view: Routing BEAS_FTAPL, Resource BEAS_APLATZ
|
Example:
A field can be defined as "Material" if a Grouping for eg. by "Material is required
Field name: Material
SQL: coalesce(rtrim("OITM"."U_BEAS_WST_ID"),'')
The sorting and grouping of the material is immediately available in the Sub view definition.
|
Help URL: https://help.beascloud.com/beas202402/index.html?feldbeschreibung.htm
|