![]() Table maintenance allowed should be given.ĭomain: It is used to define technical attributes(datatype and length) and the value ranges(fixed values and intervals).ĭataelement: Information about the meaning(description) of a table field or structure is defined here. While creating database table in dictionary we have to fill delivery class,table maintenance and technical settings(explained above).ĭelivery class: It defines the type of data that is going to be stored and also it defines the owner of the table and also delivery class controls the transport of table data for installation,upgrade,client copy and when transporting between customer systems. Size Category No of data records of table expected Size category defines the expected space required for the table in the database.ĪPPL1 Transaction data, Transparent tables Data class is the physical area or table space where the tables has to be stored in database. Technical settings will have Local Storage Parameters and Buffering.Local storage parameters consists of Dataclass and size category. Technical Settings – Control how the table should be created in the database. Table fields – define the field names and datatypes of the fields contained in the tableįoreign Keys – Define the relationships between the tables A table having the same structure is then created from this table definition in the underlying database.Ī table definition in the ABAP dictionary contains the following components: Tables are defined in the ABAP dictionary independently of the database. Transaction data – very frequently change data. Configuration data – It never changed it is permanent. The only difference is it cannot maintain the Primary key. ![]() Pooled table has Many to one relation ship with the data base table. ![]() It is nothing but group of fieldsįrom different transparent tables and all are combined base on Primary Key. ![]() It has one to one relationship with the table in the Data base.Ĭluster table has Many to One relation ship with the data base table. Transparent table has the same name and same no of fields in the Database as well as in the Data dictionary.įor each transparent table in the dictionary there is one associated table in the database. Data type (Data Element, Structure, Table Type) Its main function is to support the creation andįollowing are the objects in the data dictionary:ģ. SE11-Data Dictionary is a central source for data in data base management system. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |