10+ Shreenath Kia 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

Function modules used in Session method

• SESSION_CREATE

• SESSION_CLOSE

• SESSION_IMPORT_FROM_MEMORY

• SESSION_EXPORT_TO_MEMORY

• SESSION_READ_BUFFER

• SESSION_WRITE_BUFFER

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

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)