What Is Alv?
ALV (ABAP LIST VIEWER) Sap provides a set ofALV (ABAP LIST VIEWER) function modules, which can be put into use to embellish the output of a report. This set of ALV functions is used to enhance the readability and functionality of any report output.
Or
ALV stands for ABAP List Viewer. ALV gives us a standard List format and user interface to all our ABAP reports. ALV is created by a set of standard function modules provided by SAP.
What Are The Uses Of Alv Reports?
Sorting of records
Filtering of records
Totals and Sub-totals
Download the report output to Excel/HTML
Changing the order of the columns in the report
Hide the unwanted columns from the report
What Is Field Catalog In Sap Alv?
We have the following three ways to build a field catalog.
Automatically through a Data Dictionary structure.
Manually in ABAP program.
Semi-automatically by combining the above two procedures.
Declare an internal table of type SLIS_T_FIELDCAT_ALV.
Call function module REUSE_ALV_FIELDCATALOG_MERGE.
What Is Slis In Alv And Standard Type Tables Of It?
SLIS is the type library for ALV grid.
If you’ll use the ALV you have to add TYPE-POOLS : SLIS. command at the beginning of your code.
SLIS_LAYOUT_ALV,
SLIS_T_FIELDCAT_ALV
SLIS_T_LISTHEADER,
SLIS_T_EVENT,
SLIS_SELFIELD.
How Do You Define Default Variant For Alv?
The user can programmatically set the initial (default) variant for list display.
The default variant can be found using the function module ‘REUSE_ALV_VARIANT_DEFAULT_GET’.
What Is The Events Table In Alv?
A list of possible events is populated into an event table (I_EVENTS) when this table is passed from the function module REUSE_ALV_EVENT_NAMES_GET. The return table from this function module contains all the possible events.
What Are Layout Parameters Options Of Alv?
Display options:
Exceptions
Totals
Interaction
Detail screen
Display variants (only for hierarchical-sequential lists)
Color
Other
What Is Sort Internal Table Options In Alv?
This internal table has the following fields:
Sops: Sort sequence.
Fieldname: Internal output table field name.
Tab name : Only relevant for hierarchical-sequential lists. Name of the internal output table.
Up: ‘X’ = sort in ascending order.
Down: ‘X’ = sort in descending order.
Sub tot : ‘X’ = subtotal at group value change.
Group: ‘* ‘ = new page at group value change ,’UL’ = underline at group value change.
What Is The Main Function Module Of Alv Report?
REUSE_ALV_GRID_DISPLAY
What Are The Export Parameters Of Alv Reports Function Modules?
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 data to be displayed —mandatory
What Is A Report?
There are 2 type of reports:
Interactive report
Classic reports
In classic reports, we can see the output in single list where as in interactive reports we can see the output in multiple lists.
What Are Classical Reports?
These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.
Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.
Events In Classical Reports:
INTIALIZATION: This event triggers before selection screen display.
AT-SELECTION-SCREEN: This event triggers after processing user input still selection screen is in active mode.
START OF SELECTION: Start of selection screen triggers after processing selection screen.
END-OF-SELECTION: It is for Logical Database Reporting.
What Are The Interactive Reports?
The user can Interact with the report. We can have a drill down into the report data.
We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).
Events associated with Interactive Reports are:
AT LINE-SELECTION
AT USER-COMMAND
AT PF<key>
TOP-OF-PAGE DURING LINE-SELECTION.
HIDE statement holds the data to be displayed in the secondary list.
sy-lisel : contains data of the selected line.
sy-lsind : contains the level of report (from 0 to 21)
Interactive Report Events:
AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sub list is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sub list.
AT PFn: For predefined function keys…
AT USER-COMMAND : It provides user functions keys.
TOP-OF-PAGE DURING LINE-SELECTION : Top of page event for secondary list.
How Many Types Of Tables Are There In Data Dictionary And What They?
Transparent table
CLUSTER Cluster table
POOL Pooled table
What Are Pricing Tables?
Pricing Tables starts with A* like A001, A002, A900 like that.
KONH – Condition Header
KONP – Condition Detail
What Is A Table Maintenance Generator?
To allow users to maintain table using SM30 transaction you use Table Maintenance generator.
What Is The Difference Between Client Dependent And Independent Tables?
If you have MANDT as the first field that is Client Dependant table otherwise it is not. Usually most of the tables are client dependent. Only few like RFC Connections table (RFCDES), Batch Jobs (TBTCO and TBTCP) are not client dependant.
What Is The Difference Between At Selection Screen And At Selection Screen Output?
AT SELECTION-SCREEN OUTPUT is like Process Before Output Event. This would get triggered before screen is displayed. This can be used to make fields invisible/visible based on selection.
AT SELECTION-SCREEN: This would be triggered if you hit anything (Enter, Drop-Down, Help, Execute) after the selection screen is displayed.
What Is The Difference Between Clear, Refresh?
CLEAR: It clears any field, structure or Header line of internal table.
REFRESH: Deletes all entries of internal table.
In Alv's How Would You Get Default Values In The Selection Screen?
Create a variant in the ALV Report with whatever columns you would like to see and set sort criteria and column widths and save as a default variant.
You could get the default variant by calling FM REUSE_ALV_VARIANT_DEFAULT_GET
What Are The Steps To Create Custom Table?
Create all the Domains and Data elements as needed using Txn SE11.
Start creating the table using Tcode SE11.
Maintain Delivery Class (A-Application Table, C-Customizing, etc)
Enter all the fields (MANDT must be the first field) and appropriate data elements or Built in Types for each field.
Make sure you select the Primary Key for this table.
Maintain the Technical Settings (Data class, Size, Buffering info)
Create Secondary indexes as needed
Activate the Table
