topic Logic in Application Development and Automation Discussions

Logic

Former Member — Wed, 19 Sep 2007 11:06:16 GMT

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.

Re: Logic

Former Member — Wed, 19 Sep 2007 11:28:40 GMT

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