topic Re: database table in Application Development and Automation Discussions

topic Re: database table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366154#M807768 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>tables: which contain MANDT field Means It is a Client Dependent TABLE and IF not It is a Client Indipendent.</P><P></P><P>Cluster tables and Pooled tables have many to one relationship with the underlying database.</P><P></P><P>A table pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored.</P><P>Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.</P><P></P><P>A pooled table cannot have the name having more than 10 characters. </P><P>All the key fields of the pooled table must be of character data type. </P><P>In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively. </P><P>In cluster table the records having the same key are stored in a single key in the cluster. </P><P>If there is an overflow of the data records a continuation record is created with the same table key.</P></BODY></HTML> Sat, 02 Feb 2008 11:20:56 GMT Former Member 2008-02-02T11:20:56Z database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366148#M807762 <HTML><HEAD></HEAD><BODY><P>what are the client independent table and</P><P>what are the dependent tables?</P><P> what is difference between pooled, cluster tables?</P></BODY></HTML> Fri, 01 Feb 2008 13:44:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366148#M807762 Former Member 2008-02-01T13:44:41Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366149#M807763 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>A table is client independent, if the first key field of it is not the MANDT field (you can check it in SE11 transaction).</P><P>A table is client dependent, if the first key field of it is the MANDT field (you can check it in SE11 transaction).</P><P></P><P>Regards</P><P>Tamá</P><P></P></BODY></HTML> Fri, 01 Feb 2008 13:47:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366149#M807763 Former Member 2008-02-01T13:47:57Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366150#M807764 <HTML><HEAD></HEAD><BODY><P>client dependent tables - tables which are having client field as primary key field</P><P></P><P>client indepent tables - not having client field as primary key.</P><P></P><P>cluster and polled tables chk below link -</P><P></P><P><A href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm" target="test_blank">http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm</A></P></BODY></HTML> Fri, 01 Feb 2008 13:51:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366150#M807764 Former Member 2008-02-01T13:51:12Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366151#M807765 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>1) Client dependent table is that table which contains Field name as</P><P> MANDT (not compulsory.it can be any thing) but must have type as CLNT (Compulsory).</P><P>2) And which does not contain is client independent.</P></BODY></HTML> Fri, 01 Feb 2008 16:06:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366151#M807765 Former Member 2008-02-01T16:06:09Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366152#M807766 <HTML><HEAD></HEAD><BODY><P>You can find the answer by searching this forum.</P><P></P><P>Click 'search forum'</P><P></P><P>Enter 'difference pooled cluster table' or any such question before actually putting the question for discussion. That saves lot of either sides effort.</P><P></P><P>Read through the replies.</P><P></P><P>Regards.</P><P></P><P>Rahul Dwivedi</P></BODY></HTML> Fri, 01 Feb 2008 17:54:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366152#M807766 Former Member 2008-02-01T17:54:40Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366153#M807767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Client independent tables dosent have MANDT field.</P><P>Client dependent tables have first key field MANDT.</P><P></P><P>Cluster tables and Pooled tables have many to one relationship with the underlying database.</P><P></P><P>A table pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored.</P><P>Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.</P><P></P><P>A pooled table cannot have the name having more than 10 characters. </P><P>All the key fields of the pooled table must be of character data type. </P><P>In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively. </P><P></P><P>In cluster table the records having the same key are stored in a single key in the cluster. </P><P>If there is an overflow of the data records a continuation record is created with the same table key.</P></BODY></HTML> Sat, 02 Feb 2008 02:40:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366153#M807767 Former Member 2008-02-02T02:40:30Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366154#M807768 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>tables: which contain MANDT field Means It is a Client Dependent TABLE and IF not It is a Client Indipendent.</P><P></P><P>Cluster tables and Pooled tables have many to one relationship with the underlying database.</P><P></P><P>A table pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored.</P><P>Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.</P><P></P><P>A pooled table cannot have the name having more than 10 characters. </P><P>All the key fields of the pooled table must be of character data type. </P><P>In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively. </P><P>In cluster table the records having the same key are stored in a single key in the cluster. </P><P>If there is an overflow of the data records a continuation record is created with the same table key.</P></BODY></HTML> Sat, 02 Feb 2008 11:20:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366154#M807768 Former Member 2008-02-02T11:20:56Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366155#M807769 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>when we add a field MANDT of type MANDT then our table is client dependent</P><P> and is visible to only that client. But if this Field is not added to the </P><P>table then we can access the table using any client number.</P><P></P><P></P><P></P><P>tables which can be access by all user are client independent (no mandt field in table) </P><P>tables which can be access by some specific user are client dependent (use mandt field in table)</P><P></P><P></P><P>Table pools (pools) and table clusters (clusters) are</P><P>special table types in the ABAP Dictionary. The data from</P><P>several different tables can be stored together in a table</P><P>pool or table cluster. Tables assigned to a table pool or</P><P>table cluster are referred to as pooled tables or cluster</P><P>tables.</P><P></P><P></P><P>Table Pools</P><P>===========</P><P>A table pool or table cluster should be used exclusively for</P><P>storing internal control information (screen sequences,</P><P>program parameters, temporary data, continuous texts such as</P><P>documentation). Data of commercial relevance is usually</P><P>stored in transparent tables.</P><P></P><P>A table in the database in which all records from the pooled</P><P>tables assigned to the table pool are stored corresponds to</P><P>a table pool.</P><P></P><P>Table Clusters</P><P>==============</P><P></P><P>Several logical data records from different cluster tables</P><P>can be stored together in one physical record in a table</P><P>cluster.</P><P></P><P>A cluster key consists of a series of freely definable key</P><P>fields and a field (Pageno) for distinguishing continuation</P><P>records. A cluster also contains a long field (Vardata) that</P><P>contains the contents of the data fields of the cluster</P><P>tables for this key. If the data does not fit into the long</P><P>field, continuation records are created.</P><P></P><P></P><P>with regards,</P><P>sowjanya.gosala.</P></BODY></HTML> Mon, 04 Feb 2008 07:34:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366155#M807769 Former Member 2008-02-04T07:34:31Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366156#M807770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Tables having 'MANDT' as one of the primary key is a client dependent table. And those tables which are linked to other table throught Foreign Key relationships are called Dependedt table.</P><P></P><P>The following documentation below will be helpful.</P><P></P><P></P><P><STRONG>The following are the table types used in SAP :</STRONG></P><P></P><P><STRONG>Transparent Tables</STRONG> </P><P>There is a physical table on the database for each transparent table. </P><P>The names of the physical table and the logical table definition in the</P><P>ABAP/4 Dictionary agree. All the business and application data is store</P><P>in transparent tables. </P><P></P><P><STRONG>Pooled table</STRONG></P><P>Pooled tables can be used to store control data (e.g. screen sequences,</P><P>program parameters or temporary data). Several pooled tables can be</P><P>combined to form a table pool. The table pool corresponds to a physical</P><P>table on the database in which all the records of the allocated pooled</P><P>tables are stored.</P><P></P><P><STRONG>Cluster table</STRONG></P><P>Cluster tables contain continuous text, for example documentation.</P><P>Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table category. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least part of the keys must agree. Several cluster tables are stored in one corresponding table on the database. </P><P></P><P><STRONG>I.</STRONG> Transparent tables (BKPF, VBAK, VBAP, KNA1, COEP)</P><P>Allows secondary indexes (SE11->Display Table->Indexes)</P><P>Can be buffered (SE11->Display Table->technical settings) Heavily updated tables should not be buffered.</P><P></P><P><STRONG>II.</STRONG> Pool Tables (match codes, look up tables)</P><P>Should be accessed via primary key or</P><P>Should be buffered (SE11->Display Table->technical settings)</P><P>No secondary indexes</P><P>Select * is Ok because all columns retrieved anyway</P><P></P><P><STRONG>III.</STRONG> Cluster Tables (BSEG,BSEC)</P><P>Should be accessed via primary key - very fast retrieval otherwise very slow</P><P>No secondary indexes</P><P>Select * is Ok because all columns retrieved anyway. Performing an operation on multiple rows is more efficient than single row operations. Therefore you still want to select into an internal table. If many rows are being selected into the internal table, you might still like to retrieve specific columns to cut down on the memory required.</P><P>Statistical SQL functions (SUM, AVG, MIN, MAX, etc) not supported</P><P>Can not be buffered</P><P>IV. Buffered Tables (includes both Transparent & Pool Tables)</P><P>While buffering database tables in program memory (SELECT into internal table) is generally a good idea for performance, it is not always necessary. Some tables are already buffered in memory. These are mostly configuration tables. If a table is already buffered, then a select statement against it is very fast. To determine if a table is buffered, choose the 'technical settings' soft button from the data dictionary display of a table (SE12). Pool tables should all be buffered.</P><P></P><P><STRONG>Tables Documentation</STRONG></P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/25c1f5d1-0901-0010-d495-e96d02a0cb01" target="test_blank">https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/25c1f5d1-0901-0010-d495-e96d02a0cb01</A></P><P></P><P>Best Regards,</P><P>Rajesh.</P><P></P><P>Please reward points if found helpful.</P></BODY></HTML> Mon, 04 Feb 2008 09:16:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366156#M807770 Former Member 2008-02-04T09:16:17Z Re: database table https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366157#M807771 <HTML><HEAD></HEAD><BODY><P>The client field must be included for client-dependent tables/views.</P><P></P><P><STRONG>Overview of the DB table types</STRONG></P><P>In addition to transparent tables, where the definition in the ABAP Dictionary and</P><P>in the database are identical, there are <STRONG>pool and cluster tables</STRONG> in the R/3 system.</P><P><STRONG>Pool and cluster tables</STRONG> are characterized by the fact that several tables logically</P><P>defined in the ABAP Dictionary are combined in a physical database table (table</P><P>pool or cluster).</P><P></P><P><STRONG>Pool tables</STRONG></P><P>The basic idea of a table pool, as opposed to table clusters, is the storage of data</P><P>records from the tables defined in the ABAP Dictionary that are not dependent on</P><P>one another. You would like to combine small R/3 tables to a database table.</P><P>In the example above, you can recognize that the intersection of the key fields of</P><P>TABA and TABB is empty. Despite this, the data records from TABA and TABB</P><P>are stored in the TABAB table pool.</P><P>The key for a data record of the TABAB table pool consists of both the fields</P><P>TABNAME and VARKEY. The TABNAME field assumes the name of the pool</P><P>table. The VARKEY field consists of the concatenation of the key fields of the</P><P>pool table. This arises in the necessity that the key fields of a pool table must</P><P>be of the type C.</P><P>In the VARDATA field, the non-key fields of the pool tables are stored in an</P><P>unstructured way, in compressed form by the database interface. The DATALN</P><P>field contains the length of the VARDATA field.</P><P></P><P></P><P><STRONG>Cluster tables</STRONG></P><P>The idea of cluster tables is that you store functionally dependent data which is</P><P>divided among different tables in one database table. Accordingly, the intersection</P><P>of the key fields of the cluster tables is formed by the key of the table cluster</P><P>(cluster key).</P><P>The data dependent on one cluster key are stored in the VARDATA field of the</P><P>table cluster. If the VARDATA field does not have the capacity to take on all</P><P>dependent data, the database interface creates an overflow record. The uniqueness</P><P>within the table cluster is guaranteed by the PAGNO field.</P><P>The content of the VARDATA field is compressed by the databse interface.</P><P>Accordingly, the VARDATA field contains a description for decompressing its</P><P>data. The TIMESTAMP and PAGELG fields contain administrative information.</P><P></P><P></P><P><STRONG>The advantages and disadvantages of pool and cluster tables:</STRONG></P><P>1.The decisive advantage of pool and cluster tables is that the data can be stored</P><P>in compressed form in the database. This reduces the memory space required</P><P>as well as the network load.</P><P>2.The combination of tables into table pools to table clusters means less tables and</P><P>the compressing means less fields in the database. The result is that fewer different</P><P>SQL statements are carried out.</P><P>3.Pool and cluster tables are not stored as separate tables in the database. In this way,</P><P>the administration becomes simpler. With cluster tables, functionally dependent</P><P>data are read together, which results in fewer database accesses.</P><P>4.The decisive disadvantage lies in the restricted database functionality. It is not</P><P>possible for non-key fields to create an index. There are neither primary indices</P><P>nor indices on a subset of the key fields. The use of database views or ABAP</P><P>JOINs is also ruled out, as are Table Appends. You can access the data in pool or</P><P>cluster tabels only via OPEN SQL (no Native SQL).</P><P>5.For pool tables, only the WHERE conditions for key fields and for pool tables,</P><P>only the WHERE conditions for the fields of the cluster key (subset of the key</P><P>fields) are transferred to the database. ORDER BY (or GROUP BY) clauses</P><P>are not transferred for non-key fields. You need longer keys than semantically</P><P>necessary for pool tables.</P></BODY></HTML> Mon, 04 Feb 2008 20:37:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-table/m-p/3366157#M807771 Former Member 2008-02-04T20:37:22Z