Select Category 
 

SAP Interview Questions Answers

SAP Interview Question - 31 : -

Can a transparent table exist in data dictionary but not in the data base physically?

SAP Interview Answer - 31 : -

NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE BOTH IN THE DICTIONARY AS WELL AS IN THE DATABASE,EXACTLY WITH THE SAME DATA AND FIELDS.
 

SAP Interview Question - 32 : -

Can BW run without a SAP R/3 implementation?

SAP Interview Answer - 32 : -

Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.
 

SAP Interview Question - 33 : -

Explain open SQL vs native SQL?

SAP Interview Answer - 33 : -

ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.
 

SAP Interview Question - 34 : -

What is “Extended Star Schema” and how did it emerge?

SAP Interview Answer - 34 : -

The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.