ABAP Assignment - Sales Order Interactive Report
ABAP Assignment - Sales Order Interactive Report
ABAP Assignment - Sales Order Interactive Report
Table of Contents
Functional Design........................................................................................................................................3
Document Information.................................................................................................................................3
Document History........................................................................................................................................3
Change Log.............................................................................................................................................3
Approval/Sign-off......................................................................................................................................3
Overview and Scope....................................................................................................................................4
Functional Description..............................................................................................................................4
Assumptions............................................................................................................................................4
Detailed Functional Requirements...............................................................................................................4
Functional Specification...........................................................................................................................4
Process Flow Diagram.............................................................................................................................5
Extension Layout......................................................................................................................................5
Input and Output......................................................................................................................................5
Required SAP Transactions.................................................................................................................5
Input Parameters..................................................................................................................................5
Method to Retrieve Input Parameters...................................................................................................6
Output Parameters...............................................................................................................................6
Method to Release Output Parameters (Output Type).........................................................................6
Method to Update Existing Run Parameters with Latest Run Information............................................6
Reporting.................................................................................................................................................7
Initial Data Set-Up/Conversion Requirements..........................................................................................7
Existing Sample Program(s)....................................................................................................................8
Process and Operational Considerations.................................................................................................8
Network Integration...............................................................................................................................8
Performance.........................................................................................................................................8
Processing Type...................................................................................................................................8
Re-use Details......................................................................................................................................8
Expected Transaction Volumes............................................................................................................8
Error Handling.......................................................................................................................................8
Security and Authorization....................................................................................................................8
Purge and Archive Considerations.......................................................................................................8
Multi-company, Multi-jurisdiction Considerations..................................................................................8
Other.....................................................................................................................................................8
Change Management Requirements.......................................................................................................8
Testing Requirements..................................................................................................................................9
Key Business Test Conditions.................................................................................................................9
Technical Test Conditions........................................................................................................................9
Testing Considerations/Dependencies ....................................................................................................9
Outstanding Issues......................................................................................................................................9
Appendix......................................................................................................................................................9
Glossary of Terms....................................................................................................................................9
Additional Supporting/Reference Documentation.....................................................................................9
Solution Review Board input........................................................................................................................9
Functional Design
Document Information
Extension Name Sales Order Report
Functional Area RTR
Functional Designer
Developer
Document History
Change Log
Name Change Date Version
Approval/Sign-off
Name Role Date Signature
Functional Description
The purpose of this development is to display a report of Orders created during a time period. This
enables for weekly & monthly reporting on the Ordering activities. However what are not covered under
the purview of this development is the Order changes that happen during the time period.
Provisions for downloading the report to the desktop and interactive features are some of the additional
requirements from the report for ease of reporting and usage.
A custom transaction code, ZORDREP, will be created and linked to an ABAP program
ZCASE0003_Order_Report to display a report of the Sales Orders created during a time period.
Dependencies/Constraints
Assumptions
Source
The source of Order data comes from different SAP tables. The Output will contain data pertaining to
multiple Order lines.
File specification:
None.
SAP Process
The user logs on the SAP ECC 6.0 and calls the custom transaction ZORDRPT, which prompts the user
to enter restricting values for the report output to be displayed.
This program will have the following fields in the selection screen:
• Sales Order Number (VBAK-VBELN) - Select Option.
• Sales Order Type (VBAK-AUART) – Select Option.
• Creation Date (VBAK-ERDAT) - Select Option. By default, the program should be run for the
current Month ie between the starting and ending date of the current month when the program is
run.
Fields entered in selection screen are validated and any errors are reported and processing stopped.
Fields from the following tables need to be displayed in the primary report in the following order:
1) Order Number (VBAK-VBELN),
Modified: 1/5/2011 7:13 a1/p1 4 Last modified by: Sachin Jain –
©2010 A2Z. All Rights Reserved. ABAP
Functional Design Form 49001048.doc Version: 1.0
Option to SINGLE CLICK on Order Number field to display the corresponding the Order from VA03
transaction.
If the user double clicks on any other field, Order line item details corresponding to the line selected by
the user needs to be displayed with the following fields:
1) Order Number (VBAK-VBELN),
2) Order Line Item (VBAP-POSNR),
3) Material Number (VBAP-MATNR),
4) Material Description (MARA-MAKTX),
5) Line Item Quantity (VBAP-KWMENG),
6) Line Item Sold-To (VBPA-KUNNR), (Hint: Retrieve with VBPA-POSNR = VBAP-POSNR & VBPA-
PARVW = ‘AG’)
7) Schedule Line Number (VBEP-ETENR), (HINT: There can be more than 1 record for every line
item (VBELN & POSNR combination) in this table and hence all records needs to be displayed).
8) Schedule Line Confirmed Quantity (VBEP-BMENG) and
9) Any Line Item Text (Use READ_TEXT FM to retrieve any Item Text).
Log
Extension Layout
None required
Input Parameters
Output Parameters
The program log should be examined to ensure that the right Orders get displayed in the report. For
further details, please see the ‘Error Handling’ section.
Modified: 1/5/2011 7:13 a1/p1 6 Last modified by: Sachin Jain –
©2010 A2Z. All Rights Reserved. ABAP
Functional Design Form 49001048.doc Version: 1.0
Reporting
Standard report with Order header details, Secondary list with Line item details and an option to navigate
to the display Order transaction.
Also display a standard report header with Program Name, Run Date, Run Time & Company Name on
both Primary and Secondary lists.
In the report footer displayed in both Primary and Secondary lists, display the Page Count as PAGE: n/m,
where n is the current page number and m is the total pages.
Performance
Performance is dependent on the number of records retrieved. Foreground processing of the report
should not exceed time out setting for online processing. Report can also be run in background.
Processing Type
Foreground & Background processing should be possible.
Re-use Details
Rerun the program for the same selection.
This will vary based on the number of Orders created for the processing period.
Error Handling
The transaction code should be featured in the same authorization profiles as Report transaction, SE38.
Other
Range of use
There is no limit to the number of line items that can be present in an Order and displayed in report
output.
Testing Requirements
Key Business Test Conditions
Testing Considerations/Dependencies
Outstanding Issues
Issue Description Assigned To Status Impact Resolution
No
Appendix
Glossary of Terms
Term Definition
Input Comments
Technical Details This document contains functional requirements and some technical
implementation details. These implementation details are subject to
change in the technical design.
Estimate An estimate of work effort needs to be included in the technical
design. The design of this solution should be kept technical simple
and we should encourage users to minimize the use of the upload
process.