At Line-selection

[rupali_bhalerao]

Hi Experts,

I am developing interactive report in that basic list is from SCARR table & the secondary list is SPFLI table.

when I am double clicking on carrid of the basic list then it should give me the spfli details of that carrid.

I am using select-options ,

but the problem is,

when I am giving the range it shows me the higher (options) data in secondary list.

i.e, range is AA to AZ.

when I double click on AA or any carrid it gives the detail report of AZ.

need help.

thanx.

[rupali_bhalerao]

REPORT ZSRK_071 .

TABLES : SCARR.

SELECT-OPTIONS : S_CARRID FOR SCARR-CARRID.

DATA : IT_SCARR LIKE SCARR OCCURS 0 WITH HEADER LINE,

IT_SPFLI LIKE SPFLI OCCURS 0 WITH HEADER LINE.

DATA : CF1(15),

L_CARRID LIKE SCARR-CARRID.

AT LINE-SELECTION.

GET CURSOR FIELD CF1 VALUE L_CARRID.

SY-LSIND = 1.

LOOP AT IT_SPFLI WHERE CARRID = L_CARRID.

WRITE : / IT_SPFLI-CARRID , IT_SPFLI-CONNID, IT_SPFLI-COUNTRYFR,

IT_SPFLI-CITYFROM, IT_SPFLI-COUNTRYTO, IT_SPFLI-CITYTO,

IT_SPFLI-FLTIME, IT_SPFLI-DEPTIME, IT_SPFLI-ARRTIME.

ENDLOOP.

START-OF-SELECTION.

SELECT * FROM SCARR

INTO TABLE IT_SCARR

WHERE CARRID IN S_CARRID.

IF NOT IT_SCARR[] IS INITIAL.

SELECT * FROM SPFLI

INTO TABLE IT_SPFLI

FOR ALL ENTRIES IN IT_SCARR

WHERE CARRID EQ IT_SCARR-CARRID.

ENDIF.

SORT IT_SPFLI BY CARRID.

LOOP AT IT_SCARR.

HIDE : IT_SCARR-CARRID,

IT_SCARR-CARRNAME,

IT_SCARR-CURRCODE.

WRITE : / IT_SCARR-CARRID, IT_SCARR-CARRNAME, IT_SCARR-CURRCODE.

ENDLOOP.

[Sandeep_Panghal]

Can you share your code here....

[rupali_bhalerao]

Hi experts,

it's a simple code.

At line-selection.

case sy-lsind.

when '1'.

SELECT CARRID CONNID COUNTRYFR CITYFROM COUNTRYTO CITYTO

FROM SPFLI

INTO CORRESPONDING FIELDS OF TABLE IT_SPFLI

WHERE CARRID = IT_SCARR-CARRID AND CARRID IN S_CARRID.

LOOP AT IT_SPFLI.

WRITE : / IT_SPFLI-CARRID,

IT_SPFLI-CONNID,

IT_SPFLI-COUNTRYFR,

IT_SPFLI-CITYFROM,

IT_SPFLI-COUNTRYTO,

IT_SPFLI-CITYTO.

ENDLOOP.

ENDCASE.

[Sandeep_Panghal]

Use : HIDE IT_SPFLI-CARRID.

[Former Member]

REPORT ZSRK_071 .

TABLES : SCARR.

SELECT-OPTIONS : S_CARRID FOR SCARR-CARRID.

DATA : IT_SCARR LIKE SCARR OCCURS 0 WITH HEADER LINE,

IT_SPFLI LIKE SPFLI OCCURS 0 WITH HEADER LINE.

DATA : CF1(15),

L_CARRID LIKE SCARR-CARRID.

AT LINE-SELECTION.

GET CURSOR FIELD CF1 VALUE L_CARRID.

SY-LSIND = 1.

LOOP AT IT_SPFLI WHERE CARRID = L_CARRID.

WRITE : / IT_SPFLI-CARRID , IT_SPFLI-CONNID, IT_SPFLI-COUNTRYFR,

IT_SPFLI-CITYFROM, IT_SPFLI-COUNTRYTO, IT_SPFLI-CITYTO,

IT_SPFLI-FLTIME, IT_SPFLI-DEPTIME, IT_SPFLI-ARRTIME.

ENDLOOP.

START-OF-SELECTION.

SELECT * FROM SCARR

INTO TABLE IT_SCARR

WHERE CARRID IN S_CARRID.

IF NOT IT_SCARR[] IS INITIAL.

SELECT * FROM SPFLI

INTO TABLE IT_SPFLI

FOR ALL ENTRIES IN IT_SCARR

WHERE CARRID EQ IT_SCARR-CARRID.

ENDIF.

SORT IT_SPFLI BY CARRID.

LOOP AT IT_SCARR.

HIDE : IT_SCARR-CARRID,

IT_SCARR-CARRNAME,

IT_SCARR-CURRCODE.

WRITE : / IT_SCARR-CARRID, IT_SCARR-CARRNAME, IT_SCARR-CURRCODE.

ENDLOOP.

[rupali_bhalerao]

Problem solved.

Thanx sreekanth reddy .