topic Re: Describe table in Application Development and Automation Discussions

Describe table

Former Member — Thu, 05 Apr 2007 10:47:31 GMT

what is the use of DESCRIBE TABLE command

Re: Describe table

Former Member — Thu, 05 Apr 2007 10:49:24 GMT

it gives you the properties of an internal table

for example:

DATA L_LINES TYPE I.

DESCRIBE TABLE LINES L_LINES.

now L_LINES contains the number of lines/rows in the internal table filled...

pls refer to the following links for more information

<a href="http://help.sap.com/saphelp_45b/helpdata/en/34/8e72fc6df74873e10000009b38f9b8/content.htm">http://help.sap.com/saphelp_45b/helpdata/en/34/8e72fc6df74873e10000009b38f9b8/content.htm</a>

<a href="

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3798358411d1829f0000e829fbfe/content.htm

">http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3798358411d1829f0000e829fbfe/content.htm</a>

[url]http://help.sap.com/saphelp_40b/helpdata/en/fc/eb3798358411d1829f0000e829fbfe/content.htm

[/url]

hope this info helps...

thx

pavan

**pls reward for helpful answers

Re: Describe table

Former Member — Thu, 05 Apr 2007 10:50:14 GMT

It's to get some characteristics of an internal table as the numbers of records:

DESCRIBE TABLE ITAB LINES V_LINES.

See the help for more details

Max

Re: Describe table

Former Member — Thu, 05 Apr 2007 10:52:02 GMT

Hi Jeya sree,

To determine the number of rows in an internal table, use the sy-tfill variable. It is set by the describe table statement.

Syntax for the describe table Statement

The following is the syntax for the describe table statement.

describe table it [lines i] [occurs j].

where:

it is the name of an internal table.

i and j are numeric variables.

This statement fills the three system variables.

DESCRIBE TABLE Statement Fills These System Variables

Variable Value

sy-tfill Number of rows

sy-tleng Length of a row in bytes

sy-toccu Current value of the occurs clause

The following points apply:

If the lines i addition is specified, the number of rows is placed in both sy-tfill and i.

If the occurs j addition is specified, the size of the occurs clause is placed in both sy-toccu and j.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: Describe table

Vijay — Wed, 11 Apr 2007 06:47:59 GMT

Hi ........

"DESCRIBE" statement is used for getting simple information about internal tables and I guess you want to acquire information about a database table. So, you can use the FM "DDIF_NAMETAB_GET" .

This FM will give technical information about the database table. To acquire the number of records you can use "SELECT COUNT( * ) " statement.

Hope this helps...

plz award pts if helpful.

Kind Regards

vijay

Re: Describe table

Former Member — Wed, 11 Apr 2007 09:41:18 GMT

hi,

To find out the attributes of an internal table at runtime that were not available statically, use the statement:

DESCRIBE TABLE itab [LINES lin] [OCCURS n] [KIND knd].

If you use the LINES parameter, the number of filled lines is written to the variable lin. If you use the OCCURS parameter, the value of the INITIAL SIZEof the table is returned to the variable n. If you use the KIND parameter, the table type is returned to the variable knd: ‘T’ for standard table, ‘S’ for sorted table, and ‘H’ for hashed table.

REPORT demo_int_tables_describe_table .

DATA: BEGIN OF line,

col1 TYPE i,

col2 TYPE i,

END OF line.

DATA itab LIKE HASHED TABLE OF line WITH UNIQUE KEY col1

INITIAL SIZE 10.

DATA: lin TYPE i,

ini TYPE i,

knd(1) TYPE c.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

DO 1000 TIMES.

line-col1 = sy-index.

line-col2 = sy-index ** 2.

INSERT line INTO TABLE itab.

ENDDO.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

The list output is:

0 10 H

1,000 10 H

Here, a hashed table itab is created and filled. The DESCRIBE TABLE statement is processed before and after the table is filled. The current number of lines changes, but the number of initial lines cannot change.

Re: Describe table

Former Member — Wed, 11 Apr 2007 11:59:28 GMT

Hi Jeya,

Describe table statement :

Describes the attributes of an internal table.

Syntax

DESCRIBE TABLE [LINES <l>] [OCCURS<n>] [KIND <k>].

Depending on the additions you use, writes the number of lines occupied, the value specified for the INITIAL SIZE of the table, or the table type into a corresponding variable.

Example code:

data : w_line type i.

describe table it_tab lines w_line.

if wa_line = 1.

read table it_tab into wa_tab.

endif.

Hence, this code helps to describe each record of the internal table it_tab with referred to w_line, that is, it specifies the record number.

Regards,

Thasneem

Re: Describe table

Former Member — Thu, 12 Apr 2007 05:33:27 GMT

hi,

This determines some properties of the internal table itab and assigns them to the specified variables. The various additions enable you to determine the table type, the number of currently filled rows and the initial memory requirement.

thnx.

Re: Describe table

Former Member — Thu, 12 Apr 2007 10:46:01 GMT

Hi,

Describe statement is useful to know the below things.

1)Return attributes of a field

2)Return attributes of an internal table

3)Determine distance between two fields

4)Return attributes of a list

If you want to know in detail then click F1 on Describe word and read the entire help.

thanks,

sksingh

Re: Describe table

Former Member — Fri, 13 Apr 2007 05:10:30 GMT

To find out the attributes of an internal table at runtime that were not available statically, use the statement:

DESCRIBE TABLE <itab> [LINES <l>] [OCCURS <n>] [KIND <k>].

If you use the LINES parameter, the number of filled lines is written to the variable <lin>. If you use the OCCURS parameter, the value of the INITIAL SIZE of the table is returned to the variable <n>. If you use the KIND parameter, the table type is returned to the variable <k>: ‘T’ for standard table, ‘S’ for sorted table, and ‘H’ for hashed table.

reward if helpful.

regards,

kiran kumar k

Re: Describe table

Former Member — Fri, 06 Jul 2007 12:04:29 GMT

hi Jeya Shree,

use of describe is to get the number of record/row/line in the intertable.

hope this clear the doubt

suppose a internal table has 5 enteries.

data: lv_lines type i.

describe table itab lines lv_lines.

write:/ 'number of line',lv_lines.

result or out put

hope this might give u a better idea

reward pionts if helpful.

anuj

Re: Describe table

Former Member — Fri, 06 Jul 2007 12:24:47 GMT

HI go through this document

To find out the attributes of an internal table at runtime that were not available statically, use the statement:

DESCRIBE TABLE itab [LINES lin] [OCCURS n] [KIND knd].

REPORT demo_int_tables_describe_table .

DATA: BEGIN OF line,

col1 TYPE i,

col2 TYPE i,

END OF line.

DATA itab LIKE HASHED TABLE OF line WITH UNIQUE KEY col1

INITIAL SIZE 10.

DATA: lin TYPE i,

ini TYPE i,

knd(1) TYPE c.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

DO 1000 TIMES.

line-col1 = sy-index.

line-col2 = sy-index ** 2.

INSERT line INTO TABLE itab.

ENDDO.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

The list output is:

0 10 H

1,000 10 H

Re: Describe table

Former Member — Fri, 06 Jul 2007 13:17:30 GMT

Hi,

To find out the attributes of an internal table at runtime that were not available statically, use the statement:

DESCRIBE TABLE itab [LINES lin] [OCCURS n] [KIND knd].

REPORT demo_int_tables_describe_table .

DATA: BEGIN OF line,

col1 TYPE i,

col2 TYPE i,

END OF line.

DATA itab LIKE HASHED TABLE OF line WITH UNIQUE KEY col1

INITIAL SIZE 10.

DATA: lin TYPE i,

ini TYPE i,

knd(1) TYPE c.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

DO 1000 TIMES.

line-col1 = sy-index.

line-col2 = sy-index ** 2.

INSERT line INTO TABLE itab.

ENDDO.

DESCRIBE TABLE itab LINES lin OCCURS ini KIND knd.

WRITE: / lin, ini, knd.

The list output is:

0 10 H

1,000 10 H

Pls reward points.

Regards,

Ameet

Re: Describe table

Former Member — Fri, 06 Jul 2007 13:22:03 GMT

This statement determines some properties of the internal table itab and assigns them to the specified variables. The various additions enable you to determine the table type, the number of currently filled rows and the initial memory requirement.In addition, the system fields sy-tfill and sy-tleng are filled with the current number

of table rows and the length of a table row in bytes.

Fields of Internal Tables

SY-TABIX

Current line of an internal table. SY-TABIX is set by the statements below, but only for index tables. The field is either not set or is set to 0 for hashed tables.

APPEND sets SY-TABIX to the index of the last line of the table, that is, it contains the overall number of entries in the table.

COLLECT sets SY-TABIX to the index of the existing or inserted line in the table. If the table has the type HASHED TABLE, SY-TABIX is set to 0.

LOOP AT sets SY-TABIX to the index of the current line at the beginning of each loop lass. At the end of the loop, SY-TABIX is reset to the value that it had before entering the loop. It is set to 0 if the table has the type HASHED TABLE.

READ TABLE sets SY-TABIX to the index of the table line read. If you use a binary search, and the system does not find a line, SY-TABIX contains the total number of lines, or one more than the total number of lines. SY-INDEX is undefined if a linear search fails to return an entry.

SEARCH <itab> FOR sets SY-TABIX to the index of the table line in which the search string is found.

SY-TFILL

After the statements DESCRIBE TABLE, LOOP AT, and READ TABLE, SY-TFILL contains the number of lines in the relevant internal table.

SY-TLENG

After the statements DESCRIBE TABLE, LOOP AT, and READ TABLE, SY-TLENG contains the length of the lines in the relevant internal table.

SY-TOCCU

After the statements DESCRIBE TABLE, LOOP AT, and READ TABLE, SY-TLENG contains the initial amount of memory allocated to the relevant internal table.

reward points if it is usefull ....

Girish

Re: Describe table

Former Member — Tue, 10 Jul 2007 07:45:51 GMT

Pl close this thread