Displays all work order routing positions.
Link: BEASV_WORKORDER -> BEASV_WORKORDER_POS -> BEASV_WORKORDER_ROUTING
In Routing you have the linenumber2 (internal number), the Position (visible Line number) and the sort (Sort of routing plan).
Column |
Description |
Table Info |
---|---|---|
DocEntry |
Document Entry (internal number) |
BEAS_FTHAUPT.BELNR_ID |
DocNum |
Document Number (alphanumeric) |
BEAS_FTHAUPT.AUFTRAG |
LineNumber |
Work order position |
BEAS_FTPOS.BELPOS_ID |
LineNumber2 |
Routing position (internal number) |
BEAS_FTAPL.POS_ID |
LineNumber3 |
Tool/Parallel resource internal line number |
BEAS_FTAPL_WKZ.WKZPOS_ID |
PositionType |
Type of this position main = the main position |
BEAS_FTAPL_WKZ |
Position |
Visible bill of material position (alphanumberic) |
BEAS_FTAPL.POS_TEXT BEAS_FTAPL.POS_TEXT / BEAS_FTAPL_WKZ.POS2_ID |
SortId |
This is the ID for sorting For correct display select * from BEASV_WORKORDER_ROUTING where (...) order by "BEASV_WORKORDER_ROUTING"."SortId" |
BEAS_FTAPL.SortId |
Barcode |
Barcode from Entry |
BEAS_FTAPL.NUMMER |
ResourceId |
Resource Id, linked to BEAS_APLATZ.APLATZ_ID or for tool |
BEAS_FTAPL.APLATZ_ID |
Mandatory |
Time receipt mandatory? 1/0 |
BEAS_FTAPL.BDE |
Description |
The work description |
BEAS_FTAPL.BEZ |
BlockLogin |
Login blocked? |
case when substring(coalesce("BEAS_FTAPL"."FLAGS",'000'),3,1)=1 then 1 else 0 end as BlockLogin, |
StartDateTime |
Start of the Task |
BEAS_FTAPL.GESAMT_ANFZEIT |
TransferStartDateTime |
Start of Transfer |
BEAS_FTAPL.UEBERGABE_ANFZEIT |
TransferEndDateTime |
End of Transfer |
BEAS_FTAPL.UEBERGABE_ENDZEIT |
ProcessStartDateTime |
Start of Process |
BEAS_FTAPL.ANFZEIT |
ProcessEndDateTime |
End of Process |
BEAS_FTAPL.ENDZEIT |
IdleStartDateTime |
Start of Idle |
BEAS_FTAPL.LIEGEZEIT_ANFZEIT |
IdleEndDateTime |
End of Idle |
BEAS_FTAPL.LIEGEZEIT_ENDZEIT |
PlannedTime |
Planned time in Minutes |
BEAS_FTAPL |
WorkTime |
Sum of worke time |
BEAS_ARBZEIT |
ReserviedTime |
Sum of reserved time |
BEAS_RESOURCEN |
QuantityPlanned |
Planned quantity (Production UoM of Assembly) |
BEAS_FTPOS |
QuantityGood |
received goods quantity |
BEAS_ARBZEIT |
QuantityScrap |
scrap quantity |
BEAS_ARBZEIT |
Activated |
Routing Position activated 1/0 |
BEAS_FTAPL.AKTIV |
Approved |
Work order pos confirmed? 1/0 |
BEAS_FTPOS |
CapacityPlanning |
CapacityPlaning allowed 1/0 |
BEAS_FTPOS |
LoginToWorkOrder |
Login / Start allowed |
BEAS_FTPOS |
ChangeAllow |
Changes allowed |
BEAS_FTPOS |
Lock |
Work order locked? 1/0 |
BEAS_FTHAUPT.SPERRUNG |
Closed |
Position closed? |
ABGKZ from all related tables |
Priority |
Priority |
BEAS_FTHAUPT.PRIOR_ID |
Probject |
Project Code |
BEAS_FTPOS |
PrjTask |
Project Task id |
BEAS_FTAPL.PRJUID |
CreationDate |
Date of creation |
BEAS_FTAPL.ERFTSTAMP |
CreationUser |
Created by User Id |
BEAS_FTAPL.ERFUSER |
UDF1...UDF15 |
Free UDF fields |
BEAS_FTAPL.UDF1...15 |
WorkorderCLosed |
Workorder closed |
BEAS_FTHAUPT.abgkz |
PositionClosed |
Workorder position closed |
BEAS_FTPOS.abgkz |
OperationClosed |
Operation closed |
BEAS_FTAPL.abgkz |
InWork |
Operation current in use |
Info from BEAS_FTSTMP /BEAS_ARBZEIT |
EndDateTime |
End of Task |
BEAS_FTAPL.GESAMT_ANFZEIT |
AutomaticallyScheduled |
|
|
ResourceDescription |
"BEAS_APLATZ"."Bez" |
|
YieldQuantityRE |
Yield Quantity in unit defined in Routing Position |
sum( from "BEAS_ARBZEIT") |
ScrapQuantityRE |
Scrap Quantity in unit defined in Routing Position |
sum( from "BEAS_ARBZEIT") |
BomUnit |
Unit of Measurement of the Assembly |
"BEAS_FTPOS"."ME_VERBRAUCH" |
ItemCode |
Assembly Itemcode |
"BEAS_FTPOS"."ItemCode" |
ItemVersion |
Version of Assembly |
"BEAS_FTPOS"."U_beas_version" |
ItemName |
Name of Assebmly |
"BEAS_FTPOS"."ItemName" |
PositionDeliveryDate |
Deliverydate for Position |
BEAS_FTPOS.LIEFERDATUM |
PositionStartDate |
Starttime for Workorderposition |
BEAS_FTPOS.ANFZEIT |
PositionEndDate |
Endtime for Workorderposition |
BEAS_FTPOS.ENDZEIT |
WorkOrderStartDate |
Starttime for Workorder |
BEAS_FTHAUPT.ANFZEIT |
WorkOrderEndDate |
Endtime for Workorder |
BEAS_FTHAUPT.ENDZEIT |
Receipt_count |
Count of receipts |
|
Worktime |
Sum of all work times |
|
Quantity_good |
Sum Quantity Good |
|
Quantity_scrap |
Sum Quantity Scrap |
|
Quantity_good_ru |
Sum Quantity Good in receipt unit |
|
Quantity_scrap_ru |
Sum Quantity Scrap in receipt unit |
|