topic Re: ITAB LOOP in Application Development and Automation Discussions

ITAB LOOP

Former Member — Wed, 05 Jul 2006 21:33:54 GMT

HI,

this is program i got and trying to execute..

REPORT sapbc400tss_itab_loop .

DATA: it_spfli TYPE sbc400_t_spfli.

DATA: wa_spfli TYPE spfli.

START-OF-SELECTION.

SELECT * FROM spfli INTO TABLE it_spfli.

IF sy-subrc = 0.

LOOP AT it_spfli INTO wa_spfli.

WRITE: / wa_spfli-carrid,

wa_spfli-connid,

wa_spfli-cityfrom,

wa_spfli-cityto,

wa_spfli-deptime,

wa_spfli-arrtime.

ENDLOOP.

ENDIF.

Its saying Type "sbc400_t_spfli" is unknown, i doubled click on that to check, but it does't exists. How to create that type sbc400_t_spfli, whats the syntax..

Thanks

Re: ITAB LOOP

Former Member — Wed, 05 Jul 2006 21:38:05 GMT

types: sbc400_t_spfli type standard table of spfli.

add this statement right after report statement.

Otherwise declare it_spfli as an internal table.

data: it_spfli like spfli occurs 0.

declare

thanks,

Rajesh.

Message was edited by: Rajesh Mandalapu

Re: ITAB LOOP

Manohar2u — Wed, 05 Jul 2006 21:38:08 GMT

Can you try like below

DATA: it_spfli <b>LIKE</b> sbc400_t_spfli

DATA: it_spfli like spfli

Regds

Manohar

Message was edited by: Manohar Reddy

Re: ITAB LOOP

Former Member — Wed, 05 Jul 2006 21:41:27 GMT

Hello Sir,

You need a book ---> Learn abap here

http://cma.zdnet.com/book/abap/index.htm

REPORT sapbc400tss_itab_loop .

DATA: it_spfli LIKE spfli occurs 0 with header line.

DATA: wa_spfli LIKE spfli.

START-OF-SELECTION.

SELECT * FROM spfli INTO TABLE it_spfli.

IF sy-subrc = 0.

LOOP AT it_spfli INTO wa_spfli.

WRITE: / wa_spfli-carrid,

wa_spfli-connid,

wa_spfli-cityfrom,

wa_spfli-cityto,

wa_spfli-deptime,

wa_spfli-arrtime.

ENDLOOP.

ENDIF.

Re: ITAB LOOP

Former Member — Wed, 05 Jul 2006 21:43:23 GMT

You can also:

DATA: it_spfli TYPE spfli_tab.
DATA: wa_spfli TYPE spfli.

START-OF-SELECTION.
  SELECT * FROM spfli INTO TABLE it_spfli.

  IF sy-subrc = 0.
    LOOP AT it_spfli INTO wa_spfli.
      WRITE: / wa_spfli-carrid,
      wa_spfli-connid,
      wa_spfli-cityfrom,
      wa_spfli-cityto,
      wa_spfli-deptime,
      wa_spfli-arrtime.
    ENDLOOP.
  ENDIF.

Rob

PS - If you change your thread to a question, you might get more responses.

Message was edited by: Rob Burbank

Re: ITAB LOOP

Former Member — Wed, 05 Jul 2006 22:42:12 GMT

Hi,

The Program goes like this,

REPORT Z_ITAB_LOOP.

TYPES: SBC400_T_SPFLI TYPE STANDARD TABLE OF SPFLI.

*Note STANDARD TABLE is one of the Internal Tables Types,

*to gain more, place cursor on it and press F1

DATA: IT_SPFLI TYPE SBC400_T_SPFLI.

DATA: WA_SPFLI TYPE SPFLI.

START-OF-SELECTION.

SELECT * FROM SPFLI INTO TABLE IT_SPFLI.

IF SY-SUBRC = 0.

LOOP AT IT_SPFLI INTO WA_SPFLI.

WRITE: / WA_SPFLI-CARRID,

WA_SPFLI-CONNID,

WA_SPFLI-CITYFROM,

WA_SPFLI-CITYTO,

WA_SPFLI-DEPTIME,

WA_SPFLI-ARRTIME.

ENDLOOP.

ENDIF.

Note: Program will display only record without Field Lables.

Better to gain knowledge on basics first.

Goodday.

Re: ITAB LOOP

Former Member — Wed, 05 Jul 2006 22:42:45 GMT

HI Jen,

Do this way ...

DATA: IT_SPFLI LIKE SPFLI OCCURS 0.
DATA: WA_SPFLI TYPE SPFLI.

START-OF-SELECTION.
  SELECT * FROM SPFLI INTO TABLE IT_SPFLI.

  IF SY-SUBRC = 0.
    LOOP AT IT_SPFLI INTO WA_SPFLI.
      WRITE: / WA_SPFLI-CARRID,
      WA_SPFLI-CONNID,
      WA_SPFLI-CITYFROM,
      WA_SPFLI-CITYTO,
      WA_SPFLI-DEPTIME,
      WA_SPFLI-ARRTIME.
    ENDLOOP.
  ENDIF.

Regards,

Santosh