12/20/2023 0 Comments Sap abap oops interview questions![]() ![]() What are the difference Pool tables and transparent tables? Complex logic as well as transformation executed in DB layer.If we define information models inside HANA DB, We can also reduce the data transfer b/w DB and App layer.They also make use of Hardware advancements in HANA.Are Process of converting source data (in tables) into business understandable format.Used to convert linear structure to a multi dimension structure w/o knowing technical language.Q. What is Information Model and why is it required?Īns. Information Model: main purpose is to hide the technicalities to select data and make it easier for business users to model their data which can be pulled w/o technical knowledge just db functional knowledge is sufficient.Īn information model: ( purpose was to hide the complexity and to overcome some setbacks with the queries ) Schema user, i.e the database user is used to access the data with certain authorization levels. What is difference between SAP User and DB user?Īns. Can multiple ABAP systems connect to ABAP Database?Īdvanced SAP ABAP on HANA Interview Questions and AnswersĪns. A Catalog is collection of Database Schemas in HANA. Schema: grouping of all database objects, Schema is a mandatory database object allows companies to use same database keeping data from multiple system where DCL and DB constraints can be managed at schema level Standard programming guidelines by SAP .Features specific to HANA related artifacts.Fast Data Access, Optimized data access.Extended the static code check and SQL performance analysis. ![]() SELECT QUERY : NetWeaver creates a query plan : Plan based Optimizer & Cost Based Optimizer, which decides the order/sequence in which query will be processed..An ABAP Managed Database Procedure (or AMDP procedure) is a procedure written in a database-specific language (Native SQL, SQL Script, and L.,) implemented in an AMDP method of an AMDP class. Use information administration for the demonstratingĮssential licenses for the SAP BO information administrationsĪBAP Managed Database Procedures are a framework for managing and calling stored procedures or database procedures in AS ABAP. Manage ERP cases association the present discharge does not bolster interfacing with a few ERP occurrences Manage Data Services for entering the information from the SAP Business Warehouse as well as from different frameworks Modeling studio in HANA plays out different errands like:ĭeclares the tables which are put away in HANA, initial segment is to get the meta-information and after that timetable information replication employments CDS views are also more powerful than regular SE11 views. Therefore, CDS views can be consumed not only by ABAP programs but also by non-ABAP applications as well. The main difference is that, while a view defined in SE11 can only be executed within the SAP system, a CDS view resides on the HANA database itself. ![]() What is the difference between SAP ABAP and SAP HANA? This system deployment option is supported with AS ABAP 7.4 onwards. In this context, the SAP HANA platform is the primary database underlying the ABAP platform. It provides a namespace for systems which connects to Database.ĪBAP (development) for SAP HANA refers to all developments which leverage the power of SAP HANA within ABAP-based applications. ![]() A Schema is a dedicated area of database which can be used to store database objects like table, packages, folders, procedures. No Aggregation like org data, configurationĪns. If there is a data set where you have unique values(distinct)Īggregation of data is required (sales order table)Īlways selecting FEW columns in your programs out of so many columns in table. If you see there is large amount of data and having non-unique (Repeating e.g. Choosing table as Row Store is not as restrict as column ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |