Enterprise and resource planning
BCO6603 Enterprise Resource Planning Systems Assessment 3 : Workshop Reports
Semester 1, 2019
Name
Student ID
SAP ID GBI -
Tutors Name
Tutorial Time
_____________________________________________________________
Date Due : See VU Collaborate
Marks : 20%
Instructions : The completed assignment must be uploaded to VU Collaborate by the due date and a
hardcopy given to your tutor. Make sure that you read all of the instructions before
entering any data.
Objective : Execute all transactions and produce all reports required to complete a series of
SAP business transactions for the Global Bike Company. Note that you should use the
last three digits of your SAP id in place of ###. Make sure that the title bar is
included in all screen captures.
Printing the reports.
A hardcopy of each report may be obtained in many different ways, for example :
Method 1: Click on the button on the Standard Tool Bar, and then select ‘Hardcopy’. This will print the screen to your local PC printer.
Method 2: Press the “Print Scrn” button on your keyboard. This will copy the screen contents to the Windows clipboard. You can then paste it into a Word document before printing.
Section A : Master Data
Task 1
Create a material master record:
Material CHDX1###, Child Deluxe Bike.
This is a TRADING GOOD (Material Type: HAWA), i.e. a material which is purchased from a vendor and resold to customers; no additional processing is done. It is part of the Mechanical Engineering
industry sector. Use the following data:
Net weight 6000 gm Gross weight 6000 gm Standard Price $900 USD
Valuation Class 3100 Purchasing Group N00 Price Conditions Qty 1
Amount $1200
The material will be stored in Plant MI00 (Miami Distribution Centre), Company US00, Storage Location TG00. All other data, including the organisational levels, is the same as for your ORMG1### bike.
1
Task 2
Create a new customer “Bikes for Kids” located at ### Sunset Ave, Palm Beach, FL, US. 35617 (street number ### is your sap id)
All other data is the same as for “The Bike Zone” customer. “Bikes for Kids” will be managed by the same contact person as “The Bike Zone” – add the contact to the customer record.
Task 3
Using the vendor master record that you created in you MM workshop, enter your name as the Salesperson on the Purchasing Data screen of the Change Vendor transaction
Section B : Purchasing
Task 4
Create a new Purchase Requisition for 50 Child Deluxe Bikes, to be delivered to Plant MI00, Storage location TG00, in 1 month from today.
Task 5
Convert the PR from Task 4 into a Purchase Order.
Use your vendor number.
Purchasing Organisation US00
Net Price USD$ 900
Record a Goods Receipt for the Purchase Order.
Section C : Sales and Distribution
Task 6
“Bikes for Kids” requested a quote for 10 bikes CHDX1###.
a) Create an inquiry which will be valid for one month from today, PO number - ###, order probability 60%.
b) Create a quotation with reference to the created inquiry which will be valid for one month from today, PO number - ###. Offer 10% discount on the entire order.
Task 7
“Bikes for Kids” are happy with the quote and agreed to terms and conditions of the sale. Therefore you need to generate a sales order based on the quotation using ### as PO number.
Task 8
Execute the necessary transactions in order to ship the bikes to the customer:
Task 9
Create an invoice for your customer.
2
Section D : Physical Inventory
Task 10
Create a Physical Inventory Document for warehouse stock of material CHDX1### in Plant MI00, Storage Location TG00.
Enter an inventory count of 35.
Reports
You will now produce a number of reports to show that this data has been entered correctly.
Report 1
Produce a Material List of all Trading Goods whose material code ends with the characters 1###. The fields should be listed in the following sequence:
Material Code
Plant
Material Description
Material Group
Price
Currency
Created by
The report should be sorted by ascending Price within Material Group.
//
Wrong report : 0 marks
Wrong material type (HAWA) : -1
Wrong materials : -1
Column sequence : -1
Sort sequence : -1
Report 2
Produce a Display Changes to Vendor report showing the change that you made to the Vendor Master record in Task 3.
//
Wrong report : 0 marks
No data: -2
Report 3
Use the List Display of Purchase Requisitions to list the Purchase Requisition that was created in Task 4.
//
Wrong report : 0 marks
Wrong data : -2
Report 4
Produce a Print Preview of your Purchase Order for your new product.
// Wrong report : 0 marks
Wrong data : -2
Report 5
Create a Stock Requirements List for the Child Deluxe Bike.
// Wrong report : 0 marks
Wrong data : -1
3
Report 6
Use the List of Enquiries report to list the enquiry you created in Task 6.
// Wrong report : 0 marks
Wrong data : -1
Report 7
Produce a List of Sales Orders report listing the Sales Order you have created in Task 7.
// Wrong report : 0 marks
Wrong data : -1
Report 8
Produce a Document Flow report for the sales order after you have completed Task 8.
// Wrong report : 0 marks
Wrong data : -1
Incomplete flow : -1
Report 9
Produce a Customer Sales report for your customer after completing Task 9.
//Wrong report : 0 marks
Wrong data : -1
Report 10
Produce a Stock Overview report for your new material after the order has been shipped.
// Wrong report : 0 marks
Wrong data : -1
Report 11
Produce a Difference List after completing Task 10.
// Wrong report : 0 marks
Wrong data : -1
Report 12
Using the SAP Quick Viewer, produce a report formatted as shown below which lists details of sales
orders sorted by the date they were created. The report uses data from 3 tables:
VBAP Sales Document Item Data
MARA General Material Data
MAKT Material Descriptions
The fields shown on the report are:
Sales Document VBAP
Sales Document Item VBAP
Material Number VBAP
Material Description (Short Text) MAKT
Material Type MARA
Base Unit of Measure MARA
Name of person who created the object VBAP
Net Price VBAP
Gross Weight MARA
//
Deduct 1 mark for :
Incorrect report headings inc Page numbers.
Incorrect column headings / footings
No control breaks
Truncation of data
Etc. etc
4
5
GET ANSWERS / LIVE CHAT