Item Master

Items with non-blank cat code 2 and contains “Bike” in the description.

f4101 (itm,litm,dsc1) all(srp2 ! blank srtx ? Bike)

Note: The ! operator only require a literal to keep up with the syntax.

Minimum requirement for master.

/* Item Master */
#im =
/* Open Table F4101 */
f4101
/* Read the required Item Master Fields */
(litm,aitm,dsc1,srtx,uom1,glpt,stkt,lnty);

Item Branch Plant

Few logistic values for items in excel list items.

/* Item/Branch Master */
#ib =
/* Open Table F4102 */
f4102
/* Read the required Item Master Fields */
(mcu,litm,vend,sld,bbdd,roqi,rqmx,rqmn,ropi,safe)
/* Where LITM is in list items */
all(litm in @items);

Item Location

Item balance quantities for items in excel list items.

/* Item Location */
#il =
/* Open table F41021 */
f41021
/* Sum the Qty fields */
[sum(pqoh,pbck,preq,qwbo,hcom,pcom)
 group(itm,mcu)]
/* Where ITM is in list items */
all(mcu=M30 itm in @items);