20+ OTTO-AGN Interview Questions and Answers

Join statement is used to combine data from multiple tables based on a common field, while select for all entries is used to retrieve data from multiple tables based on a list of entries.

• Join statement is used when we want to fetch data from multiple tables based on a common field.

• Select for all entries is used when we want to retrieve data from multiple tables based on a list of entries.

• Join statement can be used with inner join, left outer join, right outer join, and full o...read more

Call transaction method is synchronous and session method is asynchronous.

• Call transaction method executes the transaction immediately and waits for the response while session method creates a session and executes the transaction in the background.

• Call transaction method is suitable for small data sets while session method is suitable for large data sets.

• Call transaction method is faster than session method but session method provides better error handling and logging.

• Call tr...read more

Function modules used in Session method

• SESSION_CREATE

• SESSION_CLOSE

• SESSION_IMPORT_FROM_MEMORY

• SESSION_EXPORT_TO_MEMORY

• SESSION_READ_BUFFER

• SESSION_WRITE_BUFFER

AT LINE-SELECTION, AT USER-COMMAND, INITIALIZATION, START-OF-SELECTION, END-OF-SELECTION are events used in report.

• AT LINE-SELECTION - triggered when a line is selected in the report output

• AT USER-COMMAND - triggered when a user enters a command in the report output

• INITIALIZATION - triggered when the report is initialized

• START-OF-SELECTION - triggered when the report starts processing data

• END-OF-SELECTION - triggered when the report finishes processing data

Events used in Module Pool Programming

• Initialization event (INIT)

• Process before output event (PBO)

• Process after input event (PAI)

• Process on value request event (POV)

• Process on help request event (POH)

• At selection screen event (AT SELECTION-SCREEN)

• At line selection event (AT LINE-SELECTION)

• At user command event (AT USER-COMMAND)

• Top-of-page event (TOP-OF-PAGE)

• End-of-page event (END-OF-PAGE)

To make a report editable, we can use ALV grid control or create a custom screen with input fields.

• ALV grid control allows users to edit data directly in the report output.

• Custom screen with input fields can be used to display and edit data from the report.

• We can also use function modules like REUSE_ALV_GRID_DISPLAY_EDIT to make the report editable.

• Authorization checks should be implemented to ensure only authorized users can edit the report data.

DDIC stands for Data Dictionary and Repository. It is a central component in SAP systems that stores and manages metadata about the structure and definition of data objects.

• DDIC is used to define and maintain database tables, data elements, domains, structures, views, and other objects.

• It provides a centralized repository for storing and managing metadata, ensuring consistency and integrity of data across the system.

• DDIC allows developers to create and modify data objects, an...read more

To convert from Adobe form to smart form and vice versa, you can use transaction codes and tools provided by SAP.

• For converting from Adobe form to smart form, you can use transaction code SMARTFORMS and import the Adobe form layout into a smart form.

• For converting from smart form to Adobe form, you can use transaction code SFP and export the smart form layout as an Adobe form.

• You can also use tools like SAP Adobe Document Services (ADS) to convert between Adobe forms and smar...read more

Secondary index is an additional index created on a database table to improve performance of read operations.

• Secondary index is created on non-key fields of a table.

• It helps in faster retrieval of data from the table.

• It is useful when the table has a large number of records.

• Example: A secondary index can be created on the 'city' field of a customer table to quickly retrieve all customers from a particular city.

To use layout from production to development, transport requests can be used.

• Create a transport request in production system containing the layout changes.

• Release the transport request in production system.

• Import the transport request in development system to apply the layout changes.

• Test the layout changes in development system before moving to other systems.

Lock object is used to synchronize access to shared data in SAP system.

• Lock object is created using transaction code SM12.

• It is used to prevent multiple users from accessing the same data simultaneously.

• Lock object can be set at different levels like client, system, table, etc.

• It can be used in ABAP programs using ENQUEUE and DEQUEUE statements.

• Example: Lock object can be used to prevent two users from editing the same sales order at the same time.

TMG stands for Transaction Variant Management. It is a tool used in SAP to create and manage transaction variants.

• TMG allows users to customize transaction screens without modifying the original program

• It can be used to hide or add fields, change field labels, and set default values

• TMG can also be used to create new transactions based on existing ones

• It is commonly used by SAP developers and consultants to meet specific business requirements

Hypen symbol in select query is used to concatenate fields or values in SAP ABAP.

• Hypen symbol is used to concatenate fields or values in select query.

• It is commonly used to combine multiple fields into a single field in the result set.

• Example: SELECT field1, field2, field1 - field2 AS concatenated_field FROM table_name.

Table types in SAP ABAP include transparent tables, pooled tables, cluster tables, and internal tables.

• Transparent tables store data from a single database table.

• Pooled tables store data from multiple tables with the same structure.

• Cluster tables store data from multiple tables with different structures.

• Internal tables are temporary tables used for data processing within a program.

The question is asking to differentiate between 'like' and 'type'.

• Like is used for comparing similarity or preference, while type is used for categorizing or classifying.

• Example: I like chocolate ice cream. (preference) vs. This is a type of dessert. (category)

• Like is subjective, while type is objective.

• Example: I like sunny weather. (subjective) vs. This is a type of climate. (objective)

Windows in smartforms allow you to display multiple pages of content in a single form.

• Windows in smartforms are used to organize and display different sections of a form.

• You can create multiple windows in a smartform and assign different content to each window.

• Windows can be used to display headers, footers, main content, etc. in a structured manner.

• You can control the visibility and positioning of windows in a smartform layout.

• Example: Creating a window for header informatio...read more

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

• It stores metadata about the database objects such as tables, views, data types, etc.

• It helps in maintaining data integrity by defining constraints and relationships between objects.

• It simplifies database management by providing a single source of truth for data definitions.

• It is used by developers to create and modify database objects in SAP ABAP.

Encapsulation is the process of hiding implementation details and restricting access to an object's properties and methods.

• Encapsulation helps in achieving data abstraction and information hiding.

• It allows for better control over the data and prevents unauthorized access.

• Encapsulation is implemented using access modifiers such as public, private, and protected.

• For example, a class may have private variables that can only be accessed through public methods.

• Encapsulation is a f...read more

Buffering is a technique used to temporarily store data in memory for faster access.

• Buffering helps reduce the number of database reads by storing frequently accessed data in memory.

• There are different types of buffering in SAP like single record buffering, generic buffering, and full buffering.

• Example: Buffering can be used in SAP to store frequently accessed customer data in memory for faster retrieval.

Field symbols in SAP ABAP are placeholders for data objects that allow for dynamic assignment at runtime.

• Field symbols are used to point to a data object without actually storing the data itself.

• They are declared using the FIELD-SYMBOLS statement.

• Field symbols are particularly useful for dynamic programming and working with internal tables.

• They can be assigned to any data object at runtime, allowing for flexibility in coding.

• Example: FIELD-SYMBOLS TYPE any.

• Example: ASSIGN T...read more

Software engineering is the application of engineering principles to the design, development, maintenance, testing, and evaluation of software.

• Involves systematic approach to software development

• Focuses on quality, efficiency, and reliability of software

• Includes phases like requirements analysis, design, implementation, testing, and maintenance

• Utilizes various methodologies like Agile, Waterfall, etc.

• Examples: designing a new mobile app, developing a website, creating a datab...read more

Sales focuses on selling products or services, while marketing focuses on promoting and creating demand for those products or services.

• Sales involves direct interaction with customers to close deals.

• Marketing involves creating strategies to reach and engage potential customers.

• Sales focuses on short-term goals and revenue generation.

• Marketing focuses on long-term goals and building brand awareness.

• Sales is more transactional, while marketing is more relationship-oriented.

• Sale...read more