topic Re: Table type in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056112#M424494 <HTML><HEAD></HEAD><BODY><P>Table Types </P><P></P><P>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 TYPE TABTYPE.</P><P></P><P>A special case of table types are the ranges table types.</P><P></P><P>See also:</P><P></P><P>Creating Table Types </P><P></P><P>Procedure</P><P></P><P>In the initial screen of the ABAP Dictionary, enter the table type name in field Data type and choose Create. </P><P>A dialog box appears in which you must define the type category.</P><P></P><P>Select Table type and choose Choose. </P><P>The maintenance screen for table types appears.</P><P></P><P>Enter an explanatory short text in the field Short text. </P><P>You can for example find the table type at a later time using this short text.</P><P></P><P>Now define the structure of a row of the table type (row type), the options for accessing data in the defined internal table (access mode) and the key of the table type.</P><P></P><P>Enter the row type of the table type on the Row type tab page. You can refer to an existing type (data element, structure, table, view, table type) or directly enter the row type. </P><P>If you want to refer to an existing type, you must mark the Row type radio button and enter the name of the type in the field below it.</P><P></P><P>If you want to enter the data type, field length and possibly the number of decimal places directly, you must mark the Built-in type radio button. Entries are now possible in the fields Data type, Number of places and Decimal places.</P><P></P><P>If you want to use a reference type as row type, mark the radio button Reference type and then Referenced type. Enter the name of the referenced type. This can be the name of a class or an interface, a generic reference to ANY, OBJECT, or DATA or a reference to a type defined in the Dictionary. If you want the reference type to be a predefined Dictionary type, choose Reference to predefined type. Select the type, the number of places and possibly the number of decimal places. </P><P></P><P>On the Access tab page define the access mode of the table type. </P><P>This defines how to access the data in an internal table defined by the table type in ABAP programs.</P><P></P><P>Define the key of the table type on the Key tab page. </P><P>The key of a table type is defined by the key definition and the key category.</P><P></P><P>If you select Key components, you can define the key of the table type directly in the input area with the same name. This option is only possible if the row type of the table type is a structure, table or view.</P><P></P><P>You can display all the components of the row type with Select components. Select the components you want to copy to the key and choose .</P><P></P><P>Save the table type. </P><P>You are asked to assign the table type a development class. You can change this development class later with Goto ® Object directory entry.</P><P></P><P>Choose .</P><P>Result</P><P></P><P>The table type is now activated. The runtime object of the type is created. At activation, a log is written; it can be displayed with Utilities ® Activation log. If errors occurred during activation, the activation log is automatically displayed.</P><P></P><P>Other Options</P><P></P><P>You can enter an explanatory text for the table type with Goto ® Documentation. This is purely technical documentation that is not displayed in the online help system. </P><P>You can display the runtime object of the table type with Utilities ® Runtime object ® Display. With Utilities ® Runtime object ® Check you can check if the runtime object of the table type is consistent with its definition in the maintenance screen of the ABAP Dictionary.</P><P> </P><P></P><P>Key Definition of a Table Type </P><P></P><P>When a table type is defined, the key to be used for the table type must be specified.</P><P></P><P>You have the following options:</P><P></P><P>Standard key: The structure of the key depends on the row type category. In a structured row type, the standard key consists of all the character-like components of the table row. In an elementary row type or reference type as row type, the standard key consists of the entire table row. If the row type is a table type, the standard key is empty. Note that an empty key is only allowed for access mode Standard table. </P><P>Row type: The key consists of all the fields of the row type. </P><P>Key components: The key is explicitly defined by selecting components (fields) of the row type. This is only possible if a structure, table or view was selected as row type. </P><P>Key not specified: The key is not specified. This defines a generic table type.</P><P>Access Mode </P><P></P><P>The access mode defines how to access the data in the internal table defined by the table type when performing key operations (READ TABLE, INSERT TABLE, MODIFY TABLE, COLLECT). In particular, it defines whether key accesses (see Keys of Table Types) to the internal table are allowed.</P><P></P><P>Possible access modes are:</P><P></P><P>Standard table:</P><P>The key access to a standard table uses a sequential search. The time required for an access is linearly dependent on the number of entries in the internal table.</P><P></P><P>You should usually access a standard table with index operations.</P><P></P><P>Sorted table:</P><P>The table is always stored internally sorted by its key. Key access to a sorted table can therefore use a binary search. If the key is not unique, the entry with the lowest index is accessed. The time required for an access is logarithmically dependent on the number of entries in the internal table.</P><P></P><P>Index accesses to sorted tables are also allowed. You should usually access a sorted table using its key.</P><P></P><P>Hash table:</P><P>The table is internally managed with a hash procedure. All the entries must have a unique key. The time required for a key access is constant, that is it does not depend on the number of entries in the internal table.</P><P></P><P>You cannot access a hash table with an index. Accesses must use generic key operations (SORT, LOOP, etc.).</P><P></P><P>Index table:</P><P>The table can be a standard table or a sorted table.</P><P></P><P>Index access is allowed to such an index table. Index tables can be used to define the type of generic parameters of a FORM (subroutine) or a function module.</P><P></P><P>not specified:</P><P>The table can be a standard table, a sorted table or a hash table. The set of valid operations on such a table is the intersection of the valid operations for these three access modes.</P><P></P><P>You cannot access tables of this type with index operations.</P><P></P><P></P><P></P><P>If Index table or Not specified is selected for the access mode, a generic table type that cannot be used to define data objects or types in programs is created</P><P>Generic Table Types </P><P></P><P>A generic table type does not define all the attributes of an internal table in the ABAP Dictionary; it leaves some of these attributes undefined.</P><P></P><P>A table type is generic in the following cases:</P><P></P><P>Index table or not specified is selected for the access type, </P><P>Not specified is selected for the key definition, </P><P>Not specified is selected for the key category.</P><P>Generic table types are used to define the types of generic table parameters in function modules and forms.</P><P></P><P></P><P></P><P>If a generic table type with the index table access type is used as the parameter of a function module, you can pass either a sorted table or a standard table in the call.</P><P></P><P>Generic table types offer a degree of freedom in the arguments passed in the corresponding calls.</P><P></P><P>Since generic table types do not define all the necessary attributes of an internal table, they cannot be used to define data objects (with DATA) or types (with TYPE).</P><P></P><P> </P><P></P><P>Ranges Table Types </P><P></P><P>A ranges table type is a special case of a table type. A ranges table type describes the structure of an internal table for administering complex areas, i.e. the type of an internal ranges table in the ABAP program.</P><P></P><P>Ranges tables can be used for example in logical conditions (IN operators) in the SELECT, IF, WHILE and CHECK statements or to pass data to selection tables.</P><P></P><P>The row type of a ranges table type has a fixed structure. The row type consists of the 4 components SIGN (sign), OPTION (comparison operator), LOW (lower limit) and HIGH (upper limit) in this order.</P><P></P><P>The type of components LOW and HIGH is defined by an elementary associated type. It can be defined by specifying a data element or by directly defining the data type, number of places and if necessary the number of decimal places.</P><P></P><P>A ranges table type always has Standard table access mode and a standard key that is non-unique.</P><P></P><P>See also:</P><P></P><P>Creating Ranges Table Types</P><P>Creating a Ranges Table Type </P><P></P><P>In the initial screen of the ABAP Dictionary, enter the name of the ranges table type in field Data type and choose Create. </P><P>A dialog box appears in which you must select the type category.</P><P></P><P>Select Table type and choose . </P><P>The maintenance screen for table types appears.</P><P></P><P>Enter an explanatory short text in the field Short text. </P><P>You can for example find the ranges table type at a later time using this short text.</P><P></P><P>Choose Edit ® Define as ranges table type. </P><P>You go to the maintenance screen for ranges table types. The access mode, key definition and key category are defined in advance for a ranges table type, so you do not need to define them.</P><P></P><P>To define the ranges table type, you only have to specify an elementary type for the types of the LOW and HIGH components of the corresponding row type.</P><P></P><P>If you want to define the types of the LOW and HIGH components using an existing data element, you must select Data element and enter the name of the data element in the subsequent field. You can also enter the name of a data element that does not yet exist and go directly to the data element maintenance screen by double-clicking to create it.</P><P></P><P>You can also define the elementary type of the LOW and HIGH components directly. Select Built-in type. You can now enter values for fields Data type, Number of places and Decimal places.</P><P></P><P>Now enter a name for the row type of the ranges table type in field Structured row type. </P><P>A ranges table type must have a row type, just like any other table type. This row type always has a fixed structure for the special case of ranges table types. You can therefore generate the row type from the maintenance screen of the ranges table type.</P><P></P><P>Save your entries. </P><P>You are asked to assign the ranges table type a development class. If needed, you can change this development class later with Goto ® Object directory entry.</P><P></P><P>Choose Create. You can generate the row type of the ranges table type with this function. </P><P>The maintenance screen for structures is displayed. The components of the row type are already assigned based on your definition of the associated type for the LOW and HIGH components. You only have to enter a short text for the row type and Activate it. Then choose Back.</P><P></P><P>Choose .</P><P>Result</P><P></P><P>The ranges table type is now activated. The runtime object of the type is created. At activation, a log is written; it can be displayed with Utilities ® Activation log. If errors occurred during activation, the activation log is displayed immediately.</P><P></P><P>reward all helpfull answers</P><P></P><P>Message was edited by: </P><P> sunil kumar</P><P></P></BODY></HTML> Wed, 28 Mar 2007 12:05:05 GMT Former Member 2007-03-28T12:05:05Z Table type https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056109#M424491 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P> Can any one tell what is the main use of table type in data dictionary (which comes under data element) and how to create table type.</P><P></P><P></P><P></P><P>with regards,</P><P>Nanjund sharma</P></BODY></HTML> Wed, 28 Mar 2007 07:50:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056109#M424491 Former Member 2007-03-28T07:50:30Z Re: Table type https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056110#M424492 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Table type</P><P>A table type is a type that describes the structure and functions of an internal table in the ABAP program. It can be used in the ABAP program analogously to types that are predefined in the ABAP program or defined directly in the ABAP program to define data objects and types.</P><P></P><P>Table types can be used in the ABAP Dictionary to define structures (structured types) and other table types:</P><P></P><P></P><P>A component of a structure can have a table type as type. This defines a structured type with a component that is a table.</P><P></P><P>A table type can be used as the row type of another table type. This defines a table of tables.</P><P>A table type describes the following attributes of an internal table:</P><P></P><P></P><P>The structure and data type attributes of the table row are defined by the row type.</P><P></P><P>The key definition describes the structure of the table key.</P><P></P><P>The key category defines whether the key is unique, that is if all the records of the table have different key values.</P><P></P><P>The access mode defines how the table is accessed and how its records are managed internally.</P><P>A special form of these general table types are the ranges table types.</P><P></P><P>reward if useful</P><P>regards,</P><P>ANJI</P></BODY></HTML> Wed, 28 Mar 2007 07:53:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056110#M424492 Former Member 2007-03-28T07:53:14Z Re: Table type https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056111#M424493 <HTML><HEAD></HEAD><BODY><P>Hi Nanduja,</P><P></P><P>Check this info.</P><P></P><P>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.</P><P></P><P>A table type is defined by:</P><P></P><P>its line type, that defines the structure and data type attributes of a line of the internal table </P><P>the options for managing and accessing the data ( access mode) in the internal table </P><P>the key ( key definition and key category) of the internal table</P><P></P><P>you can see the following link.....</P><P></P><P></P><P><A href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/90/8d7304b1af11d194f600a0c929b3c3/frameset.htm" target="test_blank">http://help.sap.com/saphelp_erp2005vp/helpdata/en/90/8d7304b1af11d194f600a0c929b3c3/frameset.htm</A></P><P></P><P></P><P>Hope this resolves your query.</P><P></P><P>Reward all the helpful answers.</P><P></P><P>Regards</P></BODY></HTML> Wed, 28 Mar 2007 12:02:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056111#M424493 Former Member 2007-03-28T12:02:23Z Re: Table type https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056112#M424494 <HTML><HEAD></HEAD><BODY><P>Table Types </P><P></P><P>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 TYPE TABTYPE.</P><P></P><P>A special case of table types are the ranges table types.</P><P></P><P>See also:</P><P></P><P>Creating Table Types </P><P></P><P>Procedure</P><P></P><P>In the initial screen of the ABAP Dictionary, enter the table type name in field Data type and choose Create. </P><P>A dialog box appears in which you must define the type category.</P><P></P><P>Select Table type and choose Choose. </P><P>The maintenance screen for table types appears.</P><P></P><P>Enter an explanatory short text in the field Short text. </P><P>You can for example find the table type at a later time using this short text.</P><P></P><P>Now define the structure of a row of the table type (row type), the options for accessing data in the defined internal table (access mode) and the key of the table type.</P><P></P><P>Enter the row type of the table type on the Row type tab page. You can refer to an existing type (data element, structure, table, view, table type) or directly enter the row type. </P><P>If you want to refer to an existing type, you must mark the Row type radio button and enter the name of the type in the field below it.</P><P></P><P>If you want to enter the data type, field length and possibly the number of decimal places directly, you must mark the Built-in type radio button. Entries are now possible in the fields Data type, Number of places and Decimal places.</P><P></P><P>If you want to use a reference type as row type, mark the radio button Reference type and then Referenced type. Enter the name of the referenced type. This can be the name of a class or an interface, a generic reference to ANY, OBJECT, or DATA or a reference to a type defined in the Dictionary. If you want the reference type to be a predefined Dictionary type, choose Reference to predefined type. Select the type, the number of places and possibly the number of decimal places. </P><P></P><P>On the Access tab page define the access mode of the table type. </P><P>This defines how to access the data in an internal table defined by the table type in ABAP programs.</P><P></P><P>Define the key of the table type on the Key tab page. </P><P>The key of a table type is defined by the key definition and the key category.</P><P></P><P>If you select Key components, you can define the key of the table type directly in the input area with the same name. This option is only possible if the row type of the table type is a structure, table or view.</P><P></P><P>You can display all the components of the row type with Select components. Select the components you want to copy to the key and choose .</P><P></P><P>Save the table type. </P><P>You are asked to assign the table type a development class. You can change this development class later with Goto ® Object directory entry.</P><P></P><P>Choose .</P><P>Result</P><P></P><P>The table type is now activated. The runtime object of the type is created. At activation, a log is written; it can be displayed with Utilities ® Activation log. If errors occurred during activation, the activation log is automatically displayed.</P><P></P><P>Other Options</P><P></P><P>You can enter an explanatory text for the table type with Goto ® Documentation. This is purely technical documentation that is not displayed in the online help system. </P><P>You can display the runtime object of the table type with Utilities ® Runtime object ® Display. With Utilities ® Runtime object ® Check you can check if the runtime object of the table type is consistent with its definition in the maintenance screen of the ABAP Dictionary.</P><P> </P><P></P><P>Key Definition of a Table Type </P><P></P><P>When a table type is defined, the key to be used for the table type must be specified.</P><P></P><P>You have the following options:</P><P></P><P>Standard key: The structure of the key depends on the row type category. In a structured row type, the standard key consists of all the character-like components of the table row. In an elementary row type or reference type as row type, the standard key consists of the entire table row. If the row type is a table type, the standard key is empty. Note that an empty key is only allowed for access mode Standard table. </P><P>Row type: The key consists of all the fields of the row type. </P><P>Key components: The key is explicitly defined by selecting components (fields) of the row type. This is only possible if a structure, table or view was selected as row type. </P><P>Key not specified: The key is not specified. This defines a generic table type.</P><P>Access Mode </P><P></P><P>The access mode defines how to access the data in the internal table defined by the table type when performing key operations (READ TABLE, INSERT TABLE, MODIFY TABLE, COLLECT). In particular, it defines whether key accesses (see Keys of Table Types) to the internal table are allowed.</P><P></P><P>Possible access modes are:</P><P></P><P>Standard table:</P><P>The key access to a standard table uses a sequential search. The time required for an access is linearly dependent on the number of entries in the internal table.</P><P></P><P>You should usually access a standard table with index operations.</P><P></P><P>Sorted table:</P><P>The table is always stored internally sorted by its key. Key access to a sorted table can therefore use a binary search. If the key is not unique, the entry with the lowest index is accessed. The time required for an access is logarithmically dependent on the number of entries in the internal table.</P><P></P><P>Index accesses to sorted tables are also allowed. You should usually access a sorted table using its key.</P><P></P><P>Hash table:</P><P>The table is internally managed with a hash procedure. All the entries must have a unique key. The time required for a key access is constant, that is it does not depend on the number of entries in the internal table.</P><P></P><P>You cannot access a hash table with an index. Accesses must use generic key operations (SORT, LOOP, etc.).</P><P></P><P>Index table:</P><P>The table can be a standard table or a sorted table.</P><P></P><P>Index access is allowed to such an index table. Index tables can be used to define the type of generic parameters of a FORM (subroutine) or a function module.</P><P></P><P>not specified:</P><P>The table can be a standard table, a sorted table or a hash table. The set of valid operations on such a table is the intersection of the valid operations for these three access modes.</P><P></P><P>You cannot access tables of this type with index operations.</P><P></P><P></P><P></P><P>If Index table or Not specified is selected for the access mode, a generic table type that cannot be used to define data objects or types in programs is created</P><P>Generic Table Types </P><P></P><P>A generic table type does not define all the attributes of an internal table in the ABAP Dictionary; it leaves some of these attributes undefined.</P><P></P><P>A table type is generic in the following cases:</P><P></P><P>Index table or not specified is selected for the access type, </P><P>Not specified is selected for the key definition, </P><P>Not specified is selected for the key category.</P><P>Generic table types are used to define the types of generic table parameters in function modules and forms.</P><P></P><P></P><P></P><P>If a generic table type with the index table access type is used as the parameter of a function module, you can pass either a sorted table or a standard table in the call.</P><P></P><P>Generic table types offer a degree of freedom in the arguments passed in the corresponding calls.</P><P></P><P>Since generic table types do not define all the necessary attributes of an internal table, they cannot be used to define data objects (with DATA) or types (with TYPE).</P><P></P><P> </P><P></P><P>Ranges Table Types </P><P></P><P>A ranges table type is a special case of a table type. A ranges table type describes the structure of an internal table for administering complex areas, i.e. the type of an internal ranges table in the ABAP program.</P><P></P><P>Ranges tables can be used for example in logical conditions (IN operators) in the SELECT, IF, WHILE and CHECK statements or to pass data to selection tables.</P><P></P><P>The row type of a ranges table type has a fixed structure. The row type consists of the 4 components SIGN (sign), OPTION (comparison operator), LOW (lower limit) and HIGH (upper limit) in this order.</P><P></P><P>The type of components LOW and HIGH is defined by an elementary associated type. It can be defined by specifying a data element or by directly defining the data type, number of places and if necessary the number of decimal places.</P><P></P><P>A ranges table type always has Standard table access mode and a standard key that is non-unique.</P><P></P><P>See also:</P><P></P><P>Creating Ranges Table Types</P><P>Creating a Ranges Table Type </P><P></P><P>In the initial screen of the ABAP Dictionary, enter the name of the ranges table type in field Data type and choose Create. </P><P>A dialog box appears in which you must select the type category.</P><P></P><P>Select Table type and choose . </P><P>The maintenance screen for table types appears.</P><P></P><P>Enter an explanatory short text in the field Short text. </P><P>You can for example find the ranges table type at a later time using this short text.</P><P></P><P>Choose Edit ® Define as ranges table type. </P><P>You go to the maintenance screen for ranges table types. The access mode, key definition and key category are defined in advance for a ranges table type, so you do not need to define them.</P><P></P><P>To define the ranges table type, you only have to specify an elementary type for the types of the LOW and HIGH components of the corresponding row type.</P><P></P><P>If you want to define the types of the LOW and HIGH components using an existing data element, you must select Data element and enter the name of the data element in the subsequent field. You can also enter the name of a data element that does not yet exist and go directly to the data element maintenance screen by double-clicking to create it.</P><P></P><P>You can also define the elementary type of the LOW and HIGH components directly. Select Built-in type. You can now enter values for fields Data type, Number of places and Decimal places.</P><P></P><P>Now enter a name for the row type of the ranges table type in field Structured row type. </P><P>A ranges table type must have a row type, just like any other table type. This row type always has a fixed structure for the special case of ranges table types. You can therefore generate the row type from the maintenance screen of the ranges table type.</P><P></P><P>Save your entries. </P><P>You are asked to assign the ranges table type a development class. If needed, you can change this development class later with Goto ® Object directory entry.</P><P></P><P>Choose Create. You can generate the row type of the ranges table type with this function. </P><P>The maintenance screen for structures is displayed. The components of the row type are already assigned based on your definition of the associated type for the LOW and HIGH components. You only have to enter a short text for the row type and Activate it. Then choose Back.</P><P></P><P>Choose .</P><P>Result</P><P></P><P>The ranges table type is now activated. The runtime object of the type is created. At activation, a log is written; it can be displayed with Utilities ® Activation log. If errors occurred during activation, the activation log is displayed immediately.</P><P></P><P>reward all helpfull answers</P><P></P><P>Message was edited by: </P><P> sunil kumar</P><P></P></BODY></HTML> Wed, 28 Mar 2007 12:05:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056112#M424494 Former Member 2007-03-28T12:05:05Z Re: Table type https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056113#M424495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>already explained:</P><P></P><P>the table type defines an internal table, not just a structure.</P><P></P><P>You can use table types for typing IMPORT, EXPORT and CHANGING parameters of function modules (and FORMs and METHODs) if you want to pass an internal table.</P><P></P><P>With OO, parameter kind TABLE is obsolete, so we need it.</P><P></P><P>Regards,</P><P></P><P>Clemens</P></BODY></HTML> Wed, 28 Mar 2007 12:08:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-type/m-p/2056113#M424495 Clemenss 2007-03-28T12:08:50Z