topic internal table doubt?? in Application Development and Automation Discussions

internal table doubt??

Former Member — Fri, 09 Jun 2006 20:53:30 GMT

Hi all,

How to count the records available for specific select-option in the internal table..

e.g: select ebeln bukrs lfa1 from ekpo into table it1 where ebeln in so_ebeln.

loop at it1.

ekpo-ebeln,

ekpo-bukrs,

ekpo-lfa1,

endloop.

In the o/p i want the data and a variable which holds no. of records present...

Re: internal table doubt??

Former Member — Fri, 09 Jun 2006 20:55:42 GMT

Once you get all the records into an internal table, use the following statement.

DATA: v_record_count TYPE i.

DESCRIBE TABLE itab LINES v_record_count.

Re: internal table doubt??

former_member181966 — Fri, 09 Jun 2006 20:55:48 GMT

SY-DBCNT ( DB operations, number of table lines processed) from db tables after every Iteration and for internal table Sy-tabix ..

You can write

DATA: LN TYPE i.

Describe table itab lines LN..

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: internal table doubt??

Former Member — Fri, 09 Jun 2006 20:57:06 GMT

After loading the record in the internal table, you read the variable SY-DBCNT, here you can see the number of records you've loaded.

select ebeln bukrs lfa1 from ekpo into table it1 where ebeln in so_ebeln

n_record = sy-dbcnt.

Max

Re: internal table doubt??

Former Member — Fri, 09 Jun 2006 21:02:50 GMT

Hi all,

Can't we give the variable as character(C) because i want to concatenate after it..

because concatenate won't allow integer(i) variable...u know that..

Re: internal table doubt??

abdul_hakim — Fri, 09 Jun 2006 21:04:16 GMT

yes you can give..no issues...

Cheers,

Abdul

Please close the thread if ur question has been answered..

Re: internal table doubt??

Former Member — Fri, 09 Jun 2006 21:07:56 GMT

Move it to char variable

DATA DBCNT_C(5) TYPE C.

SELECT * FROM ....

MOVE SY-DBCNT TO DBCNT_C.

Max