topic Re: regarding select stm in Application Development and Automation Discussions

regarding select stm

Former Member — Wed, 11 Jul 2007 07:36:39 GMT

hi experts,

when im executing this code it is giving me runtime error but the same with standard table is working.why...

please explain me.

DATA: WA TYPE SPFLI,

ITAB TYPE sorted TABLE OF SPFLI with unique key carrid .

SELECT connid FROM SPFLI INTO CORRESPONDING FIELDS OF TABLE ITAB.

LOOP AT ITAB INTO WA.

WRITE: / WA-CARRID,wa-connid.

ENDLOOP.

SKIP 1.

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 07:40:22 GMT

u must fetch carrid fom SPFLI since u have defined the internal table as uniques key of carrid.

alternatively , define internal table as type standard table of spfli.

reward points if helpful

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 07:40:52 GMT

Hi,

I could execute your given report.

Why do you require whole SPFLI table as you are selecting only connid?

Take only like,

data: itab like spfli-connid occurs...

and then

select connid into (--)

Reward if useful!

Re: regarding select stm

jaideeps — Wed, 11 Jul 2007 08:03:29 GMT

hi,

itz because spfli already conatins carrid as the key..in unique key..the field occurance should be once..i think they may be a clash between spfli and itab...

thanks

jaideep

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 08:11:35 GMT

HI,

DATA: WA TYPE SPFLI,

ITAB TYPE sorted TABLE OF SPFLI with unique key carrid .

SELECT <b>Carrid connid</b> FROM SPFLI INTO CORRESPONDING FIELDS OF TABLE ITAB.

LOOP AT ITAB INTO WA.

WRITE: / WA-CARRID,wa-connid.

ENDLOOP.

SKIP 1.

Regards

Sudheer

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 08:21:50 GMT

Why cant u try like thi s

REPORT  ZSDN1                                   .

data : begin of itab occurs 0,
       connid like spfli-connid,
       carrid like spfli-carrid,
       end of itab.

SELECT connid carrid FROM SPFLI INTO CORRESPONDING FIELDS OF itab.
LOOP AT ITAB .
WRITE: /  itab-carrid, itab-connid.
ENDLOOP.
*endselect.
SKIP 1.
endselect.

Reward all helpfull answers

Regards

Pavan

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 08:43:56 GMT

use this code

tables : spfli.

DATA: WA TYPE SPFLI,

ITAB TYPE standard TABLE OF SPFLI .

SELECT carrid connid FROM SPFLI INTO CORRESPONDING FIELDS OF TABLE ITAB.

LOOP AT ITAB INTO WA.

WRITE: / wa-carrid,wa-connid.

ENDLOOP.

SKIP 1.

reward if useful........

Re: regarding select stm

Former Member — Wed, 11 Jul 2007 11:12:57 GMT

data: itab like spfli-connid occurs...

and then

select connid into (--)

Reward if useful!