Posts

Showing posts from December, 2014

SAP ABAP Dictionary Interview Questions With Answers-3

11) What Is A Database View? The database view is combining several fields of two or more tables into single table . At least one relationship is required is required to combine tables to build a database view. Plus one can only read data from database view and cannot modify the data in the view directly (if view involves more than one table). Database views implement an Inner Join on the tables. The database view is the only type of view in SAP that is physically created at the database level. For example, consider two tables T1, T2. Fields of table T1 are F1, F2 and F3. Fields of table T2 are F1, F5. By using a Database view one can combine the fields of both tables T1 and T2, provided primary and foreign key relation is maintained between the two tables and thus final view can have fields like F1, F2, F3, F5. For more information: http://www.saptechnical.com/Tutorials/ABAP/View/Database.htm 12) What Is A Projection View? In standard SAP tables one can find there ar...

SAP ABAP Dictionary Interview Questions With Answers-2

6) What Do You Mean By Pooled Tables In SAP ABAP? Also Explain What Do You Mean By Table Pool? Tables in Data dictionary which has many to one relationship with an underlying database table is called Pooled table. In simple words, Pooled tables appear as many tables in ABAP dictionary, but the thing is they are stored as a single table in the underlying database. In ABAP Dictionary, you can see each and every pooled table is assigned to a Table Pool. As it is understood that for many pooled tables in ABAP dictionary, there is a single table called as Table Pool in an underlying database. A Table Pool is an underlying database table with a special structure that enables the data of many ABAP Dictionary tables to be stored within it. Tables M_MTVMA, M_MTVMB, M_MTVMC, M_MTVMD and M_MTVME can be seen in ABAP Dictionary. These all mentioned tables are Pooled Tables. All these tables have been assigned to one Table Pool i.e. M_MTVM, which will be present in the underlying database...

SAP ABAP Dictionary Interview Questions With Answers-1

1) What Is The Difference Between Native SQL & Open SQL? There are two types of SQL being used in SAP ABAP programming language. They are Native SQL Open SQL Open SQL allows to access the database tables declared in the ABAP dictionary regardless of the database platform that the SAP R/3 system is using. Native SQL allows to use database-specific SQL statements in a SAP ABAP program . This means that one can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the SAP R/3 system. Open SQL is not confined to any particular type of database while a Native SQL is confined to a particular type. ABAP programs that uses only Open SQL statements will work in any R/3 system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP dictionary. 2) What Is ABAP Dictionary Or Data Dictionary? What Is The Transaction To Access ABAP Dictionar...