What are the different database integrities ?
Semantic integrity Relational integrity Primary key integrity Value set integrity Foreign key integrity and Operational integrity. DATA DICTIONARY Type of a table or structure The table type determines how the logical table description defined in the ABAP/4 Dictionary is reproduced on the database. There are the following table types: transparent table structure append structure For internal purposes, such as storing control data or update texts, there are in addition the following table types: pooled table cluster table generated view structure Transparent table : There is a physical table on the database for each transparent table. The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond. All business data and application data are stored in transparent tables. Structure : No data records exist in the database for a structure. Structures are used for the interface definition between programs or between screens and programs. Append structure
