topic Re: Internal table query in Application Development and Automation Discussions

Internal table query

raguraman_c — Fri, 27 Apr 2007 05:18:01 GMT

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

Re: Internal table query

raguraman_c — Fri, 27 Apr 2007 06:06:55 GMT

Hi Experts,

Please help.

Points Guaranteed.

--Ragu

Re: Internal table query

Former Member — Fri, 27 Apr 2007 06:11:49 GMT

use append command

it will work correctly

Re: Internal table query

Former Member — Fri, 27 Apr 2007 06:20:33 GMT

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

append structure to itab.

clear structure.

enddo.

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

regards,

Priyank

Re: Internal table query

Former Member — Fri, 27 Apr 2007 06:20:34 GMT

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

Re: Internal table query

Former Member — Fri, 27 Apr 2007 06:21:13 GMT

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

Re: Internal table query

raguraman_c — Fri, 27 Apr 2007 06:31:54 GMT

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

Re: Internal table query

Former Member — Fri, 27 Apr 2007 06:39:09 GMT

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

Re: Internal table query

naveen1241 — Fri, 27 Apr 2007 07:07:25 GMT

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

Re: Internal table query

Former Member — Fri, 27 Apr 2007 07:13:46 GMT

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

Re: Internal table query

naveen1241 — Fri, 27 Apr 2007 07:24:56 GMT

temp is string typ....

how can u append temp to the internal table key_t_data.

whose type u dont knw...

Regards,

Naveen

Re: Internal table query

Former Member — Fri, 27 Apr 2007 07:34:36 GMT

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

Re: Internal table query

raguraman_c — Fri, 27 Apr 2007 07:47:20 GMT

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

Thanks again.

--Ragu

Re: Internal table query

Former Member — Fri, 27 Apr 2007 08:21:48 GMT

HI,

Use FIELD SYMBOLS....