ABAP
can be used.
ii)Pool tables & iii)Cluster tables -
These are logical tables that are arranged as records of transparent tables.one
cannot use native sql on these tables
(only opensql).They are not managable directly using database system tools.
iv)Internal tables - .
12. What is the step by step process to create a table in data dictionary?
12. What is the step by step process to create a table in data dictionary?
12. What is the step by step process to create a table in data dictionary?
12. What is the step by step process to create a table in data dictionary?
ans:-
step 1: creating domains(data type,field length,range).
step 2: creating data elements(properties and type for a table
field).
step 3: creating tables(SE11).
13. Can a transparent table exist in data dictionary but not in the data base
13. Can a transparent table exist in data dictionary but not in the data base
13. Can a transparent table exist in data dictionary but not in the data base
13. Can a transparent table exist in data dictionary but not in the data base
physically?
physically?
physically?
physically?
ANS:- 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.
14. What are the domains and data elements?
14. What are the domains and data elements?
14. What are the domains and data elements?
14. What are the domains and data elements?
ANS:-
DOMAINS : FORMAL DEFINITION OF THE DATA TYPES.THEY SET
ATTRIBUTES SUCH AS DATA TYPE,LENGTH,RANGE.
DATA ELEMENT : A FIELD IN R/3 SYSTEM IS A DATA ELEMENT.
15. Can you create a table with fields not referring to data elements?
15. Can you create a table with fields not referring to data elements?
15. Can you create a table with fields not referring to data elements?
15. Can you create a table with fields not referring to data elements?
ANS:-
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not