hi
explain me the purpose of database utility and log
database utility is useful if you make changes to youe datbase table and make the changes reflect in database ,
log is used for knowing the changes you made in the table
The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. The database utility allows you to edit (create, delete and adjust to changes to their definition in the ABAP Dictionary) database objects derived from objects of the ABAP Dictionary.
diff bw check table and value table
check table you validate the values ientered in the field against the values in check table,
value table is domain propsed check table, you can assign as check table or override it
About Value table
1.It’s a field in a domain it helps in domain level data validation.
2.In some cases when we define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.
3.Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.
About Check Table.
1.It helps in field level data validation.
2.A foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2.
Table T1 is called the foreign key table (dependent table) and table T2 the check table (referenced table).
3.When an entry is made in the check field, there is a check whether the check table contains a record with the key defined by the values in the foreign key fields. If this is so, the entry is valid. Otherwise the system rejects the entry.
diff bw table and structure
table contains persistent data but structures contain data only during runtime
table hold multiple record but structure single record
bypass buffering
when a table is buffered if you want to get update data in the table its better to get data from database as data in application server might not be accurate as its subjected to changes, so using by pass buffering we get accurate data
reward if helpful
prasanth
Bluesky
