Interview Questions.

Question 1. What Is The Difference Between Native Sql & Open Sql?

Answer :

There are  sorts of SQL being used in SAP ABAP programming language. They are

Native SQL
Open SQL
Open SQL permits to get right of entry to the database tables declared in the ABAP dictionary regardless of the database platform that the SAP R/three gadget is the use of.

Native SQL permits to apply database-particular SQL statements in a SAP ABAP program. This approach that possible use database tables that are not administered by using ABAP dictionary, and consequently integrate facts that is not a part of the SAP R/3 machine.

Open SQL isn't always restricted to any specific kind of database while a Native SQL is restrained to a specific type. 

ABAP packages that makes use of only Open SQL statements will work in any R/three system, irrespective of the database gadget in use. Open SQL statements can most effective paintings with database tables that have been created in the ABAP dictionary.

Question 2. What Is Abap Dictionary Or Data Dictionary? What Is The Transaction To Access Abap Dictionary?

Answer :

A data dictionary is a centralized garage location for information approximately the records this is saved in a database. It is basically an interface which helps us to recognize like what kind of statistics is saved in database, what are the houses and attributes of the facts and the relation among one-of-a-kind facts items available in database.

SAP’s information dictionary is referred to as the ABAP Dictionary. ABAP Dictionary is accessed via transaction code SE11.

SAP CRM Interview Questions
Question 3. What Are The Objects Of The Abap Dictionary Or What Types Of Objects Can Be Created In The Abap Dictionary?

Answer :

The simple objects of the ABAP Dictionary are tables, records factors and domain names. Objects that may be created within the ABAP Dictionary or via SE11 transaction are:

Tables
Data Elements
Structures
Table Types
Type Groups
Domains
Views
Search Helps
Lock Objects
Question 4. What Are The 3 Types Of Tables In Sap?

Answer :

There are three kinds of tables in SAP Dictionary (DDIC). They are:

Transparent Table
Pooled Table
Cluster Table
SAP CRM Tutorial
Question 5. What Do You Mean By Transparent Tables In Sap Abap?

Answer :

Whenever a desk is created and defined through ABAP Dictionary, then it's miles referred to as a obvious table. When the desk is activated in ABAP Dictionary, a desk automatically gets created within the underlying database with the same name as became described in ABAP Dictionary. 

So typically we are saying, transparent tables has one to 1 courting with underlying database which means that there will be simplest one bodily table on the database for every obvious table created and defined through ABAP Dictionary. 

The names of the desk and fields in underlying database will correspond or have the same names as the logical desk definition within the ABAP Dictionary.

Transparent tables can be used to save software statistics which consist of grasp records as well as transaction information. Transparent tables are probable the only type of desk that you may ever create as a developer.

SAP BI Interview Questions
Question 6. What Do You Mean By Pooled Tables In Sap Abap? Also Explain What Do You Mean By Table Pool?

Answer :

Tables in Data dictionary which has many to 1 dating with an underlying database table is known as Pooled table. In simple phrases, Pooled tables appear as many tables in ABAP dictionary, but the component is they may be saved as a unmarried table within the underlying database.

In ABAP Dictionary, you may see every and every pooled table is assigned to a Table Pool.

As it's miles understood that for lots pooled tables in ABAP dictionary, there's a unmarried desk called as Table Pool in an underlying database. A Table Pool is an underlying database desk with a special structure that allows the statistics of many ABAP Dictionary tables to be saved within it.

Tables M_MTVMA, M_MTVMB, M_MTVMC, M_MTVMD and M_MTVME can be visible in ABAP Dictionary. These all mentioned tables are Pooled Tables. All these tables have been assigned to one Table Pool i.E. M_MTVM, with the intention to be present in the underlying database and storing statistics of all of the 5 stated tables of ABAP Dictionary.

Pooled tables are basically utilized by SAP to save temporary facts or customizing information. Pooled tables also can be used to shop manipulate information (inclusive of screen sequences or application parameters).

Generally as a developer, we will never create a Pooled desk or Table Pool. It does not mean that we cannot create them. SAP has given the choice to create Pooled tables via SE80 transaction and Table pool through ABAP Dictionary.

Question 7. What Do You Mean By Cluster Tables In Sap Abap? Also Explain What Do You Mean By Table Cluster?

Answer :

A cluster table is just like a Pooled table. It has a many to one relationship with a table in an underlying database. Many cluster tables are saved in a single table in an underlying database known as a table cluster.

So desk cluster is similar to pooled desk pool. A table cluster holds handiest cluster table inside it.

Table clusters shop information from several cluster tables based totally at the number one key fields that they've in not unusual. 

Rows from the cluster tables are combined right into a unmarried row in the desk cluster. The rows are blended primarily based on the a part of the number one key they've in commonplace.

The biggest advantage of cluster table and pooled desk is that they reduce the number of database reads and thereby improve overall performance.

Tables CDPOS and CDHDR are Cluster tables in SAP ABAP Dictionary and CDCLS is the table cluster that exist inside the underlying database. CDCLS table contains or maintain statistics of each tables CDPOS and CDHDR within the underlying database.

SAP BI Tutorial SAP MM Interview Questions
Question eight. What Are The Differences Between Transparent Tables, Pooled Tables & Cluster Tables?

Answer :

Differences between transparent, pooled and cluster tables are:

Transparent tables have a one to at least one relationship with a bodily desk in an underlying database where as pooled tables and cluster tables have many to at least one relationship with a physical table in the underlying database (Relationship between tables in ABAP Dictionary & Underlying database).

For each obvious table there will be exactly simplest one desk within the underlying database while many pooled tables are saved in a unmarried desk in an underlying database referred to as desk pool. Similarly many cluster tables are saved in a unmarried desk inside the database known as a table cluster
In case of transparent tables, the underlying database desk may have the same name, equal number of fields and the fields may even have the identical names as described in ABAP Dictionary while for pooled tables and cluster tables the underlying database table may have distinctive call, different range of fields and fields will have exceptional names from what has been defined in ABAP Dictionary.
Transparent tables can have one or more primary key Whereas Primary key of every pooled desk of a table pool need not be identical while Primary key of each cluster desk of a table cluster must have at the least one key in commonplace.
Secondary indexes may be created for obvious tables, but for pooled and cluster tables we can't create any secondary index.
Transparent tables may be accessed thru each Native and Open SQL while pooled and cluster desk can be accessed via Open SQL only.
Transparent tables are used to maintain utility information which incorporates each grasp statistics as well as transaction data. 

Pooled tables reduce the quantity of database resources wanted when many small tables have to be opened on the equal time.

Cluster tables are used whilst the tables have number one key in not unusual and records in those tables are all accessed concurrently.

Question nine. What Is A View In Sap?

Answer :

A view is sort of a telescope which simply provides a photo of some thing. You can construct a view with special lenses or filters to assist you to study one or extra dictionary tables. You can study elements of one desk (selected records and/or fields) or combos of tables and components of tables. A view is an ABAP Dictionary item. In easy phrases, a View simply mirrors a whole database desk. A view could just appear to be a table and act similar to a desk – but it is not honestly a table.

A view does not contain information of its very own - alternatively, the view provides specialised get entry to to the statistics that exists in other tables. For this purpose, perspectives are often known as digital tables. Views are used to investigate one or greater tables. A view does not contain information of its personal.

Views combines more than one table. The structure of the view is described within the ABAP Dictionary. With the assist of perspectives, software-based view can be defined that mixes the records.

Data about an application item (like Purchase order, Sales Order, Invoice Verification, and many others.) is often disbursed on several database tables. By defining a view, possible define an software-dependent view that combines this statistics. The shape of this sort of view is described by specifying the tables and fields used in the view. Fields that are not required can be hidden, thereby minimizing interfaces. A view may be used in ABAP programs for records choice.

SAP BASIS Interview Questions
Question 10. What Are The Different Types Of Views In Sap?

Answer :

In SAP, you have overall 4 kinds of perspectives. Based on the manner wherein the view is carried out and the methods which can be accepted for having access to the view information they're divided into Database View, Projection View, Maintenance View and Help View. 

Database views implement an Inner Join whereas Projection View, Maintenance View and Help View put in force an Outer Join.

There are four Different kinds of Views in SAP. They are:

Maintenance View
Database View
Projection View
Help View
SAP MM Tutorial
Question 11. What Is A Database View?

Answer :

The database view is combining numerous fields of two or greater tables into single table. At least one relationship is needed is needed to combine tables to build a database view. Plus you could simplest study statistics from database view and cannot regulate the facts inside the view without delay (if view includes a couple of desk). Database views enforce an Inner Join on the tables. The database view is the most effective sort of view in SAP this is physically created at the database degree. 

For example, take into account  tables T1, T2.

Fields of desk T1 are F1, F2 and F3. Fields of desk T2 are F1, F5.

By the use of a Database view possible combine the fields of both tables T1 and T2, provided number one and overseas key relation is maintained among the 2 tables and for that reason final view will have fields like F1, F2, F3, F5.

SAP ABAP Interview Questions
Question 12. What Is A Projection View?

Answer :

In popular SAP tables you can actually find there are a number of fields. Sometimes it takes place or there may be a demand of viewing simplest a fewer no of fields of a desk, in such cases a projection view can be created. Projection views are created most effective on a unmarried table.

For example, if Table T1 has fields F1,F2,F3,F4,F5, F6, F7, F8, F9, F10, and many others…

Say there is a need to view records most effective for say Fields F1, F2, F4,F8 & F9, in such instances projection view may be created.

SAP CRM Interview Questions
Question 13. What Is A Maintenance View?

Answer :

Just like we've got desk preservation (SM30) for every desk, further if there may be a requirement to hold records for one or extra tables in a unmarried view, then protection view can be created. All the tables in a protection view must be connected with foreign key. The be part of conditions for maintenance views are usually derived from the foreign key robotically and therefore one can't without delay enter the join conditions as for database perspectives. Unlike Database views, you'll be able to adjust information from renovation view.

Thus, a preservation view permits you to maintain the statistics of an application item collectively. 

SAP BASIS Tutorial
Question 14. What Is A Help View?

Answer :

Help views may be used as selection methods for Search Helps. It is probably essential to create a Help View if you are attempting to accomplish an outer be a part of, on account that database views most effective create inner joins.

Question 15. State The Differences Between Database View & Projection View?

Answer :

The fundamental differences between projection view and database view are:

Database view can built over many tables whereas projection view may be built over a single desk handiest.
Database view may be up to date if the view is built over a single table whereas in projection view facts may be updated.
In case of database view, records updates can use open SQL or native SQL whereas in case of projection view, information updates ought to use open SQL.
Database view may be buffered whereas Projection view can not be buffered.
SAP ABAP Web Dynpro Interview Questions
Question 16. What Are The Relational Operations That Can Be Performed On View In Sap?

Answer :

There are three operations that can be finished on perspectives in SAP: Join, Projection and Selection.

The Projection Operation is used to slender a view’s cognizance to positive fields in a table.
The Selection Operation is used to slim a view’s cognizance to positive records in a table.
The Join Operation is used to mix facts from more than one tables into a unmarried view.
SAP ABAP Tutorial
Question 17. What Is A Delivery Class?

Answer :

Delivery Class manages the shipping of desk records when installing or upgrading in a patron copy whilst transporting among client systems.

Different delivery lessons to be had are:

C - Customizing table, maintenance handiest by using patron now not SAP import.
Example: Common Address Data (Country: T005)
E - Control table, SAP and purchaser have separate key regions, described in TRESC
Example: Messages (T100)
G - Customizing table, protected towards SAP Upgrade
Example: Communication: country dialing code (T005K)
L - Table for storing transient facts, added empty
Example: Lock Arguments (E070USE)
S - System desk maintenance handiest by using SAP.
Example: Language Key (T002)
A - Application desk (master and transaction statistics)
Example: Personal Address Data, Username (USR01)
W - System desk, contents portable thru separate TR items.
Example: Transport (E070), Tables (DD02L)
SAP Workflow Interview Questions
Question 18. What Are The Three Options Of Table View Maintenance While Creating A Table? Differentiate Between Them?

Answer :

There are three options available for desk view protection:

Display/maintenance allowed with regulations: When this selection is chosen, the show operation might be simplest functional, relaxation all the different operations like insert, replace and delete will be disabled.
Display/renovation allowed: When this selection is chosen, all type of operations (Insert, Update, Delete and Display) can be performed at the desk.
Display/renovation no longer allowed: When this selection is selected, no operation along with display table contents may be finished on the table.
SAP BI Interview Questions
Question 19. What Is The Importance Of Technical Settings While Creating A Table In Abap Dictionary?

Answer :

Technical settings permit you to optimize the garage requirements and table get admission to behavior of database tables.

Technical Setting comprises of the subsequent additives:

Data Class: Designates the table to an area inside the bodily database where similar tables are grouped.
Size Category: Identifies the amount of disk area so that it will be required to hold the facts information for a table in the database.
Buffering: Determines whether or not table statistics could be accessed directly from the database server or from global memory.
Logging: Creates earlier than and after photographs of adjustments to the desk of contents. Logging must be activated by means of the profile when the device is started.
SAP ABAP Web Dynpro Tutorial
Question 20. What Are Data Classes? What Are The Various Data Classes Available For Selection?

Answer :

The information class indicates a bodily location in an underlying database where the table is logically saved. Also it throws mild on what type of records may be stored inside the desk. Data elegance enables us to categorize the desk on the premise of sort of facts stored.

There are 3 essential statistics lessons

APPL0 - Master statistics - Master information is records that's often read, however rarely updated.
APPL1 - Transaction statistics - Transaction information is information that is often up to date.
APPL2 - Organizational and customizing information - Organizational und customizing statistics is statistics that's defined when the system is initialized after which rarely changed.
Sap Abap Hr Interview Questions
Question 21. What Is An Abap Dictionary?

Answer :

ABAP dictionary is a critical information management machine. Its major characteristic is to guide the creation and management of facts definitions.

Question 22. What Are The Basic Objects Of The Data Dictionary?

Answer :

Tables
Domains
Data factors
Structures
Foreign keys
Question 23. What Is The Difference Between Data Elements And Domains?

Answer :

Data Element: Data Element gives semantic attributes like area labels and online documentation

Domain: Domain offers the technical attributes like data kind and discipline duration

SAP ABAP Enhancement Interview Questions
Question 24. Can You Delete A Domain Which Is Being Used By Data Elements?

Answer :

No

SAP MM Interview Questions
Question 25. Can You Define A Field Without A Data Element?

Answer :

Yes. Use the course Utilities – > Direct Entry Type

Question 26. What Are The Difference Between Tables And Structures?

Answer :

Table:

Table has an underlying database table
Table has a number one key
Table has technical attributes
Structure:

No underlying database table
No number one key
No technical attributes
SAP ABAP Module Pool Interview Questions
Question 27. What Is A Data Class?

Answer :

The Data elegance determines in which table area the table is stored when it's far created inside the database.

SAP BASIS Interview Questions
Question 28. What Is A Size Category?

Answer :

The Size class describes the in all likelihood area requirement of the desk in the database.

Question 29. What Are Control Tables?

Answer :

The values distinct for the dimensions class and records elegance are mapped to database-precise values through control tables.

SAP ABAP Report Developer Interview Questions
Question 30. What Are The Function Of The Transport System And Workbench Organiser?

Answer :

The characteristic of the transport machine and the Workbench Organizer is to control any changes made to objects of the ABAP/four Development Workbench and to move those changes among exclusive SAP systems.

Question 31. What Is A Table Pool?

Answer :

A table pool (or pool) is used to combine several logical tables inside the ABAP/four Dictionary. The definition of a pool includes at the least  key fields and a protracted argument subject (VARDATA).

Question 32. What Are Pooled Tables?

Answer :

These are logical tables which have to be assigned to a table pool while they're described. Pooled tables can be used to save manage information (including display screen sequences or software parameters).

SAP ABAP ALV Reports Interview Questions
Question 33. What Is A Table Cluster?

Answer :

A table cluster combines several logical tables inside the ABAP/4 Dictionary. Several logical rows from one of a kind cluster tables are brought collectively in a single bodily document. The facts from the cluster tables assigned to a cluster are for this reason saved in a single common table within the database.

SAP ABAP Interview Questions
Question 34. Which Objects Are Independent Transport Objects?

Answer :

Domains, Data elements, Tables, Technical settings for tables, Secondary indexes for obvious tables, Structures, Views, Matchcode objects, Matchcode IDs, Lock items.

Question 35. What Are The Data Types Of The External Layer?

Answer :

ACCP, CHAR, CLNT, CUKY,CURR, DATS, DEC, FLTP, INT1,INT2, INT4, LANG, LCHR,LRAW, NUMC, PREC, QUAN,RAW ,TIMS, UNIT, VARC.

Question 36. What Are The Data Types Of The Abap/4 Layer?

Answer :

Possible ABAP/4 statistics kinds:

C: Character.
D: Date, format YYYYMMDD.
F: Floating-factor variety in DOUBLE PRECISION (8 bytes).
I: Integer.
N: Numerical person string of arbitrary period.
P: Amount or counter field (packed; implementation relies upon on hardware platform).
S: Time stamp YYYYMMDDHHMMSS.
T: Time of day HHMMSS.
V: Character string of variable length, period is given within the first two bytes.
X: Hexadecimal (binary) garage.
SAP ABAP Web Dynpro Interview Questions
Question 37. How Can We Set The Tablespaces And Extent Sizes?

Answer :

You can specify the quantity sizes and the tablespace (physical garage vicinity within the database) in which a transparent desk is to be stored via placing the size class and statistics magnificence.

Question 38. What Is A Data Dictionary?

Answer :

Data dictionary is a significant source of statistics in a records management machine. Its most important function is to help the. It has information about

What records is contained?
What are the attributes of the information?
What is the connection current among the diverse data factors?
Question 39. What Functions Does A Data Dictionary Perform?

Answer :

In a statistics management device, the important features done by way of the facts dictionary are:

Management of statistics definitions
Provision of statistics for evaluation
Support for software development
Support form documentation
Ensuring that the facts definitions are bendy and up-to-date.
Question forty. A Field Containing Currency Amounts (statistics Type Curr) Must Be Assigned To A Reference Table And A Reference Field. Explain?

Answer :

As a reference desk, a device desk containing all of the legitimate currencies is assigned or some other desk which incorporates a discipline with the foreign money key format. This field is called as a reference field. The venture of the sector containing currency quantities to the reference field is made at runtime. The value inside the reference subject determines the foreign money of the amount.

SAP Workflow Interview Questions
Question forty one. What Is The Significance Of Technical Settings (certain While Creating A Table In The Data Dictionary)?

Answer :

By specifying technical settings we will control how database tables are created inside the database. The technical settings allows us to - optimize garage area necessities

desk get entry to behaviour
buffering required
adjustments to entries logged
Question 42. What Is The Significance Of Delivery Class?

Answer :

The transport elegance controls the diploma to which the SAP or the consumer is accountable for table preservation whether or not SAP affords the desk without or with contents.
Determines the desk type. - determines how the table behaves whilst it's far first installed, at upgrade, while it's miles transported, and whilst a consumer replica is accomplished.
Sap Abap Hr Interview Questions
Question forty three. What Is The Maximum Number Of Structures That Can Be Included In A Table Or Structure?

Answer :

Nine.

Question forty four. What Are The Two Methods Of Modifying Sap Standard Tables?

Answer :

Append Structures and
Customizing Includes.
Question 45. What Is The Difference Between A Substructure And An Append Structure?

Answer :

In the case of a substructure, the reference originates in the desk itself, in the forma of a announcement include. 
In the case of an append structure, the desk itself stays unchanged and the reference originates inside the append shape.
Question forty six. What Are The Two Ways For Restricting The Value Range For A Domain?

Answer :

By specifying constant values.
By stipulating a fee table.
Question forty seven. What Is A Match Code?

Answer :

Match Code is a tool to assist us to search for information statistics in the device. Match codes are an green and person-pleasant seek aid where the key of a report is unknown.

Question forty eight. What Are The Two Levels In Defining A Match Code?

Answer :

Match Code object
Match Code Id.
Question forty nine. What Is The Maximum Number Of Match Code Id's That Can Be Defined For One Match Code Object ?

Answer :

A maximum quantity of match code Id's that may be defined for one Match code object is36. A suit code Id is a one man or woman ID which may be a letter or a variety of.

Question 50. Can We Define Our Own Match Code Id's For Sap Matchcodes?

Answer :

Yes, the numbers zero to nine are reserved for us to create our own Match Code IDs for a SAP defined Matchcode object.

Question fifty one. What Is An Update Type With Reference To A Match Code Id?

Answer :

If the data in one of the base tables of a matchcode ID changes, the matchcode facts has to be up to date. The replace kind stipulates whilst the matchcode is to be up to date and the way it is to be finished. The update type additionally specifies which method is for use for Building matchcodes . You need to specify the update kind while you outline a matchcode ID.

Question 52. What Are Conversion Routines ?

Answer :

Non-popular conversions from show layout to sap internal layout and vice-versa are applied with so known as conversion routines.

Aggregated Objects Views, matchcodes, and lock objects also are called aggregate items due to the fact they're formed from numerous related tables.

Question 53. How Many Types Of Views Are There ?

Answer :

Database View (SE11): Database views are implement an inner be part of, that is, handiest information of the number one desk (selected via the be a part of operation) for which the corresponding data of the secondary tables also exist are fetched. Inconsistencies between primary and secondary desk ought to, consequently, result in a reduced choice set. In database views, the be a part of situations can be formulated the use of equality relationships between any base fields. In the opposite types of view, they should be taken from current overseas keys. That is, tables can handiest be accumulated in a preservation or help view if they're related to each other thru overseas keys.
 Help View ( SE54): Help perspectives are used to output extra data when the web help device is known as. When the F4 button is pressed for a display screen subject, a check is first made on whether a matchcode is described for this area. If this is not the case, the help view is displayed in which the check table of the sphere is the number one desk. Thus, for each table no multiple help view may be created, this is, a table can only be primary table in at maximum one help view.
 Projection View: Projection perspectives are used to suppress or mask sure fields in a table (projection), accordingly minimizing the wide variety of interfaces. This manner that handiest the facts this is certainly required is exchanged whilst the database is accessed. A projection view can draw upon simplest one desk. Selection conditions can't be targeted for projection views.
Maintenance View ( SE54 ): Maintenance perspectives permit a enterprise-orientated method to looking at records, while at the equal time, making it viable to preserve the information worried. Data from numerous tables can be summarized in a protection view and maintained together through this view. That is, the records is entered thru the view and then disbursed to the underlying tables by way of the gadget.
Question 54. What Is Locking ?

Answer :

When  customers simultaneously try and access the same facts record, this is synchronised through a lock mechanism.

When conversation transactions are programmed, locks are set and released by means of calling certain feature modules. These feature modules are generated automatically from the definition of so-called lock gadgets within the ABAP/four Dictionary. To synchronize the get right of entry to to a table by way of setting and putting off locks, a Lock item needs to be described within the ABAP/four Dictionary. Activating the lock item routinely creates #characteristic modules for setting and putting off locks. These function modules have to be protected when programming interactive transactions.

Lock Mechanism : To set locks, a lock object ought to be described inside the ABAP/4 Dictionary. In this lock item, the ones tables in which records facts are to be locked via calling a lock are determined. All tables covered in a lock object must be connected to every different through foreign keys. The key fields of the tables in a lock item form the Lock arguments for the tables. The lock arguments are the idea for formulating the logical circumstance for identifying the statistics to be locked. When activating this lock object,  characteristic modulesB with the namesENQUEUE_ and DEQUEUE_ are generated.

Question 55. What Is Database Utility ?

Answer :

Database application is the interface among the ABAP/4 Dictionary and the underlying the SAP system. The database utility is the interface among the ABAP/4 Dictionary and the relational database underlying the SAP gadget. You can call the database utility from the preliminary display screen of the ABAP/4 Dictionary with Utilities Database utility. The database application allows you to create, delete and convert gadgets from the ABAP/four Dictionary in the database.

Question fifty six. How Can One Distinguish Between Different Kinds Of Parameters?

Answer :

Input parameters are used to bypass statistics to subroutines.
Output parameters are used to pass facts from subroutines.
Question 57. What Are The Types Of Subroutines?

Answer :

Internal Subroutines: The supply code of the inner subroutines can be within the identical ABAP/four software as the calling technique (inner name).
External Subroutines: The source code of the outside subroutines may be in an ABAP/4 program other than the calling system.