Requirements
In the scenario of launching an online shop, you will offer to your customers via the internet specialized goods, i.e. each of you will offer individual products (see classification list in the appendix). Therefore, you have to prepare database tables to handle your offered goods and to store some invoice information.
1. To handle the offered goods, create a database table which will hold all relevant information. Choose all data types carefully. Also, choose the lengths carefully. The database for the products should contain at least 5 different fields plus the field holding the client number. You need one field to hold the selling price of your product, see table invoices below. The names and the datatypes of your fields depend on your individual products and have to be specific, pls. be creative. Use data elements and domains for all fields. Reuse your data elements and domains whenever possible. Don’t use the same fields / names as other students do (unauthorized plagiarism).
2. To store your fictive invoices, create a database table which will hold the invoice information. Choose all data types carefully, e.g. remember that there is a ‘Date’ data type as well. Also, choose the lengths carefully. Use data elements and domains for all fields. Reuse your data elements and domains whenever
possible. The database for the invoices should contain at least the following fields:
• Invoice number
• Invoice date
• Customer Name
• Postal Code
• City
• Product Id (see also sec. 5)
• Quantity
• Amount
3. The field ‘Product ID’ should be checked against the other table for proper values. We’ve already done this with the ‘Title’ field; refer to the exercise of chapter 4. Remember that the ‘Domain’ has to be the same in the table you create and the table it is being checked with.
4. Now that you have two tables created, enter information in both of them. At least you have to enter 10 products and 10 invoices.
5. Regarding the output, the data should be well formatted and look good on the page. Be sure to use a HEADER nicely underlined and using TEXT ELEMENTS – You will lose marks if it is hard coded into the program. Adjust the position of your data to the text of your header line, it has to fit. Use colors (we haven’t done this within class, so look to the help file or internet for ABAP ‘format color’ statement).
6. Create an input screen with four radio buttons using PARAMETERS. Depending on the marked radio button pls. create different reports:
• If the first radio button is selected, your report has to output ALL the PRODUCT records and all columns from the product table.
• If the second radio button is selected, your report has to output ALL the INVOICE records and all columns from the invoice table.
• If the third radio button is selected, your report should present only those invoices that bill the product you enter in a text parameter box. In addition, all columns from both tables should be displayed (you will need to JOIN both tables in your SELECT statement, see F1 help for the SELECT keyword).
• If the fourth radio button is selected, you have to recalculate and update the invoice amount in your invoice table. Multiply the invoice quantity from the invoice table and the product price from the product table and store the result in the invoice table. During calculation output ALL the INVOICE records with the new calculated amount.
7. Print at the top of your report the date, the time and your username as you can see in the output examples below.
8. Print the number of records which were returned as in the output examples below – Hint, it’s another SY- command.
9. You have to modularize your source code by using Functions, Includes, Subroutines, Forms etc, although it might not be necessary based on your source code length and architecture. Properly define the parameter interface; re-use source code if you can; You will learn this in chapter 6, modularization.
MUST:
- Declare tables, data elements, domains and data types in the SAP Data Dictionary and name them according to your namespace. The tables have to be client- dependent.
- Write source code (ABAP code) with documentation and comments (*…) in the SAP system. Based on these comments your source code should be completely documented and understandable.
- Program and implementation have to be well formatted, i.e.
o indent if statements, select statements, etc. (use ABAP formatter/pretty printer)
o use meaningful variable names
o look for consistency, i.e. all uppercase or all lowercase keywords
o proper use of data elements and domains (re-use if you can)
o keep source code compact and readable
o use text elements
o logically structure your program (“program architecture”); modularize your source code
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
