topic Re: Regarding Ranges.. in Application Development and Automation Discussions

Regarding Ranges..

Former Member — Tue, 25 Nov 2008 05:35:04 GMT

Experts..

i am having customers in internal table , i want to move this customers in to ranges internal table to get the data from database. plz suggest hw can i move this

Reagards

Spanadana

Re: Regarding Ranges..

kesavadas_thekkillath — Tue, 25 Nov 2008 05:39:18 GMT

its better to go for "for all entries"

for Ex: select * from kna1 into table itab for all entries in itab2

where kunnr = itab2-kunnr.

if u want it to move to ranges then.

ranges:ra_kunnr for kna1-kunnr.

ra_kunnr-option = 'EQ'.

ra_kunnr-sign = 'I'.

loop at itab2.

ra_kunnr-low = itab2-kunnr.

collect ra_kunnr.

endloop.

select * from kna1 into table itab

where kunnr in ra_kunnr.

Re: Regarding Ranges..

Former Member — Tue, 25 Nov 2008 05:40:17 GMT

loop at itab into wa_itab.

<range>-sign = c_i.

<range>-option = c_eq.

<range>-low = wa_itab-<customer>.

append <range>.

endloop.

Re: Regarding Ranges..

Former Member — Tue, 25 Nov 2008 05:41:33 GMT

Hello


RANGES: R_KUNNR FOR KNA1-KUNNR.
LOOP AT ITAB.
  R_KUNNR-SIGN = 'I'.
  R_KUNNR-OPTION = 'EQ'.
  R_KUNNR-LOW = ITAB-KUNNR.
  APPEND R_KUNNR.
ENDLOOP.

Re: Regarding Ranges..

Former Member — Tue, 25 Nov 2008 05:44:32 GMT

Hi,

You can do as below:


ranges : gr_cust for kna1-kunnr.

"Assuming u have all your customer number in itab and gs_tab is strcuture

Sort itab by kunnr descending.

read table itab index 1 into gs_tab..

gr_cust-option = 'BT'.
gr_cust-sign = 'I'.
gr_cust-high = itab-lifnr.

Sort itab by kunnr.
gr_cust-low. = itab-lifnr.

append gr_cust.

"Now you will hav the high and low values of the customer in the ranges and you can use 
gr_cust in your select statement.

Thanks,

Sriram Ponna.

Re: Regarding Ranges..

SuhaSaha — Tue, 25 Nov 2008 05:45:39 GMT

Hello Spandana,

Plz try this bit of code:


DATA:
  R_KUNNR  TYPE RANGE OF KUNNR,
  WA_KUNNR LIKE LINE OF R_KUNNR.

LOOP AT IT_KNA1 INTO WA_KNA1.
  WA_KUNNR-SIGN = 'I'.
  WA_KUNNR-OPTION = 'EQ'.
  WA_KUNNR-LOW = WA_KNA1-KUNNR.

  APPEND WA_KUNNR TO R_KUNNR.
  CLEAR WA_KUNNR.
ENDLOOP.

R_KUNNR is a RANGE table containing customer nos. You can use R_KUNNR for ur further selection.

Hope this helps.

BR,

Suhas

Re: Regarding Ranges..

Former Member — Tue, 25 Nov 2008 05:50:53 GMT

Hi,

Once you get the required data into your internal table, you can loop the internal table and pass those values into the ranges you have declared.

sample code:-

TYPES: BEGIN OF ty_kunnr,

kunnr TYPE kunnr,

END OF ty_kunnr.

DATA: it_kunnr TYPE TABLE OF ty_kunnr,

wa_kunnr TYPE ty_kunnr,

r_kunnr TYPE RANGE OF kna1-kunnr,

wa_r_kunnr LIKE LINE OF r_kunnr.

SELECT kunnr FROM kna1 INTO TABLE it_kunnr.

LOOP AT it_kunnr INTO wa_kunnr.

wa_r_kunnr-option = 'EQ'.

wa_r_kunnr-sign = 'I'.

wa_r_kunnr-low = wa_kunnr-kunnr.

append wa_r_kunnr to r_kunnr.

ENDLOOP.