Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between Transparant Tables , Pooled
& cluster Tables?
- 1 Answers
- 6171 Views
- Patni, Satyam, Siemens, I also Faced
- E-Mail Answers
Answer Posted / uma mb
These are three different kinds of table types in SAP.
The first most common type known to all is the 'Transparent
Table' which is a logical definition (in teh ABAP data
dictionary) of a physical table in the database.
Several tables logically defined in ABAP data dictionary can
be combined in a physical table (pool or cluster).
When functionally dependent data spread in many different
tables are kept in one database table, it comes to be known
as a cluster table. The key fields of these cluster tables
form the cluster key.
Pool table is just the opposite where tables are kept
together but they are not functionally dependent - rather
say all small master tables kept together as a pool would
form a pool table.
The true benefits of a cluster / pool table is data is
stored ina compressed form, so less memory space and less
network load.
There are some minus points also:
No native SQL can be used, no views, no joins, no scondary
indices, no GROUP BY, ORDER BY can be used. Table appends
not possible.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Search help exit details.
What is the function of the transport system and workbench organizer?
What are indexes? : abap hr
Explain what is a logical database?
Tell me a scenario where did you use secondary index?
What is erp? : sap abap hr
ABAP : Classical reports events name
Did you create help views?
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
What are the difference between tables and structures?
What is meant by authorization? Did you ever work on it? : sap abap hr
Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
What is the difference between bdc_okcode and bdc_cursor? : abap bdc
What are the commands used for interactive reports?
