Question 6 :
What are the different types of data dictionary objects?
Data Dictionary Objects
* Data Element
* Type Groups
* Search Helps/Matchcode Objects
* Lock objects
* Table Types
the dictionary objects are:
lock objects etc which are data base related objects in sap
Question 7 :
What is the step by step process to create a table in data dictionary?
steps to create database tables
1.go to se11
2.give name the database table
3.give short description for the table
4.Give delivery class name as A and data browser / table view maint as Display/maintenence allowed
5.select fields tab
6.give field name data type(user defined element type/built-in-type),short text
7.select technical settings tab ,give data class as appl0 and size category as 0
9.go utillities menu click table contents select create and enter the field values then select display in table contents and u can view the table values with field lables
bottom to top approach:
creating a domain:
*se11,select the object type as domain ,name it ,create,description,enter the datatype and length(size),save ,activate
creating a dataelement;
se11,select the object type as :date element,name it ,create,desc,assign it with a domain what we created now,save,activate it.
creating a table;
se11,select the object type as table,name it, create,
enter the field name and assign it with the data element instead of assigning a datatype to it,
like this create req fields:
on behalf of this:
assign the type of the table ie.,A C G L S
allowed,not allowed ,allowed with restricions
fields of a table:(as descripted above)
BUFFERED OR NON-BUFFERED
Question 8 :
Can a transparent table exist in data dictionary but not in the data base physically?
NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE BOTH IN THE DICTIONARY AS WELL AS IN THE DATABASE,EXACTLY WITH THE SAME DATA AND FIELDS.
at the point you will activate your table a same transparent table is going to be create in database
Yes, a transparent table(definition) can exist in the data dictionary and not in the database. In this case, it is not activated
Question 9 :
What are the domains and data elements?
domains are the dictionary objects that are assigned with constants and data types
data elements are dictionary objects that are assigned with the domains.
* data elements are used to create relation between tables.
* data elements are used to transfer the data from one R/3 to another R/3.
* to create search helps.
Question 10 :
What is a collect statement? How is it different from append?
IT IS USED TO GET THE RECORD FROM THE INTERNAL TABLE HEADER TO THE BODY AREA
IT ALLOWS DUPLICATION
IT IS USED TO A GET A RECORD FROM HEADER TO THE BODY AREA BUT IT WILL NOT ALLOW ANY DUPLICATION EXCEPT IF THERE IS ANY NUMERIC FIELS IT ADDS THAT FIELDS DATA BUT NOT AS A NEW RECORD