topic Re: serial number column in Application Development and Automation Discussions

serial number column

Former Member — Wed, 20 May 2009 02:28:42 GMT

hi gurus,

I need one more column for serial number how to include that in below codings, can someone help me,


data : number type i.

data : begin of wa_kna1,
  kunnr type kunnr,
  name1 type name1,
  end of wa_kna1,
   it_kna1 like table of wa_kna1.
  data : begin of wa_table,
  number type i,
  kunnr type kunnr,
  name1 type name1,
  end of wa_table,
  it_table like table of wa_table.


select kunnr name1 into table it_kna1 from kna1 up to 12 rows.

 loop at it_kna1 into wa_kna1.
number = number + 1.
wa_table-kunnr = wa_kna1-kunnr.
wa_table-name1 = wa_kna1-name1.
*modify it_table from wa_table.
append wa_table to it_table.
clear : wa_table.
endloop.

loop at it_table into wa_table.
  write :
  / wa_table-kunnr,
   wa_table-name1,
   wa_table-number.
  endloop.

Thanks and Regards,

Thirukumaran. R

Re: serial number column

Former Member — Wed, 20 May 2009 02:40:07 GMT

*data : number type i.

data : begin of wa_kna1,

kunnr type kunnr,

name1 type name1,

end of wa_kna1,

it_kna1 like table of wa_kna1.

select kunnr name1 into table it_kna1 from kna1 up to 12 rows.

loop at it_kna1 into wa_kna1.

write:/ wa_kna1-kunnr,

wa_kna1-name1,

sy-tabix.

endloop.

Are these code helpful for you?

Edited by: lvzhqi lv on May 20, 2009 4:40 AM

Re: serial number column

former_member188827 — Wed, 20 May 2009 02:47:56 GMT

loop at it_table into wa_table.

write :

/sy-tabix,

wa_table-kunnr,

wa_table-name1. endloop.

Re: serial number column

Former Member — Wed, 20 May 2009 03:33:35 GMT

Hi,

I have made some small changes to your program and it is working finenow.

Check the code - -

DATA : number TYPE i.

DATA : BEGIN OF wa_kna1,
  kunnr TYPE kunnr,
  name1 TYPE name1,
  END OF wa_kna1,
   it_kna1 LIKE TABLE OF wa_kna1.
DATA : BEGIN OF wa_table,
          number TYPE i,
          kunnr TYPE kunnr,
          name1 TYPE name1,
       END OF wa_table,
it_table LIKE TABLE OF wa_table.


SELECT kunnr name1 INTO TABLE it_kna1 FROM kna1 UP TO 12 ROWS.

LOOP AT it_kna1 INTO wa_kna1.
  wa_table-number = wa_table-number + 1. " Changed 
  wa_table-kunnr = wa_kna1-kunnr.
  wa_table-name1 = wa_kna1-name1.
*modify it_table from wa_table.
  APPEND wa_table TO it_table.
*  CLEAR : wa_table.  " Commented
  CLEAR : wa_table-kunnr,  " Added
          wa_table-name1.  " Added
endloop.

  LOOP AT it_table INTO wa_table.
    WRITE :
    / wa_table-kunnr,
     wa_table-name1,
     wa_table-number.
  ENDLOOP.

Regards

Pinaki

Re: serial number column

Former Member — Wed, 20 May 2009 03:47:40 GMT

Hi Thirukumaran,

You can write the code in this way:

DATA : BEGIN OF wa_kna1,

kunnr type kunnr,

name1 type name1,

END OF wa_kna1,

it_kna1 TYPE STANDARD TABLE OF wa_kna1.

DATA : BEGIN OF wa_table,

number type i,

kunnr type kunnr,

name1 type name1,

END OF wa_table,

it_table TYPE STANDARD TABLE OF wa_table.

DATA: Ser_Num Type I.

START-OF-SELECTION.

SELECT kunnr name1 into table it_kna1 from kna1 up to 12 rows.

LOOP AT it_kna1 INTO wa_kna1.

Ser_num = Ser_Num + 1.

wa_table-number = ser_num.

wa_table-kunnr = wa_kna1-kunnr.

wa_table-name1 = wa_kna1-name1.

append wa_table to it_table.

endloop.

loop at it_table into wa_table.

write :

/ wa_table-kunnr,

wa_table-name1,

wa_table-number.

endloop.