topic Re: Runtime error is happening in Application Development and Automation Discussions

Runtime error is happening

Former Member — Mon, 23 Jun 2008 05:34:17 GMT

Dear Abap Experts,

There is no syntax error but i am facing runtime errors.

TABLES: SFLIGHT,SPFLI.

DATA: BEGIN OF ITAB_SFLIGHT OCCURS 0,

CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID,

FLDATE LIKE SFLIGHT-FLDATE,

PRICE LIKE SFLIGHT-PRICE,

CURRENCY LIKE SFLIGHT-CURRENCY,

CITYFROM LIKE SPFLI-CITYFROM,

AIRPFROM LIKE SPFLI-AIRPFROM,

PLANETYPE LIKE SFLIGHT-PLANETYPE,

END OF ITAB_SFLIGHT.

DATA: ITAB LIKE STANDARD TABLE OF ITAB_SFLIGHT,

WA_ITAB LIKE LINE OF ITAB.

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM)

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON A_{CONNID = B}CONNID .

INSERT ITAB_SFLIGHT INTO ITAB.

ENDSELECT.

LOOP AT ITAB INTO WA_ITAB.

WRITE: WA_ITAB-CARRID,WA_ITAB-FLDATE,

WA_ITAB-CITYFROM,WA_ITAB-AIRPFROM.

ENDLOOP.

Re: Runtime error is happening

Former Member — Mon, 23 Jun 2008 05:50:38 GMT

Replaced insert with append its working



TABLES: SFLIGHT,SPFLI.

DATA: BEGIN OF ITAB_SFLIGHT OCCURS 0,
CARRID LIKE SFLIGHT-CARRID,
CONNID LIKE SFLIGHT-CONNID,
FLDATE LIKE SFLIGHT-FLDATE,
PRICE LIKE SFLIGHT-PRICE,
CURRENCY LIKE SFLIGHT-CURRENCY,
CITYFROM LIKE SPFLI-CITYFROM,
AIRPFROM LIKE SPFLI-AIRPFROM,
PLANETYPE LIKE SFLIGHT-PLANETYPE,
END OF ITAB_SFLIGHT.

DATA: ITAB LIKE STANDARD TABLE OF ITAB_SFLIGHT,
WA_ITAB LIKE LINE OF ITAB.

SELECT A~CARRID A~FLDATE A~PRICE B~CITYFROM B~AIRPFROM INTO
(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,
ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM)
FROM SFLIGHT AS A INNER JOIN SPFLI AS B
ON A~CONNID = B~CONNID .
APPEND ITAB_SFLIGHT TO ITAB.
ENDSELECT.


LOOP AT ITAB INTO WA_ITAB.
WRITE:/ WA_ITAB-CARRID, WA_ITAB-FLDATE,
WA_ITAB-CITYFROM, WA_ITAB-AIRPFROM.
ENDLOOP.

Re: Runtime error is happening

Former Member — Mon, 23 Jun 2008 06:07:37 GMT

do the following modification it will work

SELECT A_{CARRID A}FLDATE A_{PRICE B}CITYFROM B~AIRPFROM INTO

(ITAB_SFLIGHT-CARRID,ITAB_SFLIGHT-FLDATE,ITAB_SFLIGHT-PRICE,

ITAB_SFLIGHT-CITYFROM,ITAB_SFLIGHT-AIRPFROM)

FROM SFLIGHT AS A INNER JOIN SPFLI AS B

ON A_{CONNID = B}CONNID .

Append ITAB_SFLIGHT TO ITAB.

ENDSELECT.

Reward Points if helpfull

Cheers

Snehi

Re: Runtime error is happening

Former Member — Mon, 23 Jun 2008 06:26:13 GMT

Hi,

we can use COLLECT also. This have the advantage of adding the values of its numeric components to the corresponding values of existing rows with the same key.


*  INSERT ITAB_SFLIGHT INTO ITAB.
  COLLECT ITAB_SFLIGHT INTO ITAB.

regards,

teja.