Internal table query

[raguraman_c]

Hi,

I have defined structures c1 to c100 of type internal table key_Data. Now after i get values in all these C1 to C100. I need to insert them into key_data. Always it can be done as

Insert C1 into Key_data.

Insert C2 into Key_data.

.

.

.

.

Insert C100 into Key_data.

Instead of inserting one by one can I have a single line of code or simple code to populate key_Data. Any help would certainly be rewarded.

Please help.

--Ragu

[raguraman_c]

Hi Experts,

Please help.

Points Guaranteed.

--Ragu

[Former Member]

use append command

it will work correctly

[Former Member]

why are you populating 100 structures first and then inserting in an internal table. why not populate just one structure repeatedly in a loop and then append it to the table.

do 100 times. "or whatever your loop condition

<populate structure>

append structure to itab.

clear structure.

enddo.

can you paste your code how you are populating your 100 structures?

regards,

Priyank

[raguraman_c]

Hi,

Thanks,

This is structure definition

c_k1 TYPE key_s_data VALUE '0G_QVVBQY KYFSUMC020100',

c_k2 TYPE key_s_data VALUE '0G_AVVD01 KYFSUMC021100',

c_k3 TYPE key_s_data VALUE '0G_AVVD02 KYFSUMC022100',

c_k4 TYPE key_s_data VALUE '0G_AVVD03 KYFSUMC023100',

c_k5 TYPE key_s_data VALUE '0G_AVVD04 KYFSUMC024100',

c_k6 TYPE key_s_data VALUE '0G_AVVD05 KYFSUMC025100',

This is how I insert how can I avoid this.

INSERT c_k1 INTO TABLE key_t_data.

INSERT c_k2 INTO TABLE key_t_data.

INSERT c_k3 INTO TABLE key_t_data.

INSERT c_k4 INTO TABLE key_t_data.

INSERT c_k5 INTO TABLE key_t_data.

INSERT c_k6 INTO TABLE key_t_data.

INSERT c_k7 INTO TABLE key_t_data.

INSERT c_k8 INTO TABLE key_t_data.

INSERT c_k9 INTO TABLE key_t_data.

INSERT c_k10 INTO TABLE key_t_data.

INSERT c_k11 INTO TABLE key_t_data.

INSERT c_k12 INTO TABLE key_t_data.

INSERT c_k13 INTO TABLE key_t_data.

INSERT c_k14 INTO TABLE key_t_data.

INSERT c_k15 INTO TABLE key_t_data.

INSERT c_k16 INTO TABLE key_t_data.

INSERT c_k17 INTO TABLE key_t_data.

INSERT c_k18 INTO TABLE key_t_data.

INSERT c_k19 INTO TABLE key_t_data.

INSERT c_k20 INTO TABLE key_t_data.

INSERT c_k21 INTO TABLE key_t_data.

INSERT c_k22 INTO TABLE key_t_data.

INSERT c_k23 INTO TABLE key_t_data.

INSERT c_k24 INTO TABLE key_t_data.

INSERT c_k25 INTO TABLE key_t_data.

INSERT c_k26 INTO TABLE key_t_data.

INSERT c_k27 INTO TABLE key_t_data.

INSERT c_k28 INTO TABLE key_t_data.

INSERT c_k29 INTO TABLE key_t_data.

INSERT c_k30 INTO TABLE key_t_data.

INSERT c_k34 INTO TABLE key_t_data.

INSERT c_k35 INTO TABLE key_t_data.

INSERT c_k36 INTO TABLE key_t_data.

INSERT c_k37 INTO TABLE key_t_data.

INSERT c_k38 INTO TABLE key_t_data.

INSERT c_k39 INTO TABLE key_t_data.

INSERT c_k40 INTO TABLE key_t_data.

INSERT c_k41 INTO TABLE key_t_data.

INSERT c_k42 INTO TABLE key_t_data.

INSERT c_k43 INTO TABLE key_t_data.

INSERT c_k44 INTO TABLE key_t_data.

INSERT c_k45 INTO TABLE key_t_data.

INSERT c_k46 INTO TABLE key_t_data.

INSERT c_k47 INTO TABLE key_t_data.

INSERT c_k48 INTO TABLE key_t_data.

INSERT c_k49 INTO TABLE key_t_data.

INSERT c_k50 INTO TABLE key_t_data.

INSERT c_k51 INTO TABLE key_t_data.

INSERT c_k52 INTO TABLE key_t_data.

INSERT c_k53 INTO TABLE key_t_data.

INSERT c_k54 INTO TABLE key_t_data.

INSERT c_k55 INTO TABLE key_t_data.

INSERT c_k56 INTO TABLE key_t_data.

INSERT c_k57 INTO TABLE key_t_data.

INSERT c_k58 INTO TABLE key_t_data.

INSERT c_k59 INTO TABLE key_t_data.

INSERT c_k60 INTO TABLE key_t_data.

INSERT c_k61 INTO TABLE key_t_data.

INSERT c_k62 INTO TABLE key_t_data.

INSERT c_k63 INTO TABLE key_t_data.

INSERT c_k64 INTO TABLE key_t_data.

INSERT c_k65 INTO TABLE key_t_data.

INSERT c_k66 INTO TABLE key_t_data.

INSERT c_k67 INTO TABLE key_t_data.

INSERT c_k68 INTO TABLE key_t_data.

INSERT c_k69 INTO TABLE key_t_data.

INSERT c_k70 INTO TABLE key_t_data.

INSERT c_k71 INTO TABLE key_t_data.

INSERT c_k72 INTO TABLE key_t_data.

INSERT c_k73 INTO TABLE key_t_data.

INSERT c_k74 INTO TABLE key_t_data.

INSERT c_k75 INTO TABLE key_t_data.

INSERT c_k76 INTO TABLE key_t_data.

INSERT c_k77 INTO TABLE key_t_data.

INSERT c_k78 INTO TABLE key_t_data.

INSERT c_k79 INTO TABLE key_t_data.

INSERT c_k80 INTO TABLE key_t_data.

INSERT c_k81 INTO TABLE key_t_data.

INSERT c_k82 INTO TABLE key_t_data.

INSERT c_k83 INTO TABLE key_t_data.

INSERT c_k84 INTO TABLE key_t_data.

INSERT c_k85 INTO TABLE key_t_data.

INSERT c_k86 INTO TABLE key_t_data.

INSERT c_k87 INTO TABLE key_t_data.

INSERT c_k88 INTO TABLE key_t_data.

INSERT c_k89 INTO TABLE key_t_data.

INSERT c_k90 INTO TABLE key_t_data.

INSERT c_k91 INTO TABLE key_t_data.

INSERT c_k92 INTO TABLE key_t_data.

INSERT c_k93 INTO TABLE key_t_data.

INSERT c_k94 INTO TABLE key_t_data.

Please help Points guaranteed.

--Ragu

[naveen1241]

hi Ragu,

try this...

FIELD-SYMBOLS: <fs>.

data: str(6) VALUE 'c_k',

str1(3) .

do 100 times.

str1 = sy-index.

concatenate str str1 into str.

ASSIGN (str) TO <fs>.

INSERT <fs> INTO TABLE key_t_data.

str = 'c_k'.

enddo.

use sy-index instead of sy-tabix.

Regards,

Naveen Natarajan

Message was edited by:

Naveen Natarajan

[raguraman_c]

Thanks a lot Naveen, solved my problem. More questions in the horizon, keep watching. Help me solve.

Thanks again.

--Ragu

[Former Member]

HI,

Use FIELD SYMBOLS....

[Former Member]

Hi Raghu,

Try to loop at Key_data and assign all the required structures to it by statement APPEND,MODIFY, MOVE

Rewards helpfull,

Reagrds,

Pavan

[Former Member]

Hi Raguram

Use this type of code in your program

data:
  w_char1 value 'C',
  w_int(3) type c,
  w_str(4).


do 100 times.
  move sy-index to w_int.
  condense w_int.
  concatenate w_char1 w_int into w_str.
  write: / w_str.
enddo.

Regards Rk

[Former Member]

Hi Raguram,

in continuation with RK's soln i am adding one more.

Do 100 times.

inset w_str to read_table.

enddo.

all the best.

Rgds,

Mahesh.Gattu

[Former Member]

Hi Ragu,

Use following code in ur program.

data : n type i value '0'.

data : temp(10).

do 100 times.

n = n + 1.

concatenate c_k n to temp.

append temp to key_t_data.

enddo.

Reward points if helpful.

Regards,

Hemant

[naveen1241]

temp is string typ....

how can u append temp to the internal table key_t_data.

whose type u dont knw...

Regards,

Naveen

[Former Member]

Hi

I think This code will work,,

just execute this code

Report y_test.

data:
  w_char1(3) value 'C_K',
  w_int(3) type c,
  w_str(6).
data:
 key_t_data like table of spfli,

 FIELD-SYMBOLS: <fs>.

do 100 times.
  move sy-index to w_int.
  condense w_int.
  concatenate w_char1 w_int into w_str.
  ASSIGN w_str TO <fs>.
 insert <fs> into TABLE key_t_data.
enddo.

Regardrs Rk