There are three categories of ABAP Dictionary types: (There are three correct answers) Data elements Structures Table types Domains Classes.
This is an elementary ABAP Dictionary type and can therefore be used to describe a single field or data element. It describes the type, length, and possibly the number of decimal places. You also define the field labels, output characteristics, and documentation for the data elements Data elements Structures Table types.
This is a complex data type that consists of multiple components. Structures can be used for ABAP Dictionary table definitions, function module parameters, object method parameters, and the design and definition of ABAP screens. Any changes in the structure or its component are automatically propagated to the repository objects wherever the specific structure is being used. Data elements Structures Table types.
This is a complete description of an internal table. It gives you the line type (which columns the internal table will have), the access type (whether it will be a standard, sorted, or hashed internal table), and the information about the key Data elements Structures Table types.
An ABAP Dictionary table defined in the ABAP Dictionary automatically creates a database table in the underlying
database using the structure defined in the ABAP Dictionary when the table definition is activated True False.
ABAP Dictionary can be referenced in an ABAP program with the TYPE addition for the corresponding data object definition True False.
What is correct to say about Domains: (There are five correct answers) Used to describe the technical attributes of a data element Domains can also be used directly as a type for data objects in the program Domains can be assigned to any number of data elements, and any changes in the technical attributes of the domain will automatically be applied to all of the data elements in which it is being used Domains have the following technical attributes: Domain formats and Domain output properties You can only use predefined ABAP Dictionary data types for a domain definition. The ABAP Dictionary has 12 predefined data types For the character data type, you have the option to select the Lower Case checkbox to allow the storage and display of lowercase characters. If this checkbox is not selected, the data is always stored and displayed as uppercase.
Based on the following description, choose the correct predefined data type:
Posting period. The length is set to six places for this data type. The format is YYYYMM. In input and output, a point is inserted between the year and month, so the template of this data type has the form YYYY.MM ACCP DATS UNIT TIMS.
Based on the following description, choose the correct predefined data type:
Character string. Fields of type CHAR can have a maximum length of 255 in tables CHAR STRING XSTRING TIMS.
Based on the following description, choose the correct predefined data type:
Client fields always have three CHAR places CLNT CHAR CUKY DEC.
Based on the following description, choose the correct predefined data type:
Currency key. Fields of this type are referenced by fields of type CURR. The length is set to five places for this data type CLNT CHAR CUKY DEC.
Based on the following description, choose the correct predefined data type:
Currency field. Equivalent to an amount field DEC. A field of this type must refer to a field of type CUKY (reference field). The maximum length for this data type is 31 places CLNT CHAR CUKY CURR.
Based on the following description, choose the correct predefined data type:
Date. The length is set to 8 places for this data type. The output template can be defined with the user profile DATS TIMS DATE TIMESTAMP.
Based on the following description, choose the correct predefined data type:
Counter or amount field with decimal point, sign, and commas separating thousands. It has a maximum length of 31 places. DEC FLTP INT1 PREC.
Based on the following description, choose the correct predefined data type:
Quantity. Equivalent to an amount field DEC. A field of this type must always refer to a units field with UNIT format (reference field). The maximum length for this data type is 31 places DEC FLTP INT1 QUAN.
Based on the following description, choose the correct predefined data type:
Uninterpreted byte string. Can have a maximum length of 255 in tables. If longer raw fields are required in tables, you
should select data type LRAW RAW LRAW INT1 PREC.
Based on the following description, choose the correct predefined data type:
Floating point number. The length (including decimal places) is set to 16 places for this data type FLTP DEC INT1 PREC.
Based on the following description, choose the correct predefined data type:
1-byte integer between 0 and 255. The length is set to three places for this data type FLTP INT2 INT1 INT4.
Based on the following description, choose the correct predefined data type:
2-byte integer between –32767 and 32767. Fields of this type should only be used for length fields. These long fields are positioned immediately in front of a long field (type LCHR, LRAW). With INSERT or UPDATE on the long field, the database interface enters the length that was actually used in the length field. The length is set to five places for this data type. FLTP INT2 INT1 INT4.
Based on the following description, choose the correct predefined data type:
4-byte integer between –2147483647 and 2147483647. The length is set to 10 places for this data type FLTP INT2 INT1 INT4.
Based on the following description, choose the correct predefined data type:
Character string of any length, but it has to be declared with a minimum of 256 characters. Fields of this type must be located at the end
of transparent tables (in each table there can be only one such field) and must be preceded by a length field of type INT2. If there is an
INSERT or UPDATE in ABAP programs, this length field must be filled with the length actually required. If the length field is not filled correctly, this may lead to a data loss in this field. A field of this type cannot be used in the WHERE condition of a SELECT statement LCHR LRAW SPRC LAN.
Based on the following description, choose the correct predefined data type:
Uninterpreted byte string of any length, but it has to be declared with a minimum length of 256. Fields of this type must be located at the end of transparent tables (in each table there can be only one such field) and must be preceded by a length field of type INT2. If there is an INSERT or UPDATE in ABAP programs, this length field must be filledwith the length actually required. If the length field is not filled correctly, this may lead to a data loss in the LRAW field. A field of this type cannot be used in the WHERE condition of a SELECT statement LCHR LRAW RAW LAN.
Based on the following description, choose the correct predefined data type:
Long character field in which only numbers can be entered. The length of this field is limited to a maximum of 255 places NUMC PREC INT4 LAN.
Based on the following description, choose the correct predefined data type:
Accuracy of a QUAN field. The length is set to two places for this data type NUMC PREC INT4 LAN.
Based on the following description, choose the correct predefined data type:
Uninterpreted byte string of variable length. In the ABAP Dictionary, a length can be specified for this type (at least 256 characters). This data type can be used only in types (data elements, structures, table types) and domains. You can store binary data of type RAWSTRING in the database. However, there are restrictions; for a description of them, refer to the documentation of the ABAP statement STRING. In ABAP, this type is implemented as a reference to a storage area of variable size. As the default for the output length, 132 characters are proposed. You cannot attach search helps to components of this type. RAWSTRING RAW STRING XSTRING.
Based on the following description, choose the correct predefined data type:
Character string with variable length. This data type can only be used in types (data elements, structures, table types) and domains. In the ABAP Dictionary, a length can be specified for this type (at least 256 characters). It can be used in database tables, but only with restrictions. For a description of these refer to the documentation of the ABAP statement STRING. In ABAP, this type is implemented as a reference to a storage area of variable size. As the default for the output length, 132 characters are proposed. You cannot attach search helps to components of this type. RAWSTRING RAW STRING XSTRING.
Based on the following description, choose the correct predefined data type:
Unit. Fields of this type are referenced by fields of type QUAN. The length of this data type is set to two or three places. UNIT QUAN DEC TIMESTAMP.
Based on the following description, choose the correct predefined data type:
ABAP Dictionary data type introduced in release 7.0 EHP 2; corresponds to ABAP type decfloat16. It is a decimal floating point number
stored in Binary Coded Decimals (BCD) format, and the permitted length of DF16_DEC is 1–15 digits DF16_DEC DF16_RAW DF15_SCL DF34_DEC.
Based on the following description, choose the correct predefined data type:
ABAP Dictionary data type introduced in release 7.0 EHP 2; corresponds to ABAP type decfloat16. This is a decimal floating point number
stored in binary format, and the allowed length is 16 digits. DF16_DEC DF16_RAW DF15_SCL DF34_DEC.
Based on the following description, choose the correct predefined data type:
ABAP Dictionary data type introduced in release 7.0 EHP 2; corresponds to ABAP type decfloat16. This is a decimal floating point number stored in binary format with subsequent scaling, and the data type length is 16 digits DF16_DEC DF16_RAW DF15_SCL DF34_DEC.
Based on the following description, choose the correct predefined data type:
Similar to DF16_DEC, this was introduced in release 7.0 EHP 2; corresponds to the ABAP type decfloat34. This is a decimal floating point
number stored in BCD format, and its allowed length is between 1 and 31 digits DF16_DEC DF16_RAW DF15_SCL DF34_DEC.
Based on the following description, choose the correct predefined data type:
A floating point number stored in binary format. The allowed length is 34 digits. This ABAP Dictionary data type is also introduced in release 7.0 EHP 2 and corresponds to ABAP type decfloat34 DF34_RAW DF16_RAW DF15_SCL DF34_DEC.
Based on the following description, choose the correct predefined data type:
A new ABAP Dictionary data type introduced in release 7.0 EHP 2; corresponds to the ABAP type decfloat34. This is a decimal floating point number stored in binary format with subsequent scaling. The allowed length is 34 digits DF34_RAW DF16_RAW DF34_SCL DF34_DEC.
You can also specify a conversion routine for the domain. The conversion routine is used to convert the contents of a screen field from the display format to SAP internal format for data storage and vice versa. True False.
What is correct to say about Data Elements: There are three correct answers) Data elements provide a complete description of a field with both semantic and technical information Data elements can be used in ABAP programs to define data objects by using the LIKE addition for the data object declaration The data type for the data element cannot be an elementary data type or a reference data type The Default Component Name is used if this data element is used to describe fields in a BAPI structure for a BAPI definition The Parameter ID is used to store (SET) the screen field value in memory if the parameter ID is defined for the screen field. Similarly, the parameter ID is used to get the input field value from memory by using the GET parameter
statement. You can also set the screen field attribute in Screen Painter to automatically read the value from memory without using the GET parameter statement. The parameter ID value is only available if it has been set in an application and is available in the memory. The parameter ID holds the value per session and per user and is not available once you have logged off.
What is correct to say about Structures: (There are four correct answers) Structures consist of sequences of components Hence, you can define a flat, nested, or deep structure in the ABAP Dictionary Structures can also be used in table definitions or table type definitions or for screen design You can only use flat and nested structures inside ABAP Dictionary table definitions Data elements, structures, and table types belong to the same namespace, and hence a data element, structure, or table type cannot have same name, even though they are essentially different things.
What is correct to say about Table types: (There are three correct answers) Table types define the structure and the technical attributes of an internal table You can refer to the ABAP Dictionary table types in an ABAP program to define an internal table You define the line type, access mode, and key for the table type in the ABAP Dictionary It provides a complete description of a field with both semantic and technical information You need to specify the delivery class for the table.
What is correct to say about Transparent Tables: (There are three correct answers) Defined in the ABAP Dictionary independently of the underlying database The database table is created upon activation of the table definition in the SAP system The database table has the same name as the ABAP Dictionary table, and the field names are also the same
(necessarily in the same order). The following are required settings for a table definition: Delivery and maintenance, Table fields, Foreign key, Technical settings, Index The database table is created upon definition of the table definition in the SAP system.
Talking about Delivery and maintenance in Transparent Tables. What is correct to say: (There are two correct answers) You need to specify the delivery class for the table You also need to specify the Data Browser/Table View maintenance for the table (Display/Maintenance Allowed with Restriction and Display/Maintenance Allowed) You have the option to generate the table maintenance dialog. The Display/Maintenance Allowed option also allows table maintenance and display via Transaction SE16.
Talking about Table fields in Transparent Tables. What is correct to say: (There are five correct answers) The field name should be unique within the table The field name can be a maximum of 30 characters long and can contain letters, digits, and underscores The table can have one until four key fields The fields of the table are either assigned to a data element or mapped to a predefined data type You can also include ABAP Dictionary structures for table field definition, but you have to define the individual key field of the table Attaching a search help to the table field itself is only possible if the table field is assigned to a predefined data type Reference type specification for the CURR and QUAN data type fields is required You define the foreign key relationship between the tables in the ABAP Dictionary. Using the foreign key, you can create a value check for the table field.
Talking about Technical settings in Transparent Tables. What is correct to say: The technical settings are used to optimize the data storage and access for the table The data class defines the physical area of the database (tablespace) in which the table should be created. The most important data classes defined in the ABAP Dictionary are APPL0 for master data that is not frequently modified compared to the transaction data, APPL1 for transaction data, and APPL3 for the organization data. The other two data classes, USR and USR1, are provided for customers and should be used by the customer. A special storage area must be allocated for the customer-specific data classes The size category defines the size of the extents created for the table and the expected space for the database. You can choose a size from 0 to 4, and each category is assigned a fixed memory size in the database. When you
create a table, initial space is saved for it in the database Buffering settings define how the table should be buffered. Table buffering improves the performance of the database access. The contents of the table are buffered on the application server and can be accessed from the application
server instead of the database server. The buffered table is invalidated if the entries in the database table change You also have the option to specify whether any changes to the table entries should be logged. If Log Data Changes is selected, then any changes in the table record will be logged in the log table DBTABPRT, or the list of changes can be viewed via Transaction SCU3. Switching this may slow down any update to the table because the updates need to be logged as well.
Talking about Index in Transparent Tables. What is correct to say: (There are three correct answers) The primary index of the table is automatically created based on the table key An index can be considered a copy of the table that has been reduced to certain fields. The copy is always in sorted order and provides faster access to the data record in the table The index also contains a pointer to the corresponding record in the actual database table You cannot create multiple secondary indexes for the table You should create too many indexes for the table, with more indixes the database access and database update are faster.
What is correct to say about Search Help: (There are two correct answers) Normally, search helps are assigned to a data element, and the search help is available to any field that refers to the data element The search help cannot be attached directly to a field of a table or a structure and to a check table You can assign search helps directly to a screen field as one of the field attributes in the Screen Painter, we recommend this The following types of search helps are created with the ABAP Dictionary tool: Elementary search helps, Collective search helps and Append search helps.
What is correct to say about Elementary Search Helps: (There are five correct answers) They must define from where the data for the search help would be read. This is determined by the Selection method input field The selection method can be a transparent table, database view, projection view, or help view If the data for the hit list comes from more than one table, then you must define the table join rules You must specify search help parameters for a search help. The parameters are used for the value selection and for the hit list display The parameter is not displayed if the value of LPos or SPos is greater than 0 You set the SDis flag for the parameter if the search help parameter is for the value selection only You select Select values immediately for the Dialog type, or select the option Dialog depending on number of values or Complex dialog with value restriction for the Dialog type.
What is correct to say about Collective Search Helps: (There are three correct answers) A collective search help combines several elementary search helps Collective search helps can be attached to fields, check tables, or data elements just like the elementary search help Only one search help can be attached to a field, table, or data element, but several search paths are available with collective search help Each elementary search help is represented to the user by a separate popup window.
Append search helps can be used to enhance collective search helps delivered by SAP for customer-specific requirements without modification: True False.
What is correct to say about Lock Objects: (There are four correct answers) Lock objects can be defined for a single table or for a set of logically related tables Within the SAP system you can control the access to the same data using the logical lock mechanism The lock objects created in the ABAP Dictionary are a database lock. You set and release locks by calling function modules for lock objects in your program The name of the lock object must start with EZ or EY if you are creating your own. The function modules for the lock object are automatically generated when you create and activate the lock object in the ABAP Dictionary. The two function modules generated during the activation of the lock object are ENQUEUE_<lock_object> and DEQUEUE_<lock_object>. The generated function modules are automatically assigned to a function group. You should never change the function module or the function group assignment. The function group or the module for the lock object should never be transported on their own.
Talking about Lock Objects. Connect the Type of lock/lock modes to their Meanings: Shared lock/read lock S (shared) Exclusive lock/write lock E (exclusive) Exclusive and non-cumulative X (exclusive non-cumulative).
What is correct to say about View Types and Maintenance: (There are five correct answers) Database views implement an inner join and hence select records for which there are entries in all of the tables included in the view Help views and maintenance views implement outer joins You can also select data from the maintenance view If you want to use an outer join in your application, you have to program it yourself. You have the option to specify Read only maintenance status for the view If you select the Read and Change status, you can update or change the table records through the view Database views permit also change access.
The following view types are possible in the ABAP Dictionary: (There are four correct answers) Database view Projection view Maintenance view Help view Master view Tree view.
What is correct to say about the Database view: (There are three correct answers) Automatically created in the underlying database when they are activated Should be created if you want to access logically connected records from different tables simultaneously Selection from the database view is generally slower than selection from the individual tables using a nested select Database views can only contain transparent tables.
What is correct to say about the Projection view: (There are four correct answers) Used to mask the fields of a table Contains exactly one table, and you cannot define the selection condition for the projection view A projection view creates a corresponding object in the underlying database Data selection from the projection view should be fast, owing to a smaller number of fields in the projection view Projection views can be created for pooled or cluster tables, as they can be mapped to the required singular database table.
What is correct to say about the Maintenance view: (There are two correct answers) Implemented as an inner join, and all the tables included in the maintenance view must be linked with a foreign key. You can enter the join condition for the maintenance view manually Maintenance views allow an easy way to maintain complex application objects Allow you to maintain the data for the application object together, and the data is automatically distributed to all of the underlying database tables.
What is correct to say about the Help view: (There are three correct answers) Can be used as a selection method for a search help Implemented as an inner join, and all tables included in the help view should be connected by foreign keys Generally, the selection method for the search help is a database view or table However,you have to use a help view as a selection method for a search help if a view with an outer join is required for data selection.
A transparent table can include a deep structure: True False.
ABAP data types can be used for a domain definition: True False.
Which of the following statements are true? Select all that apply. (There are two correct answers) A conversion routine can be assigned to a domain. A conversion routine can be assigned to a data element You define the value range in the data element You can enter documentation for the data element in the ABAP Dictionary.
(F1) help on the screen field displays the data element documentation True False.
Which of the following are true statements? Select all that apply (There are three correct answers) 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 You can also select predefined data types to define the data type of the data element Reference data types can be used to define the data type of the data element Field labels are defined for the domain.
You can define search helps and parameter IDs for a data element. True False.
The line type for a table type can contain a flat, nested, or deep structure. True False.
Which of the following are true statements? Select all that apply (There are three correct answers) Table fields can be assigned to a data element. Table fields can be assigned to an ABAP Dictionary data type directly Search helps can be defined for a table field that is assigned to a predefined data type A reference table and field are required for fields with the data types QUAN and CURR.
Which of the following statements regarding search helps are true? Select all that apply (There are three correct answers) You can use a maintenance view for the search help selection method You can use a database view for the search help selection method Help views can also be used for the selection method for search help You can use transparent tables for the search help selection method.
Which of the following regarding search helps is a true statement? Select all that apply The interface for the search help is defined by the IMP (import) and EXP (export) flag of the search help parameter The LPos parameter defines the position of the search help parameter in the search hit list 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 the selection method.
Which of the following statements are true? Select all that apply: (There are two correct answers) A database view is implemented as an inner join A maintenance view is implemented as an outer join A database view is implemented as an outer join A maintenance view is implemented as an inner join.
Which of the following statements are true? Select all that apply (There are three correct answers) 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 Projection views can have more than one table included for the view definition You cannot use a pooled or cluster table for a database view.
You can create projection views for pooled or cluster tables True False.
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.
What is the allowed length of the ABAP Dictionary data type DF16_DEC? The allowed length is between 1 and 15 digits The allowed length is 16 digits The allowed length is between 0 and 16 digits The allowed length is between 0 and 15 digits.
Which action on the underlying dictionary objects triggers a database table conversion? Inserting an APPEND structure Inserting a field of type reference Changing the order of non-key fields Reducing the size of the field.
|
