What is the Difference between Transparant Tables , Pooled
& cluster Tables?
Answer / 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 |
Difference between sap script and report?
What is Direct Input method?
why cluster tables are not buffered
What primary key and foreign key relationship
Performance tuning. How can you know which line of code taking long time to execute?
1) If the scripts are client dependent, what above driver program ? (client dependent / independent) 2. I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 3) Will 50,000 records be uploaded directly into APP's Server? 4) What is the button to change the variant in ALV ? 5) If your project is support project ? when is your implementation has completed ? 6)In start of selection, if we perform validation, what happens ? 7)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 8)How to transfer data which is coming from are report as output to another report 9)How to create standard text and how do u transfer it ? 10)What are the views when we are creating Material ?
What is the difference between User Exits and BADI?
5 Answers Accenture, IBM, SAP Labs,
what we have to do in st05 and se30?
how u define that idoc is generated for ale or edi method ?
What are screen painter? Menu painter? Gui status?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
What is the function of a data element? : abap data dictionary