Displays all work order Bill of materials positions.
Link: BEASV_WORKORDER -> BEASV_WORKORDER_POS -> BEASV_WORKORDER_BOM
In BOM you have the linenumber2 (internal number), the Position (visible Line number) and the sort (Sort of bill of Material).
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 |
Bill of material position (internal number) |
BEAS_FTSTL.POS_ID |
Position |
Visible bill of material position (alphanumberic) |
BEAS_FTSTL.POS_TEXT |
SortId |
This is the ID for sorting For correct display select * from BEASV_WORKORDER_BOM where (...) order by "BEASV_WORKORDER_BOM"."SortId" |
BEAS_FTSTL.SortId |
ItemCode |
Material from the Work order bill of material position |
BEAS_FSTSTL.ART1_ID |
ItemVersion |
Item Version from this ItemCode |
BEAS_FTSTL.U_BEAS_VER |
ItemName |
Name of this item |
BEAS_FTSTL.ItemName |
QuantityWhsUnit |
Quantity per Assembly in Inventory UoM |
BEAS_FSTL.MENGE_LAGER |
WhsUnit |
Inventory UoM |
BEAS_FTSTL.ME_LAGER |
QuantityBomUnit |
Quantity per Assembly in Production UoM |
BEAS_FSTL.MENGE_VERBRAUCH |
BomUnit |
Production UoM |
BEAS_FSTL.ME_VERBRAUCH |
QuantityFixWhsUnit |
Scrap and additional Quantity in Inventory UoM |
BEAS_FSTL.AUSSCHUSS |
QuantityTotalWhsUnit |
Planned total Quantity in Inventory UoM |
BEAS_FTSTL |
QuantityBooked |
Booked quantity in Inventory UoM |
IGE1, IGN1 |
Reserved |
Reserved quantity in Inventory UoM |
BEAS_RESERVATION_LINE |
WhsCode |
Main warehouse |
BEAS_FTSTL.WhsCode |
DrawingNumber |
Drawing number |
BEAS_FTSTL.U_BEAS_ZNR |
DIN |
DIN |
BEAS_FSTT.DIN |
Rawmaterial |
Rawmaterial id |
BEAS_FTSTL.WST_ID |
Matchcode |
Matchcode |
BEAS_FTSTL.MATCH |
DeliveryDate |
DeliveryDate of Position |
BEAS_FTPOS.LIEFERDATUM |
Approved |
Position approved 1=0 |
BEAS_FTPOS.Confirmed |
MaterialPlanning |
Material planning (MRP) 1/0 |
BEAS_FTPOS.STARTDISPOSITION |
MaterialBooking |
Material booking allowed? 1/0 |
BEAS_FTPOS.STARTBOOKING |
Lock |
Work order locked? 1/0 |
BEAS_FTHAUPT.SPERRUNG |
Closed |