topic Re: sql-command on internal table in Application Development and Automation Discussions

sql-command on internal table

Former Member — Mon, 22 Jan 2007 08:25:30 GMT

Hi,

is it possible to perform sql-command on internal table as below

shown. If not, which alternatives are given.

SELECT COUNT( DISTINCT kunnr ) from itab into table itab2

I have the following situation:

Internal table "itab" contains many datas with various custumers. I want

to collect the unique customernumber in another internal table e.x itab2.

Regards

Ilhan

Re: sql-command on internal table

Former Member — Mon, 22 Jan 2007 08:26:54 GMT

hi,

<b>No you cannot use those statements for internal table as SQL Commands are for database tables only ..</b>

Regards,

Santosh

Re: sql-command on internal table

Former Member — Mon, 22 Jan 2007 08:27:05 GMT

No it will not work. SELECT statement will not work on internal tables. It can be used only on database tables and views.

If you want to SUM an internal table field, you will have to loop the table and then sum it up manually.

Manoj

Re: sql-command on internal table

Former Member — Mon, 22 Jan 2007 08:28:04 GMT

it should work....

if not write this way...

SELECT DISTINCT kunnr from <database> into table itab2.

describe table itab2 lines v_lines.....

Re: sql-command on internal table

Former Member — Mon, 22 Jan 2007 08:29:57 GMT

Hi Ilhan,

You cannot perform SQL commands on internal tables.

To get the unique customers from an internal table like this:

DATA itab2 LIKE TABLE OF itab.
DATA v_cus TYPE i.

itab2[] = itab[].

SORT itab2 BY kunnr.

DELETE ADJACENT DUPLICATES FROM itab2 COMPARING kunnr.
"itab2 will have unique customers

DESCRIBE TABLE itab2 LINES v_cus.
"v_cus will have the count of unique customers.

Regards

Wenceslaus

Re: sql-command on internal table

andreas_mann3 — Mon, 22 Jan 2007 08:31:00 GMT

Hi,

no, you must do sth like this:

loop at itab into itab2. 
 collect itab2.
endloop.

describe table itab2 lines sy-tfill.