Define rules for Pre-Assign in Issue window and every backflush process or WEB APP solution

 
More information see PreAssign
 
 
 
Variable 
 | 
Read 
 | 
Write 
 | 
Description 
 | 
e_res_dfltwhs 
 | 
x 
 | 
x 
 | 
By default the following value is stored: 
case when ifnull("BEAS_FTSTL"."WhsCode",'') <> '' then "BEAS_FTSTL"."WhsCode"  else "OITM"."DfltWh" end 
  
If always the same warehouse is to be set as default in reservation window:   
function setres_reservation 
setvar=e_res_dfltwhs=('01') 
end function 
  
Important: brackets, otherwise the ' -character could be misinterpreted 
Alternatively setvar=e_res_dflthws="'01'" 
  
Available tables: 
BEAS_FTSTL, BEAS_FTPOS, BEAS_FTHAUPT, OITM, O2 (OITM from assembly), BEAS_ME, BEAS_AGTYP 
 | 
 
 
 
 | 
e_res_whscode_std 
 | 
x 
 | 
x 
 | 
Available tables: 
OITM, OWHS 
batch item: OBTN, OBTQ,  
serial number item: OSRN, OSRQ 
  
Withdrawal always with priority: 
1. Reservation (the switch has no effect) 
2. Allocation warehouse – if included in the list 
3. Default warehouse which may be overwritten by a warehouse list. Extended definition of sorting is not possible. 
The withdrawal sorting set up in configuration wizard is applied for batches and serial numbers. 
  
To consider additionally the default warehouse insert the place holder "*****"  
function e_res_issuewo 
setvar=e_res_whscode_std="OWHS"."WhsCode" in ('*****','01','02') 
end functoin 
 | 
 
 
 
 | 
e_res_filter 
 | 
x 
 | 
x 
 | 
Used to determine for which BOM positions to create a reservation or allocation 
The following tables are available: 
BEAS_FTSTL, BEAS_FTPOS, BEAS_FTHAUPT, OITM, O2 (OITM from assembly), BEAS_ME, BEAS_AGTYP 
  
Example: For reservation, consider only batch-related items, for which a "Y" was entered in the material group in field "UDF1".  
  
function setres_reservation 
setvar=e_res_filter= <cr_lf>and ("OITM"."ManBtchNum"<>'Y' or coalesce((select "BEAS_MATGRP"."UDF1" from "BEAS_MATGRP" & 
      where "BEAS_MATGRP"."GRUPPE" = "OITM"."U_gruppe"),'N')='Y') 
end function 
 | 
 
 
 
 | 
 
 
Why  WoDocEntry / WoLineNumber not available?
Reason:  In the reservation list you can have more then one work order. You must define the rules in the SQL query
 
// reservation: User "1" has only access to warehouse 01 and 02
function setres_reservation
if <currentuser> = "1" then
  setvar=e_res_whscode_std="OWHS"."WhsCode" in ('01','02')
end if
end function