SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control.
SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.
Latency is referred to the length of time to replicate data from the source system to the target system.
Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process.
To avoid un-necessary information from being stored, you have to pause the replication by stopping the schema-related jobs
11) Explain what happens if the replication is suspended for a longer period of time or system outage of SLT or HANA system?
If the replication is suspended for a longer period of time, the size of the logging tables increases.
The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions.
You can avoid un-necessary logging information from being stored by pausing the replication by stopping the schema-related jobs.
In the HANA database, each SQL statement is implemented in the reference of the transaction. New session is allotted to a new transaction.
- Question #1: What is SAP HANA CDS view?
- Question #2: Which three TADIR objects/artifacts are created on activation of a ABAP HANA CDS?
- Question #3: How many types of ABAP HANA CDS views are there?
- Question #4: What is Association and Path expression in ABAP HANA CDS?
Question #11: What are the best practices which developers should keep in mind while using ABAP Core Data Services (CDS)?
SAP ABAP HANA Core Data Services(CDS) are foundation of new ABAP. It uses code push down technique and data virtualization for data fetching from much faster HANA database.
Some of best practices are as below:
Question #12: How ABAP CDS controls Access with DCL(Data Control Language)?
SAP ABAP HANA Core Data Services(CDS) uses syntax Define Role for access condition. This role management arrangement can further utilizes PFCG based role access. Example:
And CDS view is as follows:
Question #13: Which annotation in SAP ABAP CDS View is used to define underlying ABAP Data Dictionary(DDIC) structure?
ABAP Core Data Services uses syntax @AbapCatalog.sqlViewName to define underlying ABAP Data Dictionary(DDIC) structure. Example:
In above example, view DEMO_VIEW_ANNOT can be checked in ABAP dictionary Transaction SE11 however it can’t be edited there. To edit a CDS view, developer needs to use ADT(ABAP Development Tools for Eclipse). Detailed tutorial on how to install & use ADT is HERE.
@EndUserText.label is used to define short text of underlying ABAP Data Dictionary(DDIC) structure.
Basic ABAP CDS Interview Questions
- Enhanced Search Help (F4 help)
- SAP List Viewer with Integrated Data Access (ALV with IDA)
- Open SQL
- ABAP Core Data Services (CDS)
- ABAP Managed Database Procedures (AMDP)
- ABAP CDS table functions
- Metadata Extensions
What type of questions are asked in CDS interview?
What does CDS mean in SAP?
What is SAP CD annotation?