topic Tables in Application Development and Automation Discussions

Tables

Former Member — Thu, 03 Jan 2008 02:43:38 GMT

I can any one pls help me ,

1. What is mean by Pivot Table and where we r using that ..

2. What is the purpose of table maintainence generatot and is there any types in that

3. what is diff between cluster abd pooled tables

ThX

Re: Tables

Former Member — Thu, 03 Jan 2008 02:49:38 GMT

#1 Pivot Table is from Excel.One of the best options in SAP reporting is the ability to have your SAP data automatically converted to an Excel pivot table report. A pivot table report allows you to slice and dice your data and analyze it multiple ways, without having to use a database or code logic.

#2 The purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

#3 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.

Re: Tables

Former Member — Thu, 03 Jan 2008 03:25:49 GMT

Hi,

it may help u.

Pooled table:

Pooled tables can be used to store control data (e.g. screen sequences,

program parameters or temporary data). Several pooled tables can be

combined to form a table pool. The table pool corresponds to a physical

table on the database in which all the records of the allocated pooled

tables are stored.

Cluster table :

Cluster tables contain continuous text, for example documentation.

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.

Tables Documentation view :

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/25c1f5d1-0901-0010-d495-e96d02a0cb01

regards,

vasavi.

reward if it is helpful.