Capgemini SAP Abap Consultant Interview Questions and Answers

AMDP (ABAP Managed Database Procedures) are for complex logic, while CDS (Core Data Services) views are for data modeling.

• AMDP allows the execution of SQLScript directly in the database, enhancing performance for complex calculations.

• CDS views provide a semantic layer for data modeling, enabling easier consumption of data in applications.

• Example of AMDP: Creating a procedure to calculate aggregated sales data directly ...read more

Table functions in AMDPs and CDS enable complex data retrieval and manipulation in SAP HANA databases.

• AMDP (ABAP Managed Database Procedures) allows ABAP code to call HANA database procedures directly.

• Table functions can return a table-like structure, making them useful for complex queries.

• CDS (Core Data Services) views can consume table functions, enhancing data modeling capabilities.

• Example: A table function can aggr...read more

Data dictionary is a centralized repository of data definitions used in a database management system.

• Data dictionary stores metadata about the data in a database

• It defines the structure of the database objects such as tables, views, and data types

• It helps in maintaining data integrity and consistency in the database

• Data dictionary is used by developers, administrators, and users to understand the database schema

RICIEF objects are used in SAP ABAP for reporting purposes.

• RICIEF objects are used to define the structure of reports in SAP ABAP.

• They include fields like Report, Interface, Conversion, Enhancement, and Form.

• Examples of RICIEF objects include ALV reports, Smart Forms, and BAPIs.