YouTube Icon

Interview Questions.

Top 100+ Sap Abap Alv Reports Interview Questions And Answers - Jun 01, 2020

fluid

Top 100+ Sap Abap Alv Reports Interview Questions And Answers

Question 1. What Is Alv?

Answer :

ALV stands for ABAP List Viewer. ALV offers us a trendy List format and person interface to all our ABAP reports. ALV is created by using a set of wellknown characteristic modules supplied with the aid of SAP.

Question 2. What Are The Uses Of Alv Reports?

Answer :

Sorting of facts
Filtering of records
Totals and Sub-totals
Download the report output to Excel/HTML
Changing the order of the columns in the document
Hide the undesirable columns from the document
SAP CRM Interview Questions
Question 3. What Is Field Catalog In Sap Alv?

Answer :

We have the subsequent 3 methods to construct a discipline catalog.
Automatically via a Data Dictionary shape. 
Manually in ABAP program. 
Semi-automatically with the aid of combining the above two strategies.
Declare an inner desk of kind SLIS_T_FIELDCAT_ALV.
Call characteristic module REUSE_ALV_FIELDCATALOG_MERGE.
Question 4. What Is Slis In Alv And Standard Type Tables Of It?

Answer :

SLIS is the sort library for ALV grid.

If you may use the ALV you have to add 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.
SAP CRM Tutorial
Question 5. How Do You Define Default Variant For Alv?

Answer :

he consumer can programmatically set the preliminary (default) variation for list display.

The default version can be located the use of the function module 'REUSE_ALV_VARIANT_DEFAULT_GET'.

SAP BI Interview Questions
Question 6. What Is The Events Table In Alv?

Answer :

A listing of possible events is populated into an event table (I_EVENTS) while this table is handed from the characteristic module REUSE_ALV_EVENT_NAMES_GET. The return table from this characteristic module includes all the possible events.

Question 7. What Are Layout Parameters Options Of Alv?

Answer :

Display options:

Exceptions
Totals
Interaction
Detail display screen
Display versions (handiest for hierarchical-sequential lists)
Color
Other
SAP BI Tutorial SAP MM Interview Questions
Question eight. What Is Sort Internal Table Options In Alv?

Answer :

This internal table has the subsequent fields:

Sops:  Sort collection.

Fieldname:  Internal output table field call.

Tab name : Only applicable for hierarchical-sequential lists. Name of the inner output table.

Up: 'X' = kind in ascending order.

Down: 'X' = sort in descending order.

Sub tot : 'X' = subtotal at group value exchange.

Group: '* ' = new page at organization price alternate ,'UL' = underline at organization cost change.

Question nine. What Is The Main Function Module Of Alv Report?

Answer :

REUSE_ALV_GRID_DISPLAY

SAP BASIS Interview Questions
Question 10. What Are The Export Parameters Of Alv Reports Function Modules?

Answer :

E_EXIT_CAUSED_BY_CALLER: Delete list in CALLBACK_USER_COMMAND

ES_EXIT_CAUSED_BY_USER: How the user left the list Tables       

T_OUTTAB: Table with statistics to be displayed ---obligatory

SAP MM Tutorial
Question 11. What Is A Report?

Answer :

There are 2 sort of reports:

Interactive record
Classic reviews
In traditional reviews, we will see the output in unmarried list where as in interactive reports we are able to see the output in multiple lists.

SAP ABAP Web Dynpro Interview Questions
Question 12. What Are Classical Reports?

Answer :

These are the maximum simple reviews. Programmers research this one first. It is simply an output of facts using the Write assertion inside a loop.

Classical reviews are normal reviews. These reports aren't having any sub reviews. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports:

INTIALIZATION: This event triggers earlier than selection display screen display.

AT-SELECTION-SCREEN: This event triggers after processing consumer enter nevertheless choice display screen is in lively mode.

START OF SELECTION: Start of choice display triggers after processing choice display.

END-OF-SELECTION: It is for Logical Database Reporting.

SAP CRM Interview Questions
Question 13. What Are The Interactive Reports?

Answer :

The person can Interact with the report. We may have a drill down into the report information.

We may have a fundamental listing (range 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 declaration holds the facts to be displayed within the secondary listing.

Sy-lisel : consists of statistics of the selected line.

Sy-lsind : consists of the level of document (from 0 to 21)

Interactive Report Events:

AT LINE-SELECTION : This Event triggers whilst we double click on a line on the list, while the event is precipitated a brand new sub listing is going to be generated. Under this event what ever the statements that are been go back could be displayed on newly generated sub list.

AT PFn: For predefined function keys...

AT USER-COMMAND : It presents consumer capabilities keys.

TOP-OF-PAGE DURING LINE-SELECTION : Top of web page occasion for secondary list.

SAP BASIS Tutorial
Question 14. How Many Types Of Tables Are There In Data Dictionary And What They?

Answer :

Transparent desk
CLUSTER Cluster table
POOL Pooled table
Question 15. What Are Pricing Tables?

Answer :

Pricing Tables starts offevolved with A* like A001, A002, A900 like that.

KONH – Condition Header
KONP – Condition Detail
SAP Workflow Interview Questions
Question 16. What Is A Table Maintenance Generator?

Answer :

To allow customers to keep table using SM30 transaction you use Table Maintenance generator.

SAP ABAP Web Dynpro Tutorial
Question 17. What Is The Difference Between Client Dependent And Independent Tables?

Answer :

If you've got MANDT as the first discipline that is Client Dependant desk in any other case it isn't. Usually most of the tables are consumer based. Only few like RFC Connections desk (RFCDES), Batch Jobs (TBTCO and TBTCP) are not patron dependant.

Sap Abap Hr Interview Questions
Question 18. What Is The Difference Between At Selection Screen And At Selection Screen Output?

Answer :

AT SELECTION-SCREEN OUTPUT is like Process Before Output Event. This would get prompted before screen is displayed. This can be used to make fields invisible/visible primarily based on choice.

AT SELECTION-SCREEN: This would be triggered if you hit some thing (Enter, Drop-Down, Help, Execute) after the choice display screen is displayed.

SAP BI Interview Questions
Question 19. What Is The Difference Between Clear, Refresh?

Answer :

CLEAR: It clears any field, structure or Header line of internal desk.

REFRESH: Deletes all entries of inner desk.

Question 20. In Alv's How Would You Get Default Values In The Selection Screen?

Answer :

Create a version inside the ALV Report with anything columns you would love to peer and set sort criteria and column widths and store as a default variant.

You may want to get the default variation by way of calling FM REUSE_ALV_VARIANT_DEFAULT_GET

SAP ABAP Dictionary Interview Questions
Question 21. What Are The Steps To Create Custom Table?

Answer :

Create all of the Domains and Data elements as needed the usage of Txn SE11.
Start creating the desk the usage of Tcode SE11.
Maintain Delivery Class (A-Application Table, C-Customizing, and many others)
Enter all of the fields (MANDT must be the primary field) and suitable facts elements or Built in Types for every area.
Make positive you pick the Primary Key for this desk.
Maintain the Technical Settings (Data magnificence, Size, Buffering info)
Create Secondary indexes as wished
Activate the Table
Question 22. How To Set Hotspot In Alv Reports For A Field?

Answer :

In the Field Catalog table, you place the HOTSPOT assets of the sphere to X.

Question 23. What Is Use Of Reuse_alv_fieldcatalog_merge?

Answer :

Using this function module, you may get the Field catalog for a given Internal table or DD Structure. Once you get the Field catalog, you can exchange the residences of every field.

SAP ABAP Enhancement Interview Questions
Question 24. What Is Significance Of Hide?

Answer :

In Interactive reviews, HIDE declaration shops the fee of that field for that line. If the user locations the cursor on a line and click on something those values are mechanically populated to that hidden fields.

SAP MM Interview Questions
Question 25. What Is The Difference Between Select Single And Select Up To One Row?

Answer :

SELECT SINGLE may be used if you understand the full key to pick out a record. If you do now not have the overall Key to choose and you're interested by one single row, you could use SELECT UPTO 1 ROWS. If you operate a SELECT SINGLE with out a complete key, you will get a caution message in Extended Program checks.

If you've got the entire Key use SELECT SINGLE

If you do no longer have the total Key to select and you're inquisitive about one single row, you may use SELECT UPTO 1 ROWS..

Question 26. What Is The Secondary Index?

Answer :

There is an Index created through default for the Primary Key of the desk and that is called Primary Index. If you create, another index that is known as Secondary Index for that desk. Secondary Indexes are created to improve the overall performance of SELECT statements.

SAP ABAP Module Pool Interview Questions
Question 27. How To Create Secondary Index?

Answer :

Using SE11, Enter the table name and click on on Change.

Click on Indexes and select fields and create a secondary index. Note: Always try and consist of MANDT as the first area unless you have got a motive..

SAP BASIS Interview Questions
Question 28. How Do You Modify A Table?

Answer :

You can alter a record the usage of MODIFY announcement or UPDATE Statement.

Question 29. What Is An Abap Memory And Sap Memory And How To Use Them?

Answer :

ABAP reminiscence is a reminiscence area that all ABAP programs within the same internal session can get admission to using the EXPORT and IMPORT statements.

SAP memory is a memory location to which all predominant sessions within a SAPgui have get entry to. You can use SAP memory both to skip information from one application to every other within a consultation, or to pass records from one session to every other. Application packages that use SAP memory have to accomplish that using SPA/GPA parameters (additionally referred to as SET/GET parameters).

SAP ABAP Report Developer Interview Questions
Question 30. When The Top-of-web page Event Does Get Triggered?

Answer :

TOP-OF-PAGE event will be prompted when the primary ULINE, WRITE or SKIP declaration happens in a program.

Question 31. What Is The Difference Between Skip And Reserve?

Answer :

SKIP affords empty area between traces, even as RESERVE executes a web page spoil at the modern-day page if the wide variety of traces among modern line and the page footer is less than the variety laid out in RESERVE announcement.

Question 32. What Is The Difference Between Skip And New-line?

Answer :

SKIP generates a clean line, even as the NEW-LINE reasons the manage to transport to next line.

SAP ABAP Data Dictionary Interview Questions
Question 33. Can We Set Page Headers To Details Lists?

Answer :

Yes. Use TOP-OF-PAGE DURING LINE-SELECTION event.

SAP ABAP Web Dynpro Interview Questions
Question 34. What Are Oss Notes?

Answer :

SAP offers assist inside the shape of Notes additionally and this is called OSS. Can test the link Sree provided.

Just for an instance if you face any blunders for your device. Then there is blunders wide variety related to the mistake. Then you may search for the OSS now not for the mistake range, and the observe will provide you with viable solution to your trouble.

Question 35. What Is The Command To Be Used To Transfer The Data From One Internal Table To Another Internal?

Answer :

Move itab1 to itab2

We can use APPEND for copying statistics from one ITAB to every other ITAB with the aid of keeping in a loop. But it isn't always efficient. Instead we are able to use as follows:

ITAB1[]=ITAB2[].

Question 36. How Can Validate Input Values In Selection Screen And Which Event Was Fired?

Answer :

At choice-display screen is an occasion, which is used to validate the selection display screen enter fields, if you want to validate the specific input discipline we use at selection-display on occasion.

AT SELECTION-SCREEN ON event is used to validate input.

SAP Workflow Interview Questions
Question 37. What Is The Difference Between Data Element And Domain?

Answer :

Data element is the gathering of domain with quick description, while domain is series of datatype and length.

Domain incorporates only technical attributes (information type , length) where as Data Element incorporates Technical characteristic in addition to Semantic attributes(Field description).

Question 38. What Is The Difference Between Internal Table With Header Line And Without Header Line?

Answer :

Internal table with header line is nothing however paintings place name as well as inner desk call is same, whereas inner desk with out header line is nothing however paintings area call as well as inner table call is one-of-a-kind.

FOR INTERNAL TABLE WITH HEADER we need now not create paintings vicinity. But now not really helpful because the user may additionally get stressed what's work place and what's inner table for the reason that they both may be having same names.

Question 39. Which Is The First Event That Is Triggered In A Report?

Answer :

Load of program is the primary triggering occasion inside the classical reports, where as abaper point of view initialization is the primary triggering event.

LOAD-OF-PROGRAM which gets brought about internally within the SAP gadget, then the occasion INITIALIZATION gets cause.

Question forty. What Is Binary Search?

Answer :

Binary search is a searching algorithm in which the whole statistics in spitted into two components and looking is started from one of the part. In regular seek facts is searched linearly from top to backside which is less green than binary seek.

Binary search is used to get the more data from internal table in place of linear seek ,and binary seek is the quicker and green .

Sap Abap Hr Interview Questions
Question forty one. 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?

Answer :

ot line length .. Growth line-count number
line-size way width of line
line-depend manner no. Of lines consistent with page.
Question 42. What Events Are Mandatory In Reports?

Answer :

Report dont want any occasion to execute the output.It we we positioned start-of-choice there is no compulsory to apply quit-of-selection. End-of-selection is used whilst we need to execute some output even when some exception takes place to bypass begin-of-choice.

There is no mandatory occasion in the file application. However, if we do not explicitly write any occasion, machine implicitly starts offevolved with start of selection event.In case of database choice, it is a great practice of use cease-of-choice event.

SAP ABAP Dictionary Interview Questions
Question 43. What Is The Transaction Code Sm 31?

Answer :

SM31 is a new version of the t-code SM30.

SM30 - Call view renovation & views for SAP tables.

SM31 - used for upkeep for SAP tables.

Question forty four. What Are Text Elements?

Answer :

Text factors makes program less difficult to maintain program texts in distinctive languages. These are used for maintaining list headers, choice texts in applications.

Question forty five. Explain Check Table And Value Table?

Answer :

Check table works at desk degree and fee desk works at area level.
Check desk is nothing however master table that u will create with legitimate set of values.
Value table it provides the list of values and it'll automatically proposed as a take a look at table at the same time as growing overseas key dating.
Question 46. How Many Types Of Standard Internal Tables?

Answer :

STANDARD TABLE: The secret is, through default, set to NON-UNIQUE. You won't use the UNIQUE addition.

SORTED TABLE: Unlike general tables, looked after table don't have any default placing for the distinctiveness characteristic. If you do now not specify either UNIQUE or NON-UNIQUE, the device defines a established desk kind, in which forte is beside the point. You can use familiar types to specify the type of commonplace subroutine parameters.

HASHED TABLE: Hashed tables have no default setting. You need to use the UNIQUE addition with hashed tables. You might not use NON-UNIQUE.

Question 47. What Is Refreshing In Internal Table?

Answer :

'Refresh' is the key-word which clears the contents of an inner table body.

Question forty eight. What Is The Difference Between Collect And Sum?

Answer :

COLLECT lets in you to create particular or summarized datasets. The gadget first attempts to discover a table access similar to the table key. The key values are taken both from the header line of the inner table itab, or from the explicitly-targeted work location.

If the gadget unearths an access, the numeric fields that are not part of the desk key (see ABAP number kinds) are introduced to the sum general of the present entries. If it does not discover an access, the device creates a new entry instead.

Question 49. What Are The Ways Of Creating Tables?

Answer :

There are two methods to create table

Top-down technique
Bottom-up technique
Question 50. What Is The Significance Of A Stacked List?

Answer :

The secondary listing is likewise referred to as the stacked listing and it will be shown on the entire display screen if we don’t write its coordinates of the command window.

Question 51. When It’s The Right Time To Utilize The Command Get Cursor In Interactive Lists?

Answer :

The command GET CURSOR could be utilized when the hidden records isn't enough for tracing the selected line.

Question fifty two. How Do We Describe Start –of-choice And End-of-selection?

Answer :

The start and the finish of the primary processing logic, which is default for every ABAP/four software; the statements from START-OF-SELECTION to END-OF-SELECTION are completed automatically, there is no requirement for having END-OF-SELECTION. Every procedural declaration in ABAP packages are established through default at the START-OF-SELECTION.




CFG