IMPORTANT ABAP Tcodes

List of important ABAP transaction codes:


SE11 – ABAP Dictionary

SE12 - ABAP/4 Dictionary Display

SE13 - Maintain Technical Settings (Tables)

SE18 – Business Add-Ins (BADI)

SAP ABAP CERTIFICATION MCQs

ABAP CERTIFICATION Multiple Choice Questions

Which of the following statements about APPEND structures are true?

For this question there are 3 correct options.

1.         After adding an APPEND structure to a table, you must convert the table. False

2.         You can use an APPEND structure like any other structure in ABAP programs. True 

3.         An APPEND structure allow you to append field to an SAP table without having to modify the table itself. True

4.         An APPEND structure is the same as substructure. True

5.         An APPEND structure can be assigned to several tables. False

Which of the following statements apply to table appends?

For this question there are 3 correct options.

1.            There can be several append structures for one table. True

2.            If you copy a table to which an append structure has been added, the fields in the append structure become standard fields in the table. True

3.            When you active the table, all the active append structure of the table are established and appended to the table in the database.True

4.            An append structure can be assigned to several tables. False

 Which SAP GUI types are there? 

For this question there are 3 correct options.

1.      SAP GUI for Windows. True 

2.      SAP GUI for HTML. True 

3.      SAP GUI for Web AS. False 

4.      SAP GUI for ITS. False 

5.      SAP GUI for Java. True

Is it possible to increase the number of key fields in transparent tables that
are already active? (Single selection) 

1.         No, Key changes are not allowed. False 

2.         Yes, irrespective of whether the table already contains data or not.True 

3.         Yes, however, the table must not contain any data yet. False

For what purpose are foreign key (FK) defined in the ABAP Dictionary?

For this question there are 2 correct options.

1.         For the purpose of data consistency: when you active the table the FKs are
created in the database. You thus prevent invalid data from getting into the table. False

2.         For the propose data consistency: when you maintain data records using dialog transaction (screens). True 

3.         The input values are automatically check in accordance with the FKs. True 

4.          FKs are used solely for documenting table relationships. False 

In which of the following table types is there a one-to-one relationship between the table defined in the ABAP Dictionary and relevant physical table in the database? (Single selection) 

1.         Cluster table False 

2.         Pooled table. False 

3.         Structure. False 

4.         Transparent database table. True

The following are true about ‘EXEC SQL’. 

For this question there are 2 correct options.

1.         You can end the Native SQL with a semicolon. True

2.         You can end the Native SQL with a period. False

3.         You cannot perform reliable authorization checks using EXEC SQL. True

4.         Host variables in the Native SQL are identified with a preceding hash (#).False

DOWNLOAD FREE EBOOKS

Download Free Ebooks

Free Motivational Books and Inspirational Ebooks

SAP POOLED TABLE

SAP ABAP Pooled Table 

·         Pooled tables are logical tables that must be assigned to a table pool when they are defined.

·         Pooled tables are used to store control data.

·         Several pooled tables can be combined in a table pool. The data of these pooled tables are then sorted in a common table in the database.

·         It has a many-to-one relationship with a table in the database.

·         The database table has different name, different number of fields and fields have different names.

·         Secondary indexes cannot be created.

·         They can be accessed using open SQL only.

·         They are used to hold a large number of very small tables (stores customizing data or system data)

To get SAP Job Updates

Submit Resume

SAP CLUSTER TABLES

SAP ABAP Cluster Table

·         It has a many-to-one relationship with table in the database.

·         The database table has different name, different number of fields and fields have different names.

·         Secondary indexes cannot be created.

·         They can be accessed using open SQL only.

·         There are some limitations on cluster tables like we can't use joins on these tables, Select on cluster table is always very slow.

·         Whenever we write query on any cluster table in the table cluster data will be fetched for the entire table as data for all the tables in the cluster stores as a single record.

·         Cluster tables are logical tables that must be assigned to a table cluster when they are defined.

·         Cluster tables can be used to store control data.

·         They can also be used to store temporary data or texts, such as documentation

To get SAP Job Updates

Submit Resume