Search This Blog

Tuesday, July 08, 2008

Serial controlled products - config lookup

ranges: r_sernp for t377p-serail.

* build selection option values macro
define m_sel_opt.
&5-sign = &1.
&5-option = &2.
&5-low = &3.
&5-high = &4.
append &5.
end-of-definition.

select serail into r_sernp-low
from t377p
where eqtyp = 'S'.
** append value to range
m_sel_opt: 'I' 'EQ' r_sernp-low '' r_sernp.
endselect.

***NOW THIS RANGE IS READY TO USE FOR YOUR MARC LOOKUP
SELECT *FROM MARCWHERE SERNP IN R_SERNP.

No comments: