what is the difference between transparent, pooled and
cluster table
- 5 Answers
- 29759 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari
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.
Table Pools
===========
A table pool or table cluster should be used exclusively for
storing internal control information (screen sequences,
program parameters, temporary data, continuous texts such as
documentation). Data of commercial relevance is usually
stored in transparent tables.
A table in the database in which all records from the pooled
tables assigned to the table pool are stored corresponds to
a table pool.
Table Clusters
==============
Several logical data records from different cluster tables
can be stored together in one physical record in a table
cluster.
A cluster key consists of a series of freely definable key
fields and a field (Pageno) for distinguishing continuation
records. A cluster also contains a long field (Vardata) that
contains the contents of the data fields of the cluster
tables for this key. If the data does not fit into the long
field, continuation records are created.
| Is This Answer Correct ? | 24 Yes | 14 No |
Post New Answer View All Answers
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
I am trying to automate a manual processing of iDOCs in BD87. I used the following code to pass idoc-id to global variable 'DCN' and then skip the first screen of BD87 to go to processing directly. After running this code SET PARAMETER ID 'DCN' FIELD itabhdr-idoc_id. CALL TRANSACTION 'BD87' AND SKIP FIRST SCREEN. it takes me to the first screen because it cannot recognize my idoc-id. How I can pass idoc-id to global? I have used the above code to goto VA02 with VBELN and it worked perfectly.
What are the fields in a bdc_tab table? : abap bdc
What are roles and authorization objects?
What are the different types of luws?
what are Hana Basics
What is the use of info groups? : sap abap hr
What are the function modules used to create batch input session? : abap bdc
What is the syntax of packed number?
Did you use buffering?
What is client in the sap system? : sap abap hr
What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?
What are the different modes of processing batch input sessions? : abap bdc
Can a transparent table exist in the data dictionary but not in the database physically?
What is a table attribute?
