topic Re: Regarding Select Query in Application Development and Automation Discussions

Regarding Select Query

Former Member — Mon, 21 May 2007 04:36:57 GMT

Hi Experts,

data: itab1 type table of i with header line.

if i specify type table of i as above, what will be the itab's type?

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:39:03 GMT

It is of type i :).

Regards,

Atish

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:45:17 GMT

usually we define like 'type table of dbtable'.

dbtable in this case will be a data base table.

here we are specifying type i....this means what???

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:49:10 GMT

Hi,

it may be a structure also .

Regards

Deepak.

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:50:35 GMT

in this case i can be a DB table, structure or a table type defined earlier in the code.

Revert back if you have further query.

Reward points if useful.

Regards,

Atish

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:50:53 GMT

Hi,

here I means integer type.

ur internal table itab will contain one column type integer.

rgds,

bharat.

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 04:58:55 GMT

Hi,

Here 'i' means integer type.

the statement :

data : itab1 type table of i with header line.

means that internal table itab1 has one column of type integer. The following example will make you things more clear.

REPORT ZTEST.

data : itab1 type table of i with header line.

itab1 = 6.

append itab1.

itab1 = 7.

append itab1.

loop at itab1.

write 😕 itab1.

endloop.

The output of this report will be : 6

I hope this would make things clear to you.

Re: Regarding Select Query

Former Member — Mon, 21 May 2007 05:04:16 GMT

Hi,

Then it will be a vector (one column) and will have only one col with type I.

Jogdand M B