Top 50 Sap Abap Alv Reports Interview Questions
Q1. What Are Text Elements?
Text elements makes program less complicated to maintain application texts in unique languages. These are used for maintaining list headers, choice texts in applications.
Q2. What Is Slis In Alv And Standard Type Tables Of It?
SLIS is the sort library for ALV grid.
If you may use the ALV you have to upload TYPE-POOLS : SLIS. Command at the start of your code.
SLIS_LAYOUT_ALV,
SLIS_T_FIELDCAT_ALV
SLIS_T_LISTHEADER,
SLIS_T_EVENT,
SLIS_SELFIELD.
Q3. How Many Types Of Standard Internal Tables?
STANDARD TABLE: The secret is, with the aid of default, set to NON-UNIQUE. You may not use the UNIQUE addition.
SORTED TABLE: Unlike widespread tables, taken care of table haven't any default setting for the uniqueness characteristic. If you do no longer specify either UNIQUE or NON-UNIQUE, the system defines a usual desk kind, wherein forte is irrelevant. You can use ordinary types to specify the kind of normal subroutine parameters.
HASHED TABLE: Hashed tables have no default setting. You need to use the UNIQUE addition with hashed tables. You won't use NON-UNIQUE.
Q4. What Is Refreshing In Internal Table?
'Refresh' is the keyword which clears the contents of an inner desk frame.
Q5. Can We Set Page Headers To Details Lists?
Yes. Use TOP-OF-PAGE DURING LINE-SELECTION event.
Q6. What Is A Table Maintenance Generator?
To permit customers to maintain desk the usage of SM30 transaction you operate Table Maintenance generator.
Q7. What Is A Report?
There are 2 sort of reviews:
Interactive report
Classic reviews
In classic reviews, we will see the output in unmarried list where as in interactive reviews we can see the output in a couple of lists.
Q8. What Is The Significance Of A Stacked List?
The secondary list is also referred to as the stacked list and it will be shown at the complete screen if we don’t write its coordinates of the command window.
Q9. What Is The Difference Between Clear, Refresh?
CLEAR: It clears any field, structure or Header line of inner table.
REFRESH: Deletes all entries of internal table.
Q10. Explain Check Table And Value Table?
Check table works at desk stage and value desk works at domain level.
Check desk is nothing however master desk that u will create with legitimate set of values.
Value desk it presents the list of values and it's going to robotically proposed as a test table whilst creating overseas key relationship.
Q11. What Is Use Of Reuse_alv_fieldcatalog_merge?
Using this characteristic module, you could get the Field catalog for a given Internal table or DD Structure. Once you get the Field catalog, you may exchange the properties of each area.
Q12. What Are The Interactive Reports?
The person can Interact with the file. We could have a drill down into the file records.
We will have a simple listing (variety starts from 0) and 20 secondary lists (1 to 21).
Events related to Interactive Reports are:
AT LINE-SELECTION
AT USER-COMMAND
AT PF<key>
TOP-OF-PAGE DURING LINE-SELECTION.
HIDE announcement holds the statistics to be displayed within the secondary list.
Sy-lisel : includes records of the selected line.
Sy-lsind : carries the extent of file (from zero to 21)
Interactive Report Events:
AT LINE-SELECTION : This Event triggers while we double click a line on the listing, whilst the occasion is brought about a brand new sub listing is going to be generated. Under this occasion what ever the statements which can be been go back may be displayed on newly generated sub list.
AT PFn: For predefined characteristic keys...
AT USER-COMMAND : It offers consumer functions keys.
TOP-OF-PAGE DURING LINE-SELECTION : Top of page event for secondary listing.
Q13. What Is An Abap Memory And Sap Memory And How To Use Them?
ABAP memory is a reminiscence place that each one ABAP packages within the equal inner consultation can get right of entry to using the EXPORT and IMPORT statements.
SAP memory is a memory region to which all fundamental periods within a SAPgui have access. You can use SAP reminiscence either to pass information from one application to another within a session, or to bypass statistics from one consultation to every other. Application applications that use SAP reminiscence need to do so using SPA/GPA parameters (also referred to as SET/GET parameters).
Q14. What Is Significance Of Hide?
In Interactive reviews, HIDE announcement shops the value of that area for that line. If the person places the cursor on a line and click on on something those values are mechanically populated to that hidden fields.
Q15. What Are The Ways Of Creating Tables?
There are two approaches to create table
Top-down approach
Bottom-up technique
Q16. How Do You Define Default Variant For Alv?
He consumer can programmatically set the initial (default) variant for list display.
The default variation may be located the usage of the feature module 'REUSE_ALV_VARIANT_DEFAULT_GET'.
Q17. How Can Validate Input Values In Selection Screen And Which Event Was Fired?
At choice-screen is an event, that is used to validate the selection display screen input fields, in case you want to validate the unique enter area we use at choice-display on occasion.
AT SELECTION-SCREEN ON occasion is used to validate enter.
Q18. What Is Binary Search?
Binary seek is a searching algorithm in which the whole facts in spitted into elements and searching is began from one of the element. In regular seek records is searched linearly from top to bottom that is much less green than binary search.
Binary seek is used to get the greater statistics from internal desk rather than linear search ,and binary search is the quicker and efficient .
Q19. What Is Alv?
ALV stands for ABAP List Viewer. ALV gives us a trendy List layout and user interface to all our ABAP reviews. ALV is created by way of a hard and fast of standard feature modules supplied by means of SAP.
Q20. What Is The Difference Between Skip And Reserve?
SKIP provides empty area among traces, while RESERVE executes a page spoil on the current page if the range of lines among modern line and the web page footer is less than the range laid out in RESERVE statement.
Q21. What Events Are Mandatory In Reports?
Report dont need any occasion to execute the output.It we we positioned start-of-selection there is no obligatory to use cease-of-choice. End-of-choice is used whilst we want to execute some output even if a few exception happens to skip begin-of-choice.
There isn't any mandatory occasion inside the report software. But, if we don't explicitly write any event, device implicitly starts with begin of choice occasion.In case of database selection, it is a superb practice of use quit-of-choice occasion.
Q22. How Do You Modify A Table?
You can modify a document using MODIFY statement or UPDATE Statement.
Q23. What Are The Steps To Create Custom Table?
Create all of the Domains and Data factors as wished the usage of Txn SE1@
Start creating the table using Tcode SE1@
Maintain Delivery Class (A-Application Table, C-Customizing, etc)
Enter all of the fields (MANDT need to be the primary area) and appropriate records elements or Built in Types for every discipline.
Make certain you pick the Primary Key for this table.
Maintain the Technical Settings (Data elegance, Size, Buffering information)
Create Secondary indexes as wished
Activate the Table
Q24. What Is The Secondary Index?
There is an Index created through default for the Primary Key of the desk and this is referred to as Primary Index. If you create, another index this is referred to as Secondary Index for that table. Secondary Indexes are created to enhance the performance of SELECT statements.
Q25. Which Is The First Event That Is Triggered In A Report?
Load of software is the primary triggering occasion in the classical reports, wherein as abaper factor of view initialization is the first triggering event.
LOAD-OF-PROGRAM which gets triggered internally in the SAP system, then the occasion INITIALIZATION gets trigger.
Q26. What Is The Difference Between Collect And Sum?
COLLECT lets in you to create specific or summarized datasets. The gadget first tries to discover a desk access similar to the desk key. The key values are taken either from the header line of the inner table itab, or from the explicitly-precise work location.
If the system reveals an access, the numeric fields that are not part of the table key (see ABAP quantity types) are introduced to the sum general of the present entries. If it does not find an access, the device creates a brand new access instead.
Q27. What Are Pricing Tables?
Pricing Tables starts with A* like A001, A002, A900 like that.
KONH – Condition Header
KONP – Condition Detail
Q28. When The Top-of-web page Event Does Get Triggered?
TOP-OF-PAGE event may be prompted whilst the primary ULINE, WRITE or SKIP assertion takes place in a program.
Q29. What Are Classical Reports?
These are the most simple reviews. Programmers analyze this one first. It is simply an output of facts the use of the Write assertion interior a loop.
Classical reviews are ordinary reports. These reports are not having any sub reviews. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.
Events In Classical Reports:
INTIALIZATION: This occasion triggers before choice screen display.
AT-SELECTION-SCREEN: This occasion triggers after processing person input nevertheless choice display is in lively mode.
START OF SELECTION: Start of selection display screen triggers after processing choice display.
END-OF-SELECTION: It is for Logical Database Reporting.
Q30. What Is The Difference Between At Selection Screen And At Selection Screen Output?
AT SELECTION-SCREEN OUTPUT is like Process Before Output Event. This could get precipitated before display screen is displayed. This may be used to make fields invisible/visible based totally on selection.
AT SELECTION-SCREEN: This would be induced in case you hit anything (Enter, Drop-Down, Help, Execute) after the selection display is displayed.
Q31. What Is The Difference Between Data Element And Domain?
Data detail is the collection of domain with brief description, while area is collection of datatype and duration.
Domain carries handiest technical attributes (facts kind , size) where as Data Element includes Technical attribute in addition to Semantic attributes(Field description).
Q32. What Are The Uses Of Alv Reports?
Sorting of information
Filtering of records
Totals and Sub-totals
Download the document output to Excel/HTML
Changing the order of the columns inside the record
Hide the unwanted columns from the report
Q33. What Is The Difference Between Skip And New-line?
SKIP generates a blank line, while the NEW-LINE causes the control to transport to subsequent line.
Q34. What Are The Export Parameters Of Alv Reports Function Modules?
E_EXIT_CAUSED_BY_CALLER: Delete listing in CALLBACK_USER_COMMAND
ES_EXIT_CAUSED_BY_USER: How the consumer left the list Tables
T_OUTTAB: Table with statistics to be displayed ---mandatory
Q35. What Are Layout Parameters Options Of Alv?
Display alternatives:
Exceptions
Totals
Interaction
Detail screen
Display variations (simplest for hierarchical-sequential lists)
Color
Other
Q36. What Is The Difference Between Client Dependent And Independent Tables?
If you have MANDT because the first field that is Client Dependant desk otherwise it isn't always. Usually most of the tables are client dependent. Only few like RFC Connections desk (RFCDES), Batch Jobs (TBTCO and TBTCP) are not purchaser dependant.
Q37. How To Set Hotspot In Alv Reports For A Field?
In the Field Catalog table, you set the HOTSPOT property of the sphere to X.
Q38. What Are Oss Notes?
SAP affords aid inside the shape of Notes additionally and that is called OSS. Can take a look at the link Sree supplied.
Just for an example in case you face any mistakes in your machine. Then there's error quantity related to the mistake. Then you can search for the OSS no longer for the error quantity, and the word will give you possible option to your hassle.
Q39. What Is The Command To Be Used To Transfer The Data From One Internal Table To Another Internal?
Move itab1 to itab2
We can use APPEND for copying records from one ITAB to every other ITAB with the aid of retaining in a loop. But it isn't green. Instead we will use as follows:
ITAB1[]=ITAB2[].
Q40. What Is The Difference Between Select Single And Select Up To One Row?
SELECT SINGLE may be used if you know the entire key to pick out a file. If you do no longer have the entire Key to pick and you are inquisitive about one unmarried row, you may use SELECT UPTO 1 ROWS. If you use a SELECT SINGLE with out a full key, you will get a caution message in Extended Program checks.
If you have the full Key use SELECT SINGLE
If you do no longer have the whole Key to choose and you are interested in one single row, you can use SELECT UPTO 1 ROWS..
Q41. What Is Sort Internal Table Options In Alv?
This inner desk has the subsequent fields:
Sops: Sort sequence.
Fieldname: Internal output desk area call.
Tab call : Only applicable for hierarchical-sequential lists. Name of the internal output desk.
Up: 'X' = type in ascending order.
Down: 'X' = kind in descending order.
Sub tot : 'X' = subtotal at organization cost trade.
Group: '* ' = new web page at institution cost trade ,'UL' = underline at institution value change.
Q42. How To Create Secondary Index?
Using SE11, Enter the table name and click on Change.
Click on Indexes and select fields and create a secondary index. Note: Always try to consist of MANDT because the first subject until you've got a purpose..
Q43. While Printing, 10 Columns Are Printing In First Page And The Next 4 Cols In Next Page, How Do U Resolve This To Accommodate All The 14 Columns In A Single Page?
Ot line length .. Increase line-depend
line-size way width of line
line-depend way no. Of traces according to web page.
Q44. How Many Types Of Tables Are There In Data Dictionary And What They?
Transparent table
CLUSTER Cluster desk
POOL Pooled desk
Q45. What Is The Main Function Module Of Alv Report?
REUSE_ALV_GRID_DISPLAY
Q46. What Is The Difference Between Internal Table With Header Line And Without Header Line?
Internal table with header line is not anything but paintings region name in addition to internal table call is same, while internal table without header line is nothing however work location call in addition to internal desk call is specific.
FOR INTERNAL TABLE WITH HEADER we want not create work vicinity. But no longer really useful due to the fact the user may also get careworn what's paintings place and what is inner desk due to the fact that they both could be having identical names.
Q47. What Is The Transaction Code Sm 31?
SM31 is a new version of the t-code SM30.
SM30 - Call view preservation & perspectives for SAP tables.
SM31 - used for upkeep for SAP tables.
Q48. What Is The Events Table In Alv?
A list of possible activities is populated into an event desk (I_EVENTS) while this table is passed from the characteristic module REUSE_ALV_EVENT_NAMES_GET. The go back table from this function module consists of all of the feasible activities.
Q49. What Is Field Catalog In Sap Alv?
We have the following 3 ways to build a subject catalog.
Automatically thru a Data Dictionary shape.
Manually in ABAP program.
Semi-routinely by way of combining the above approaches.
Declare an inner table of type SLIS_T_FIELDCAT_ALV.
Call characteristic module REUSE_ALV_FIELDCATALOG_MERGE.
Q50. In Alv's How Would You Get Default Values In The Selection Screen?
Create a variant within the ALV Report with anything columns you would really like to look and set sort criteria and column widths and save as a default variation.
You could get the default variant by way of calling FM REUSE_ALV_VARIANT_DEFAULT_GET

