Logic

[Former Member]

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.

[Former Member]

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