Overview
This prompt aims to guide developers in creating an ABAP report with specific functionalities. Programmers and ABAP developers will benefit from the structured requirements and implementation details provided.
Prompt Overview
Purpose: This report aims to retrieve and display location data based on user-selected parameters in an editable ALV grid.
Audience: The intended users are ABAP developers and SAP professionals looking to implement dynamic selection screens and data handling.
Distinctive Feature: The report features dynamic checkbox functionality that controls the visibility of related selection parameters.
Outcome: Users can export location data to Excel and manipulate it directly within the ALV grid interface.
Quick Specs
- Media: Text
- Use case: Generation
- Industry: Business Communications, Data & Analysis, Development Tools & DevOps
- Techniques: Plan-Then-Solve, Role/Persona Prompting, Structured Output
- Models: Claude 3.5 Sonnet, Gemini 2.0 Flash, GPT-4o, Llama 3.1 70B
- Estimated time: 5-10 minutes
- Skill level: Beginner
Variables to Fill
No inputs required — just copy and use the prompt.
Example Variables Block
No example values needed for this prompt.
The Prompt
Create an ABAP report implementing the following requirements:
**Selection Screen:**
– Include two initially unchecked, disabled checkboxes:
– “Get Locations from Plant”
– “Get Locations from Business Partner”.
– When a checkbox is checked, dynamically display the related selection parameters for that source; use placeholder fields for these parameters.
– Allow the user to select either one or both checkboxes.
**Data Retrieval:**
– Upon user executing (F8), perform mock SELECT statements retrieving data based on the selected parameters.
– Map the retrieved data into the structure `/lvx/uf_s_locations`.
**ALV Display:**
– Show the retrieved data in an editable ALV grid, enabling inline editing.
– Add a custom toolbar above the ALV grid containing two buttons:
– “Save to Local PC” (active):
– When clicked, export the current ALV data to an Excel file on the local PC using the existing class `/lvx/cl_uf_handler` and the provided Excel generation code snippet.
– The exported file name should be prefixed with “Locations_” followed by the current date and time.
– “Send to API” (disabled for now).
**Implementation Details:**
– Manage UI logic for showing and hiding parameters in the `AT SELECTION-SCREEN OUTPUT` event.
– Handle ALV button clicks through `CL_GUI_ALV_GRID` or `SALV` with `PF-STATUS`.
– Ensure code adheres to ABAP best practices and is well-structured and readable.
**Steps:**
1. Define the selection screen with the two checkboxes and placeholder parameter blocks.
2. Use `AT SELECTION-SCREEN OUTPUT` to enable/disable checkboxes and dynamically show/hide parameters.
3. In `START-OF-SELECTION`, implement mock SELECT statements based on selected parameters.
4. Map retrieved data into `/lvx/uf_s_locations`.
5. Display data in an editable ALV grid with inline editing enabled.
6. Create a custom toolbar with “Save to Local PC” and “Send to API” buttons.
7. Implement “Save to Local PC” button functionality using `/lvx/cl_uf_handler` to export the Excel file with a timestamped filename.
8. Disable “Send to API” button functionality.
**Output Format:**
Provide the complete ABAP source code for the report fulfilling all requirements, including comments for clarity, especially for:
– UI handling
– Data mapping
– ALV setup
The code should be ready to run in an ABAP environment.
Screenshot Examples
How to Use This Prompt
- Copy the prompt provided above.
- Open your ABAP development environment.
- Create a new ABAP report program.
- Paste the prompt into your program as a comment.
- Follow the steps outlined in the prompt to implement the report.
- Test the report in your ABAP environment for functionality.
Tips for Best Results
- Define Selection Screen: Create two checkboxes for user input, initially unchecked and disabled.
- Dynamic Parameter Display: Use `AT SELECTION-SCREEN OUTPUT` to show or hide parameters based on checkbox selections.
- ALV Grid Setup: Implement an editable ALV grid for displaying retrieved data, allowing inline editing.
- Export Functionality: Add a button to export ALV data to Excel with a timestamped filename using the specified class.
FAQ
- What is the purpose of the selection screen in ABAP?
The selection screen allows users to input parameters and options before executing the report. - How do you handle checkbox events in ABAP?
Use the AT SELECTION-SCREEN OUTPUT event to manage checkbox states and display related parameters. - What does ALV stand for in ABAP?
ALV stands for ABAP List Viewer, used for displaying data in a user-friendly format. - How can you export data to Excel in ABAP?
Use the class /lvx/cl_uf_handler to generate and export the ALV data as an Excel file.
Compliance and Best Practices
- Best Practice: Review AI output for accuracy and relevance before use.
- Privacy: Avoid sharing personal, financial, or confidential data in prompts.
- Platform Policy: Your use of AI tools must comply with their terms and your local laws.
Revision History
- Version 1.0 (February 2026): Initial release.
