Production Capacity planning APS Work with APS Planning types Edit APS planning APS planning views Field description - robinfeng/beashelp GitHub Wiki
Navigation: Production > Capacity Planning > APS > Work with APS > Planning types > Edit APS planning > APS planning views: Field Description No contents entries on this page Contents In the "Field description" tab, you can specify in detail:
- Definition of total and work sequence description
- Up to 4 other user-definable fields
This information is ascertained directly by SQL fragment. Although this technology is not very simple, it is very flexible.
Labeling information
The totals bars and work sequences can be labeled in the Gantt chart. This information can also be used for the grouping and the description of the task on the left side. darstellung_linkeseite darstellung_summenbalken2
You can now define the grouping - and thereby the view on the left side, in Subview .
The label is defined using an SQL instruction. The SQL instruction may only return a varchar string. Numbers must be converted to string using a convert instruction. If a field is selected using Add, this is inserted correctly formatted and converted. The result is displayed immediately in the "Result" field. The green/red flag indicates whether the instruction is correct.
Default label setting: Field Document position, resource, activity Total 1 Document position, item, item description Total 2 Document number, order, customer name
Access to the following tables exists for adding further fields BEAS_FTAPL Position BEAS_FTPO Assembly BEAS_FTHAUPT Production order OITM Item information on the assembly
Sub-instructions can of course also be used to access all other tables. (select x from mytable where y=z)
hmtoggle_plus1 Example:
Examples in HANA-Syntax. These can also be used in MSSQL-environment, because beas is converting them, at runtime to MSSQL-Syntax.
Label operation with item + raw material Field - Description - Column "Sum 2" RTTRIM("BEAS_FTPOS"."ItemCode") || ' '+rtrim("OITM"."U_WST_ID")
Wok order item: Enter position number, item number, designation, already received quantity, total quantity In this example, cancellations or "manually completed" are not taken into account
'('||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'
Commands relevant to formatting rtrim() Remove trailing blank spaces convert(varchar(10),field) Convert number or date to characters isnull(field,'') Fill result with empty string if it is not allocated.
Warning: All fields are not always filled. You must ensure that a ZERO is not returned. You can intercept this e.g. using iszero(): ifnull(rtrim("OITM"."U_WST_ID"),'')
User-definable fields for APS view Up to 4 user-definable fields can be defined, which are available in the Gantt view. E.g. if a grouping by raw material is required, a "material" field can be defined
Field name: Raw Material SQL: ifnull(rtrim("OITM"."U_WST_ID"),'')
The material is available immediately in the subview definition for sorting and grouping. You can also access the following tables by SQL: BEAS_FTAPL, BEAS_FTPOS, BEAS_FTHAUPT and OITM.
If you use BEAS_FTAPL the statement is available only in graphical view.
The flag indicates whether the instruction is correct Green: OK Red: incorrect
NOTE The fields indicated here are displayed in APS-list. See: APS-work order list
返回 主页