Present the Reservation cross references for current work order position
BeasScript:
openwindow=dw=reservation_link_browse<tab>c_parm1=6002295<tab>c_parm2=10<tab>s_parm1=wo
Property
|
Description
|
DocEntry / belnr_id
|
base document
|
LineNumber / belpos_id
|
base document line
|
s_parm1
|
base type, example wo for work order
|
|
Examples for templates
Description
|
SQL Statement
|
on stock from current defined work order for example a sales order.
(Standard is complete stock reservation for base document)
|
Coalesce((select sum(l."Quantity") from "BEAS_RESERVATION_LINE" l
where l."RESERVATIONTYPE"='S' and l."BASE_TYPE"="BEAS_RESERVATION_LINE"."BASE_TYPE"
and l."BASE_DOCENTRY"="BEAS_RESERVATION_LINE"."BASE_DOCENTRY"
and l."BASE_LINENUM"="BEAS_RESERVATION_LINE"."BASE_LINENUM"
and l."LINK_DOCENTRY"="BEAS_RESERVATION_LINE"."LINK_DOCENTRY"
and l."LINK_LINENUM"="BEAS_RESERVATION_LINE"."LINK_LINENUM"),0)
|
|