topic Re: describe internal table in Application Development and Automation Discussions

describe internal table

Former Member — Wed, 26 Nov 2008 11:53:17 GMT

experts,

itab

field1 field2

A 1

B 3

C 5

D 6

above is the internal table( with field1 and field2) which contains 6 records .

how to count the number of records where field1 is not empty using ' describe statement only'

can it be done or not.

thanks in advance.

Re: describe internal table

former_member203501 — Wed, 26 Nov 2008 11:55:08 GMT

hi ,

use the count for this .....loop the internal table check the field .. if it is empty increment the count by one ...

REPORT Zpopup message-id zmsg.

data: begin of itab occurs 0,

field1 type c ,

field2 type c ,

end of itab .

itab-field1 = 'A'.

itab-field2 = '1' .

append itab .

itab-field1 = 'B'.

itab-field2 = ' ' .

append itab .

itab-field1 = 'C'.

itab-field2 = '2' .

append itab .

itab-field1 = 'C'.

itab-field2 = ' ' .

append itab .

itab-field1 = 'D'.

itab-field2 = '4' .

append itab .

data: v_count type i .

loop at itab .

if itab-field2 is initial .

v_count = v_count + 1 .

endif .

endloop .

write:/ v_count .

Edited by: venkat appikonda on Nov 26, 2008 1:07 PM

Re: describe internal table

agnihotro_sinha2 — Wed, 26 Nov 2008 11:55:18 GMT

hi,

transfer data to another table

delete rows from that table which are having empty first field.

find out the size of 2nd table using "describe table".

regards,

ags

Re: describe internal table

Former Member — Wed, 26 Nov 2008 11:55:27 GMT

HI,

No it cannot be done through the Describe table. Instead you need to loop through the internal table and calculate the count.

Re: describe internal table

Former Member — Wed, 26 Nov 2008 11:58:00 GMT

HI with out looping ur internal table only with describe statement its not possible to count.

Re: describe internal table

Former Member — Wed, 26 Nov 2008 11:58:45 GMT

write in loop and check sy-tabix value.

you cant do with describe statment.

Re: describe internal table

agnihotro_sinha2 — Wed, 26 Nov 2008 11:59:54 GMT

hi,

i dont understand why it cannot be done thru describe table...

if you copy the 1st table to a 2nd one and then delete the rows with Field1 NOT empty... and then find the size of the 2nd table using "describe table" the motif can be achieved.

later on delete this 2nd table.

regards,

ags

Re: describe internal table

Former Member — Wed, 26 Nov 2008 12:00:33 GMT

Delete itab where field1 is intial.

then use

describe table itab lines line.

regards

Ramchander Rao.K

Re: describe internal table

Former Member — Wed, 26 Nov 2008 12:01:26 GMT

Hi,

Cannot be done using describe stmt....

use two methods to do it...

1) loop the table and make a loop count with the condition on field1..

2) move the contents for which field1 is not empty to other temp table and then use describe for that temp table.....

Hope this will help.

Regards,

Rohan.

Re: describe internal table

Former Member — Wed, 26 Nov 2008 12:05:34 GMT

thanks experts for valuable answers.

Re: describe internal table

Former Member — Wed, 26 Nov 2008 12:09:13 GMT

Hi,

You can simply use the DESCRIBE statement like

Describe table t_table lines w_lines.

Loop at t_table into wa_table.
  If wa_table-field1 is initial.
    w_lines = w_lines - 1.
  Endif.
Endloop.

With luck,

Pritam.

Re: describe internal table

Former Member — Wed, 26 Nov 2008 12:11:44 GMT

Use this syntax:

DATA: lines(6) type N.

DISCRIBE TABLE <internal table name> LINES <lines>.

or Start debugging your program then observe value of SY-TFILL system variable while just executed that internal table statements.

Regards:

BBR.

Re: describe internal table

SachinArtani — Thu, 25 Jul 2019 11:35:17 GMT

Below code helps you to get number of lines without loop using describe statement only -

REPORT ztest.

DATA: w_lines TYPE i.

types: BEGIN OF ty_itab,
        field1 TYPE c,
        field2 TYPE c,
      END OF ty_itab.

data: itab type TABLE OF ty_itab,
      wa type ty_itab.


wa-field1 = 'A'. wa-field2 = '1' .
APPEND wa to itab.

wa-field1 = 'B'. wa-field2 = '2' .
APPEND wa to itab .

wa-field1 = 'C'. wa-field2 = '3' .
APPEND wa to itab .


wa-field1 = 'D'.wa-field2 = '4' .
APPEND wa to itab .

DESCRIBE TABLE itab LINES w_lines.

WRITE: / w_lines.

Rewards, if useful.

Thanks