topic Table type in Application Development and Automation Discussions

Table type

Former Member — Mon, 26 Mar 2007 06:40:54 GMT

Hi ,

Can anyone tell me the exact significance and usage of table types ?

if possible with some examples.

Useful answers will be rewarded.

Regards

Haritha

Re: Table type

Former Member — Mon, 26 Mar 2007 06:51:57 GMT

Hi Haritha.....

A table type describes the structure and functional attributes of an internal table in ABAP. In ABAP programs you can reference a table type YTEST defined in the ABAP Dictionary with the command DATA YTEST1 TYPE YTEST. An internal table YTEST1 is created in the program with the attributes defined for YTEST in the ABAP Dictionary.

A table type is defined by:

its line type, that defines the structure and data type attributes of a line of the internal table

the options for managing and accessing the data ( access mode) in the internal table

the key ( key definition and key category) of the internal table

you can see the following link.....

http://help.sap.com/saphelp_erp2005vp/helpdata/en/90/8d7304b1af11d194f600a0c929b3c3/frameset.htm

Reward points if useful......

Suresh......

Re: Table type

Former Member — Mon, 26 Mar 2007 06:55:12 GMT

Hi,

Transparent table, Pool table and cluster table are data dictionary table objects sorted table, indexed table and hash table are internal tables.

Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary. The data from several different tables can be stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table in the database in which all records from the pooled tables assigned to the table pool are stored corresponds to a table pool.

The definition of a pool consists essentially of two key fields (Tabname and Varkey) and a long argument field (Vardata).

Table Clusters Several logical data records from different cluster tables can be stored together in one physical

record in a table cluster.

A cluster key consists of a series of freely definable key fields and a field (Pageno) for distinguishing continuation records. A cluster also contains a long field (Vardata) that contains the contents of the data fields of the cluster tables for this key. If the data does not fit into the long field, continuation records are created. Control information on the structure of the data string is still written at the beginning of the Vardata field.

Hashed tables

This is the most appropriate type for any table where the main operation is key access. You cannot access a hashed table using its index. The response time for key access remains constant, regardless of the number of table entries. Like database tables, hashed tables always have a unique key. Hashed tables are useful if you want to construct and use an internal table which resembles a database table or for processing large amounts of data.

Regards

Sudheer

Re: Table type

Former Member — Tue, 27 Mar 2007 08:51:45 GMT

Hi Haritha,

Table Types:

A table type describes the structure and functional attributes of an internal table in ABAP. In ABAP programs you can reference a table type TTYP defined in the ABAP Dictionary with the command DATA <inttab> TYPE TTYP. An internal table <inttab> is created in the program with the attributes defined for TTYP in the ABAP Dictionary.

A table type is defined by:

its line type, that defines the structure and data type attributes of a line of the internal table

the options for managing and accessing the data ( access mode) in the internal table

the key ( key definition and key category) of the internal table

The row type is defined by directly entering the data type, length and number of decimal places or by referencing a data element, structured type ( structure, table or view) or other table type. Or the row type can be a reference type.

Reward if it helps you......

Regards,

Sandhya