You want to add a field type CURR to a transparent table. What else must you do?
Create a new field CUKY as a pre-defined type. Create a reference to a field of type CUKY. Add a check table that contains a field of type CUKY. Add a key fieldof type CUKY.
You created a transparent table and during activation got a warning message "Enhancement category for table missing". What do you have to do to eliminate the warning message?
Select any option other than Not Classified from the enhancement category. Provide the correct reference field for the Currency or Quantuty field. Change the Data Class and Size category in the technical settings. Select the option Not Classified from the enhancement category.
You want to create a transparent table in the ABAP dictionary. When the table is physically created in the database?
When you run tha database utility transaction (SE14) When you activate the table When you insert the table name and select create When you save the table.
To which of the following can you assign search help?
Note there are 3 correct answer to this question
Structure component Check table Data element Table type Domain.
Which of the following transactions can you use to define transparent tables?
SM37 SE38 SE11 SE16N.
Which must a search help do?
There are 4 correct answers to this question.
Allow the user to select a response Have a dialog with the user Be used from a screen Use a table or a view for data selection Determine the values for selection by the user.
What is the difference between a value table and a check table?
A check table is defined in the domain, whereas a value table is defined in the data element. A value table is a check table after a foreign key is defined. A value table is defined in the domain, whereas a check table is defined in the data element. No difference; they are the same thing. A value table does not exist.
For which of the following purposes can you use the ABAP dictionary?
There are 2 correct answers to this question.
To maintain program translations To create develoment classes To activate logging for transparent tables To create lock objects.
Where do you create online documentation ((F1) help) for fields on the screen?
Field Data element Domain Table Structure.
How do you create lock objects and lock modules for use in ABAP programs that access the database?
Use the Function Builder to create the lock modules. The lock objects are created in the program logic. Use the ABAP Dictionary to create the lock objects. The lock modules are created automatucally. Use the Funtion Builder to create the lock modules and the lock objects. Use the ABAP dictionary to create the lock objects. Use the funtion builder to create the lock modules.
How do you create lock objects and lock modules for use in ABAP program that access the database?
Use ABAP dictionary to create the lock objects. Use the function builder to create the lock modules. Use the function builder to create the lock modules. The lock objects are created automatically. Use the function builder to create the lock modules and lock objects. Use the ABAP dictionary to create the lock objects. The lock module are created automatically.
Where can you define data types that can be used throughout the system?
Note there are 2 correct answers to this question
In a method In the Global interface In a function module In the ABAP Dictionary.
Which of the following customer modifications options are available in the table maintenance generator?
There are 2 correct answers to this question.
Events Append searches Maintenance screens Search helps.
Which of the following structures is created when you use a table type to define one of its components?
Nested structure Append structure Deep structure Flat structure.
Which screen in the ABAP Dictionary allows you to log data changes to the table?
Utilities-Database Objet-Database Utility Technical Settings Utilities-Settings Delivery and Maintenance tab Attributes tab.
What type of ABAP Dictionary view is implemented as an INNER JOIN?
Database view Projection view Help view Maintenance view.
Which database objects can you create in the ABAP Dictionary?
There are 2 correct answers to this question
Foreign Key relationships Logical databases Projection views Indixes.
In an ABAP program, you to assign an initial value to an elementary data object when you define it. Which addition must you use?
DEFAULT READ-ONLY OBLIGATORY VALUE.
What is the name of the field of the foreign key table that will be checked during input validation?
Primary key Check field Foreign key Referenced field.
Where should the labels for fields be stored?
Domain Table Fiel Data element Structure.
When an object that is already active is modified, it can affect other objects that use it directly or indirectly. How are called the affected objects?
Database objects Dependent objects WebDynpro object Repository objects.
What is the SAP recommended naming convention for append structures of standard SAPtables?
The components of an append structure should start with Z or Y. The components of an append structure should start with ZZ or YY. The name of the append structure must start with ZZ or YY. The name of the append structure must start with ZA.
Where are fixed values for fields stored?
Domain Fiel Table Structure Data element.
What will happen at runtime when accessing a buffered table?
If table data is read using indexes, the table buffer will not be filled. All SELECT statements will read data from the buffer. Following an update to a buffered record, all table buffers in the system will be updated. If data is read from the table buffer, the existing indexes are not used.
What do global types and local types have in common?
Documentation Technical information Field labels Search help.
Which of the following are table buffering types?
There are 3 correct answers to this question
Primary-key Full Single-record Columm-store Generic.
Which of the following statements are true?
There are 3 correct answers to this question.
You cannot use a pooled or cluster table for a database view. Projection views can have more than one table included for the view definition. The tables included in the maintenance view should have foreign key relationships. The tables included in the help view should have a foreign key relationship.
You have created table ZTAB you want to create a foreign key relationship to the table SAPTAB under which condition is this possible?
The text field in ZTAB must have the same as the corresponding fields of check table SAPTAB. Check field in XTAB must have a data element that does not refer to a domain. The check field in ZTAB must have the same ABAP dictionary type as the corresponding fields of check table SAPTAB. The check field in ZTAB must have the same domain as the corresponding field of check table SAPTAB.
The order of fields for a transparent table in the database...
Is allowed to be different than the ABAP Dictionary. Is create in the order of the Data Dictionary. Is created in the order of the ABAP Dictionary. Needs to match the ABAP Dictionary.
What data type you can create in the ABAP Dictionary?
Secondary index Lock object Structure Type group.
What is the correct order for using a lock object?
Set the lock, read the data, change the data, release the lock. Read the data, set the lock, change the data, release the lock. Set the lock. read the data, release the lock, change the data. Release the lock, Read the data, set the lock, change the data.
What can you create using the ABAP Dictionary?
There are 3 correct answers to this question.
Field symbols Domains Internal tables Transparent tables Type pools.
Which of the following are true statements?
There are 3 correct answers to this question.
The technical attributes of the data element can be defined by a domain, that is , the data type, the field length, and the number of decimal places Field labels are defined for the domain Reference data types can de used to define the data type of the data element You can also select predefined data types to define the data type of the data element.
You create a domain in the ABAP dictionary How can you use this domain?
As the data type of a selection screen field As the data type of an input field on a dialog screen As the data type of a data element in the ABAP Dictionary.
What does the enhancement category for a database table or structure do?
There are 3 correct answers to this question.
Specifies the types of changes that can be made to the structure Can produce warnings at incompatible points for the structure Makes a table Unicode-compliant Can identify where program behavior may change.
What properties will be set when you define a table type in ABAP dictionary?
Note there are three correct answers to this question
Change document Primary key Line type Access mode GET/SET parameter.
Compared to a predefined ABAP type what additional properties can be assigned to a domain?
There are 3 correct answers to this question.
Fixed values Parameter IDs Value tables Search helps Conversion exits.
You define database view A and maintenance view B in ABAP dictionary. What restrictions apply to this views ?
There are 3 correct answers to this question
Only A can be used in the FROM clause of SELECT statement. The join of both A and B is an inner join. The tables join in A must have foreign key realationships. The tables joined in B must have foreign key relationships.
Which of the following regarding search helps is a true statement?
Please select all the correct answers that apply. 4 are correct
You can use a maintenance view for the search help selection method. The LPos parameter defines the position of the search help parameter in the search hit list. The interface for the search help is defined by the IMP (import) and EXP (export) flag of the search help parameter. The SPos parameter defines the position of the input field on the dialog screen The text table for the selection method is automatically populated if the text table is attached to the database table being used as he selection method.
What are the advantages of creating a database view to implement a join, instead of formulating the join directly in an Open SQL SELECT statement?
There are 2 correct answers to this question
A database view can be buffered An outer join can only be implemented in a database view A secondary index can be create for a database view A database view can be reused in other programs.
Which type of view uses an inner join in a search help? Candidate key view Database view Hel view Maintenance view.
What is the condition that can restrict the number of records that can be displayed with the view?
Check Table Projection Selection.
In which database table type is there a one-to-one relationship between the Dictionary table definition and the relevant physical table in the database?
Pooled table Cluster table Transparent table Internal table.
Which options are available for a JOIN in ABAP Open SQL?
There are 3 correct answers to this question
LEFT OUTER JOIN CROSS JOIN RIGHT OUTER JOIN FULL JOIN INNER JOIN.
To which ABAP Dictionary definition can you assign fixed values?
Domain Data Element Component of a structure Field of a transparent table.
Which data element property do you set so that the system logs changes to the content of fields with this data element?
Documentation Change document PARAMETER ID Input history.
Which of the following can you define in the technical settings of a transparent table?
There are 3 correct answers to this question.
Size category Delivery class Table name
Data class Buffering type.
What is required to fully specify a Table Type in the ABAP Dictionary?
There are 3 correct answers to this question
Table key Access type Header line Table size Line type.
What is the allowed length of the ABAP Dictionary data type DF34_RAW?
The allowed length is between 1 and 34 digits. The allowed length is between 1 and 31 digits. The allowed length is between 0 and 33 digits. The allowed length is 34 digits.
When is a foreign key check performed on an input/output field?
If the field refers to the dictionary field for which a value help is defined If the field refers to the dictionary field for which a check table is defined If the field refers to the dictionary field for which a search is defined If the field refers to the dictionary field for which a append search is defined.
|
