SAP Report Interview Questions and Answers
Question - 31 : - What is Refresh in Internal Table?
Answer - 31 : - 'Refresh' is the keyworld which clears the contents of an internal table body.
Question - 32 : - What is the Difference Between Collect and Sum?
Answer - 32 : - COLLECT allows you to create unique or summarized datasets. The system first tries to find a table entry corresponding to the table key. The key values are taken either from the header line of the internal table itab, or from the explicitly-specified work area.
If the system finds an entry, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, the system creates a new entry instead.
The way in which the system finds the entries depends on the type of the internal table:
- STANDARD TABLE:
The system creates a temporary hash administration for the table to find the entries. This means that the runtime required to find them does not depend on the number of table entries. The administration is temporary, since it is invalidated by operations like DELETE, INSERT, MODIFY, SORT, ...). A subsequent COLLECT is then no longer independent of the table size, because the system has to use a linear search to find entries. For this reason, you should only use COLLECT to fill standard tables.
- SORTED TABLE:
The system uses a binary search to find the entries. There is a logarithmic relationship between the number of table entries and the search time.
Question - 33 : - What are the ways of creating Tables?
Answer - 33 : - There are two ways to create table
1) top-down approach
2) bottom-up approach
Question - 34 : - What are Function Modules?
Answer - 34 : - Function modules is a extranal subroutine.we can call it to outside the program.its a mini program. its used for redues the coding,easy to find error.
Function modules is like a small program (is not a suboutine because sub-routines are not standalone objects-i.e we cannot execute them alone) which are similar to 'functions' in C.
We can pass the varible and get the return values even with out knowing what is happening in its code.
They are standalone programs-i.e.we can debug and execute them alone unlike subroutines and macros and includes.
Question - 35 : - What is CAT?
Answer - 35 : - "CAT" Computer Aided Test Tool. Used to create test cases for application testing purposes.
Question - 36 : - What is LDB?
Answer - 36 : - Logical Database is an ABAP program which retrieves data from various tables
Which are interrelated and provides a read only view of the data.
Question - 37 : - What are the EVENTS in Report Program? What are EVENTS In Interactive Report and Explain?
Answer - 37 : - Classical Report Events are
LOAD OF PROGRAM.INITIALIZATION.
AT SELECTION-SCREEN.START-OF-SELECTION.
TOP-OF-PAGE.END-OF-PAGE.
END-OF-SELECTION.
Interactive events are
AT LINE-SELECTION.
AT USER-COMMAND.
TOP-OF-PAGE DURING LINE-SELECTION.
AT LINE-SELECTION:Allows the user to interact with the lists.
AT USER-COMMAND:USed for handling Push buttons.
SET PF-STATUS:Provides User Interface.
Question - 38 : - What are the various techniques of BDC?
Answer - 38 : - call transaction
session method
direct input method
Question - 39 : - What is SQL Trace?
Answer - 39 : - SQL Tracer is a tool used to measure the performance of ABAP program.
T.code :st05
Question - 40 : - What is LUW?
Answer - 40 : - It is a span of time during which database records are updated either
commit or rollback.