SAP Database

ALV Hierarchical List

ALV code for hierarchical sequential list display(single child). List of SAP tables as the parent node with interactive features(as a pop up) and List of fields as the child node with interactive features too(as a pop up).

Download the Program ALV Hierarchical List

Screen shots (more…)

ALV report with drag and drop functionality on its rows.

Download the ALV Program.

Report Output

ALV Programs Explained

ALV (ABAP List Viewer) Programs are very easy to write when you know few basic facts about them. There are many Functions modules provided by SAP to handle different tasks. Just go to SE37 and use *REUSE*ALV* and this would display all the function modules related to ALV. Now to analyze and explain ALV, lets use the simple ALV Grid function module ‘REUSE_ALV_GRID_DISPLAY’ as an example.

Typically, all the ALV Reporting ends up into two different Categories.

• Create Field catalogue
• Create Events to display Top of Page/End of Page
  
• Call the relevant ALV Function Module to display the output.

(more…)

ALV report which displays the contents of the table T006 (as a docking container in the bottom) along with the editable ALV which contains the ALV field catalogue table structure. With the available toolbar options of the editable ALV in the output, user can change the field catalogue as per his requirement. When the user clicks ‘SUBMIT’,the display of the ALV with table T006 gets modified and customised accordingly to the user’s requirement.

Download the program(Editable fieldcatalogue for output in ALV).

ALV code for simple hierarchical sequential list display(single child) List of SAP tables and their characteristics are displayed as the header table ( the parent table) and the list of fields and their characteristics from the item table(child table).

Download the Program(ALV hierarchical list display).

ALV Reports

List of tables - This simple abap program displays the list of abap programs used by a program and lists them in ALV.
List of Dictionary Objects - This program displays the list of Dictionary Objects used by a transaction.

ALV to Display all Transaction Codes.

Here is a sample program of ALV report displaying all the transaction codes in SAP User can click any tcode on ALV and go to the same .The ALV displays first 25 records and on refreshing displays the next set of 25 records and so on.

Download the complete source code from ALV Refresh.

ALV Reporting

- Simple code for creating dropdown lists for columns in ALV grid output.

Download DropDown ALV

ALV pop up giving the list of all the infotypes in the system. The user can select the infotypes . After selection the details of the
selected infotypes are displayed in ALV in the form of a dialog box.

Download the complete program with screenshots.

SAP Utility Programs

Gentran IDoc Data Definition File Generation Tool - Gentran’s mapping tool maps 1 structure to another structure. Typically, 1 structure is an EDI standard which is provided by Sterling Commerce. In this case we assume the other structure to be SAP’s Idoc structure.
1 click abap tool - This is a tool for quickly selecting last objects used for editing purposes. Very useful for developers to quickly access their common objects.
EDI Utilities - Contains Workflow Utilities Differences in SWETYPV entries across environments & Send email to managers of agents who are no longer there. Contains EDI Utilities Send Email when IDoc hasn’t changed status for a period. Update IDOC Status, Analyze EDPAR.
Find PO in IDOC - Find Inbound Idocs for a particular PO number.
IDOC Excel Upload - Changing an Idoc’s status with an Excel upload.

Source : ERPGenie.com