SAP ABAP ALV REPORTS Interview Questions and Answers
Q1. What Is Alv?
Ans: ALV (ABAP LIST VIEWER) Sap gives a set ofALV (ABAP LIST VIEWER) capability modules, which can be placed into utilization to decorate the result of a report. This arrangement of ALV capabilities is utilized to upgrade the lucidness and usefulness of any report yield.
Or then again
ALV represents ABAP List Viewer. ALV gives us a standard List configuration and UI to all our ABAP reports. ALV is made by a bunch of standard capability modules given by SAP.
Q2. What Are The Uses Of Alv Reports?
Ans: Sorting of records
Separating of records
Aggregates and Sub-sums
Download the report result to Excel/HTML
Changing the request for the sections in the report
Conceal the undesirable sections from the report
Q3. What Is Field Catalog In Sap Alv?
Ans: We have the accompanying three methods for building a field inventory.
Naturally through a Data Dictionary structure.
Physically in ABAP program.
Semi-naturally by joining the over two methodology.
Pronounce an inside table of type SLIS_T_FIELDCAT_ALV.
Call capability module REUSE_ALV_FIELDCATALOG_MERGE.
Q4. What Is Slis In Alv And Standard Type Tables Of It?
Ans: SLIS is the sort library for ALV matrix.
On the off chance that you'll utilize the ALV you need to add TYPE-POOLS : SLIS. order toward the start of your code.
SLIS_LAYOUT_ALV,
SLIS_T_FIELDCAT_ALV
SLIS_T_LISTHEADER,
SLIS_T_EVENT,
SLIS_SELFIELD.
Q5. How Do You Define Default Variant For Alv?
Ans: The client can automatically set the underlying (default) variation for list show.
The default variation can be tracked down utilizing the capability module 'REUSE_ALV_VARIANT_DEFAULT_GET'.
Q6. What Is The Events Table In Alv?
Ans: A rundown of potential occasions is populated into an occasion table (I_EVENTS) when this table is passed from the capability module REUSE_ALV_EVENT_NAMES_GET. The return table from this capability module contains every one of the potential occasions.
Q7. What Are Layout Parameters Options Of Alv?
Ans: Display choices:
Special cases
Aggregates
Connection
Detail screen
Show variations (just for various leveled consecutive records)
Variety
Other
Q8. What Is Sort Internal Table Options In Alv?
Ans: This inward table has the accompanying fields:
Sops: Sort succession.
Fieldname: Internal result table field name.
Tab name : Only significant for progressive consecutive records. Name of the inside yield table.
Up: 'X' = sort in rising request.
Down: 'X' = sort in sliding request.
Sub toddler : 'X' = subtotal at bunch esteem change.
Bunch: '* ' = new page at bunch esteem change ,'UL' = underline at bunch esteem change.
Q9. What Is The Main Function Module Of Alv Report?
Ans: REUSE_ALV_GRID_DISPLAY
Q10. What Are The Export Parameters Of Alv Reports Function Modules?
Ans: E_EXIT_CAUSED_BY_CALLER: Delete list in CALLBACK_USER_COMMAND
ES_EXIT_CAUSED_BY_USER: How the client left the rundown Tables
T_OUTTAB: Table with information to be shown - - - required
Q11. What Is A Report?
Ans: There are 2 sort of reports:
Intelligent report
Exemplary reports
In exemplary reports, we can see the result in single rundown where as in intelligent reports we can see the result in numerous rundowns.
Q12. What Are Classical Reports?
Ans: These are the most straightforward reports. Software engineers realize this one first. It is only a result of information utilizing the Write proclamation inside a circle.
Traditional reports are ordinary reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.
Occasions In Classical Reports:
INTIALIZATION: This occasion triggers before choice screen show.
AT-SELECTION-SCREEN: This occasion triggers in the wake of handling client input still determination screen is in dynamic mode.
Beginning OF SELECTION: Start of determination screen triggers in the wake of handling choice screen.
END-OF-SELECTION: It is for Logical Database Reporting.
Q13. What Are The Interactive Reports?
Ans: The client can Interact with the report. We can have a drill down into the report information.
We can have a fundamental rundown (number beginnings from 0) and 20 optional records (1 to 21).
Occasions related with Interactive Reports are:
AT LINE-SELECTION
AT USER-COMMAND
AT PF<key>
TOP-OF-PAGE DURING LINE-SELECTION.
Conceal proclamation holds the information to be shown in the optional rundown.
sy-lisel : contains information of the chose line.
sy-lsind : contains the degree of report (from 0 to 21)
Intuitive Report Events:
AT LINE-SELECTION : This Event triggers when we double tap a line on the rundown, when the occasion is set off another sub list will be produced. Under this occasion what ever the explanations that are been return will be shown on recently created sub list.
AT PFn: For predefined capability keys...
AT USER-COMMAND : It gives client capabilities keys.
TOP-OF-PAGE DURING LINE-SELECTION : Top of page occasion for optional rundown.
HubSpot Video
Q14. What number of Types Of Tables Are There In Data Dictionary And What They?
Ans:
Straightforward table
Bunch Cluster table
POOL Pooled table
Q15. What Are Pricing Tables?
Ans: Pricing Tables begins with A* like A001, A002, that's what a900 like.
KONH - Condition Header
KONP - Condition Detail
Q16. What Is A Table Maintenance Generator?
Ans: To permit clients to keep up with table utilizing SM30 exchange you utilize Table Maintenance generator.
Q17. What Is The Difference Between Client Dependent And Independent Tables?
Ans: If you have MANDT as the principal field that is Client Dependant table in any case it isn't. Typically the greater part of the tables are client subordinate. Just hardly any like RFC Connections table (RFCDES), Batch Jobs (TBTCO and TBTCP) are not client dependant.
Q18. What Is The Difference Between At Selection Screen And At Selection Screen Output?
Ans: AT SELECTION-SCREEN OUTPUT resembles Process Before Output Event. This would get set off before screen is shown. This can be utilized to make fields undetectable/noticeable in view of choice.
AT SELECTION-SCREEN: This would be set off on the off chance that you hit anything (Enter, Drop-Down, Help, Execute) after the determination screen is shown.
Q19. What Is The Difference Between Clear, Refresh?
Ans: CLEAR: It clears any field, construction or Header line of inner table.
Invigorate: Deletes all passages of inward table.
Q20. In Alv's How Would You Get Default Values In The Selection Screen?
Ans: Create a variation in the ALV Report with anything segments you might want to see and set sort standards and section widths and save as a default variation.
You could get the default variation by calling FM REUSE_ALV_VARIANT_DEFAULT_GET
Q21. What Are The Steps To Create Custom Table?
Ans: Create every one of the Domains and Data components depending on the situation utilizing Txn SE11.
Begin making the table utilizing Tcode SE11.
Keep up with Delivery Class (A-Application Table, C-Customizing, and so on)
Enter every one of the fields (MANDT should be the principal field) and suitable information components or Built in Types for each field.
Ensure you select the Primary Key for this table.
Keep up with the Technical Settings (Data class, Size, Buffering information)
Make Secondary lists depending on the situation
Enact the Table
Q22. How To Set Hotspot In Alv Reports For A Field?
Ans: In the Field Catalog table, you set the HOTSPOT property of the field to X.
Q23. What Is Use Of Reuse_alv_fieldcatalog_merge?
Ans: Using this capability module, you can get the Field index for a given Internal table or DD Structure. When you get the Field list, you could change the properties of each field.
Q24. What Is Significance Of Hide?
Ans: In Interactive reports, HIDE explanation stores the worth of that field for that line. In the event that the client puts the cursor on a line and snap on something those values are consequently populated to that secret fields.
Q25. What Is The Difference Between Select Single And Select Up To One Row?
Ans: SELECT SINGLE can be utilized in the event that you know the full key to choose a record. On the off chance that you don't have the full Key to choose and you are keen on one single line, you could utilize SELECT UPTO 1 ROWS. In the event that you utilize a SELECT SINGLE without a full key, you would receive an admonition message in Extended Program checks.
Assuming you have the full Key utilize SELECT SINGLE
On the off chance that you don't have the full Key to choose and you are keen on one single line, you could utilize SELECT UPTO 1 ROWS..
Q26. What Is The Secondary Index?
Ans: There is an Index made of course for the Primary Key of the table and that is called Primary Index. Assuming you make, whatever other list that is called Secondary Index for that table. Auxiliary Indexes are made to work on the presentation of SELECT explanations.
Q27. How To Create Secondary Index?
Ans: Using SE11, Enter the table name and snap on Change.
Click on Indexes and select fields and make an optional list. Note: Always attempt to incorporate MANDT as the principal field except if you have an explanation..
Q28. How Do You Modify A Table?
Ans: You can change a record utilizing MODIFY explanation or UPDATE Statement.
Q29. What Is An Abap Memory And Sap Memory And How To Use Them?
Ans: ABAP memory is a memory region that all ABAP programs inside a similar interior meeting can get to utilizing the EXPORT and IMPORT proclamations.
SAP memory is a memory region to which all principal meetings inside a SAPgui approach. You can utilize SAP memory either to pass information starting with one program then onto the next inside a meeting, or to pass information starting with one meeting then onto the next. Application programs that utilization SAP memory should do so utilizing SPA/GPA boundaries (otherwise called SET/GET boundaries).
Q30. When The Top-of-page Event Does Get Triggered?
Ans: TOP-OF-PAGE occasion will be set off when the principal ULINE, WRITE or SKIP explanation happens in a program.
Q31. What Is The Difference Between Skip And Reserve?
Ans: SKIP gives void space between lines, while RESERVE executes a page break on the ongoing page in the event that the quantity of lines between current line and the page footer is not exactly the number determined in RESERVE proclamation.
Q32. What Is The Difference Between Skip And New-line?
Ans: SKIP produces a clear line, while the NEW-LINE makes the control move to next line.
Q33. Might We at any point Set Page Headers To Details Lists?
Ans: Yes. Utilize TOP-OF-PAGE DURING LINE-SELECTION occasion.
Q34. What Are Oss Notes?
Ans: SAP offers help as Notes likewise and this is called OSS. Can check the connection Sree gave.
Only for a model in the event that you face any blunder in your framework. Then there is mistake number related with the blunder. Then you can look for the OSS not for the mistake number, and the note will give you conceivable answer for your concern.
Q35. What Is The Command To Be Used To Transfer The Data From One Internal Table To Another Internal?
Ans: Move itab1 to itab2
We can utilize APPEND for duplicating information starting with one ITAB then onto the next ITAB by keeping in a circle. Be that as it may, it isn't productive. Rather we can use as follows:
ITAB1[]=ITAB2[].
Q36. How Could Validate Input Values In Selection Screen And Which Event Was Fired?
Ans: At choice screen is an occasion, which is utilized to approve the determination screen input fields, if you need to approve the specific info field we use at choice screen on occasion.
AT SELECTION-SCREEN ON occasion is utilized to approve input.
Q37. What Is The Difference Between Data Element And Domain?
Ans: Data component is the assortment of area with short portrayal, while space is assortment of datatype and length.
Space contains just specialized credits (information type , size) where as Data Element contains Technical trait along with Semantic attributes(Field depiction).
Q38. What Is The Difference Between Internal Table With Header Line And Without Header Line?
Ans: Internal table with header line is only workspace name as well as inner table name is same, while inward table without header line is only workspace name as well as inside table name is unique.
FOR INTERNAL TABLE WITH HEADER we want not make workspace. In any case, not fitting in light of the fact that the client might get confounded what is workspace and what is inward table since the two of them will have same names.
Q39. Which Is The First Event That Is Triggered In A Report?
Ans: Load of program is the first setting off occasion in the traditional reports, where as abaper perspective introduction is the first setting off occasion.
Heap OF-PROGRAM which gets set off inside in the SAP framework, then, at that point, the occasion INITIALIZATION gets trigger.
Q40. What Is Binary Search?
Ans: Binary pursuit is a looking through calculation wherein the entire information in spitted into two sections and looking is begun from one of the part. In ordinary pursuit information is looked directly through and through which is less proficient than paired search.
Paired search is utilized to get the more information from inward table rather than direct hunt ,and parallel inquiry is the quicker and effective .
Q41. 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?
Ans: ot line size .. increment line-count
line-size implies width of line
line-count implies no. of lines per page.
Q42. What Events Are Mandatory In Reports?
Ans: Report dont need any occasion to execute the output.It we put beginning of-determination there is no necessary to utilize end-of-choice. End-of-determination is utilized when we need to execute some result in any event, when some special case happens to skip beginning of-choice.
There is no compulsory occasion in the report program. be that as it may, in the event that we unequivocally compose no occasion, framework verifiably begins with beginning of determination event.In instance of data set choice, it is a decent act of purpose end-of-choice occasion.
Q43. What Is The Transaction Code Sm 31?
Ans:
SM31 is another variant of the t-code SM30.
SM30 - Call view upkeep and perspectives for SAP tables.
SM31 - utilized for support for SAP tables.
Q44. What Are Text Elements?
Ans: Text components makes program simpler to keep up with program texts in various dialects. These are utilized for keeping up with list headers, choice texts in programs.
Q45. Make sense of Check Table And Value Table?
Ans: Check table works at table level and worth table works at area level.
Check table is only expert table that u will make with substantial arrangement of values.
Esteem table it gives the rundown of values and it will naturally proposed as a really look at table while making unfamiliar key relationship.
Q46. What number of Types Of Standard Internal Tables?
Ans:
STANDARD TABLE: The key is, as a matter of course, set to NON-UNIQUE. You may not utilize the UNIQUE expansion.
Arranged TABLE: Unlike standard tables, arranged table have no default setting for the uniqueness property. On the off chance that you don't indicate either UNIQUE or NON-UNIQUE, the framework characterizes a conventional table sort, where uniqueness is unessential. You can utilize nonexclusive sorts to determine the kind of conventional subroutine boundaries.
HASHED TABLE: Hashed tables have no default setting. You should utilize the UNIQUE expansion with hashed tables. You may not utilize NON-UNIQUE.
Q47. What Is Refreshing In Internal Table?
Ans: 'Revive' is the catchphrase which gets the items free from an inner table body.
Q48. What Is The Difference Between Collect And Sum?
Ans: COLLECT permits you to make exceptional or summed up datasets. The framework first attempts to find a table section relating to the table key. The key qualities are taken either from the header line of the inward table itab, or from the unequivocally indicated workspace.
Assuming the framework finds a section, the numeric fields that are not piece of the table key (see ABAP number sorts) are added to the aggregate of the current passages. In the event that it doesn't find a passage, the framework makes another section all things considered.
Q49. What Are The Ways Of Creating Tables?
Ans: There are two methods for making table
Hierarchical methodology
Granular perspective
Q50. What Is The Significance Of A Stacked List?
Ans: The auxiliary rundown is additionally called the stacked rundown and it will be displayed on the whole screen on the off chance that we don't compose its directions of the order window.
Q51. When It's The Right Time To Utilize The Command Get Cursor In Interactive Lists?
Ans: The order GET CURSOR will be used when the secret data isn't enough for following the chose line.
Q52. How Do We Describe Start - of-choice And End-of-determination?
Ans: The beginning and the completion of the principal handling rationale, which is default for each ABAP/4 application; the assertions from START-OF-SELECTION to END-OF-SELECTION are executed naturally, there is no necessity for having END-OF-SELECTION. Each procedural assertion in ABAP applications are reliant naturally on the START-OF-SELECTION.
