09-19-2007 12:06 PM
Hi Experts,
I am facing one problem. I need to write the logic for the following case.
Based on object name and No. range no. I need to pick from number and To number from the table NRIV. After that from VEKP table I need to give from number and to number which I got from NRIV
As range to EXIDV field in the VEKP table and I need to pick recent handling unit number. Please help me about how I can build the logic for this.
Thanks a lot.
09-19-2007 12:28 PM
select single A B( REPLACE WITH ORIGIONAL FIELDS WHICH YOU REQUIRE) from NRIV into (w_from, w_to) where objectname eq 'objectname' and
rangeno eq rangeno.
SELECT MAX(HANDLING UNIT NUMBER) FROM VEKP
INTO W_HANDLING_NUMBER WHERE
EXIDV GE W_FROM AND
EXDIV LE W_TO.
IT SURELY RESOLVE YOUR PROBLEM,
REWARD IF USEFUL.
AMIT SINGLA
09-19-2007 12:28 PM
select single A B( REPLACE WITH ORIGIONAL FIELDS WHICH YOU REQUIRE) from NRIV into (w_from, w_to) where objectname eq 'objectname' and
rangeno eq rangeno.
SELECT MAX(HANDLING UNIT NUMBER) FROM VEKP
INTO W_HANDLING_NUMBER WHERE
EXIDV GE W_FROM AND
EXDIV LE W_TO.
IT SURELY RESOLVE YOUR PROBLEM,
REWARD IF USEFUL.
AMIT SINGLA