How many types of tables exists and what are they in data dictionary?

Answer Posted / nitish sharma

4 types of tables in data dictionary.

i) Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used.

ii) Pool tables- It is a database table with a special structure that enables the data of many R/3 tables to be stored within it.

iii) Cluster tables - These are logical tables that are arranged as records of transparent tables. one cannot use native sql on these tables (only open sql). They are not manageable directly using database system tools.

iv) Internal tables - Internal table is a temporary table gets created in the memory of application.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use multiple transactions by using bdc_insert? : abap bdc

647


What is the use of table maintenance allowed?

547


Explain about drill down report?

8781


Differentiate between transparent tables, cluster tables and pooled tables

570


hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp

3215






What is the difference between a substructure and an append structure?

629


What are the page headers for secondary lists?

610


What is update task

7641


What is the use of enqueue function module? : sap abap data dictionary

585


What is human resource information systems (chris)? : sap abap hr

543


What is going life actually? What is the role of a functional consultant in it? : sap abap hr

551


How to eliminate duplicate entries in internal tables?

682


If your project is support project ? when is your implementation has completed ?

1537


How will you define posting procedures?

906


What is a logical database?

669