Field description

Production > Capacity Planning, APS > APS Scheduling > APS Edit scheduling > Views > Views > Field description

Top  Previous  Next
Expand/Collapse Toggles

APS Planning  

 APS edit Planing

         Master data

         Resources

         Views

                 View

                 Sub view

                 Field description

         Calculation type

 Planning view

 

APS_views_FieldDesc_SAPStyle

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.

darstellung_linkeseite        darstellung_summenbalken2

 

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)

 

hmtoggle_plus1   Example:

 

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

flaggreen SQL-instruction is correct

flagred 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

 

hmtoggle_plus1   Example:


Help URL: https://help.beascloud.com/beas202402/index.html?feldbeschreibung.htm