Zum Hauptinhalt springen

Custom Data Model Design for a Business Scenario in SAP

Objective:​

By the end of this assignment, attendees should be able to create a custom data model for a business scenario of their choice in an SAP system. The data model should include database tables, data elements, and CDS views as well as demo data.

Duration:​

Approximately 2.5 hours

Instructions:​

1. Identify a Business Scenario:​

Choose a business scenario that you would like to model from the scenarios below or choose your own example.

2. Data Elements:​

Define the data elements required for your business scenario. Each data element should have a meaningful name, a description, an associated data type, and a length.

For example, if you are modeling an inventory system, some data elements might include:

  • Material Number
  • Material Description
  • Quantity
  • Unit of Measure
  • Price per Unit
  • Warehouse Code
  • Warehouse Description

3. Database Tables:​

Design the database tables required for your scenario using the data elements you defined. Each table should have a primary key and appropriate relationships.

For example, if you are modeling an inventory system, you might need:

  • A Material Table to store material information.
  • An Inventory Table to store inventory data.
  • A Warehouse Table to store warehouse information.

Create and populate at least 4 tables with 20 entries each.

4. CDS Views:​

Create CDS views to provide a summarized and filtered view of the data. Think about what kind of information would be useful for users and how it should be presented.

For example, in an inventory system, you might create:

  • A view that shows the total quantity and total value of each material across all warehouses.
  • A view that shows the quantity and value of materials in a specific warehouse.

Create at least 4 views.

5. Documentation:​

Document your data model in a Word document or similar format. Include:

  • A brief description of the business scenario and the purpose of the data model.
  • A list of the data elements with their definitions and data types.
  • An ERD of the database tables showing their names, columns, primary keys, and relationships (use an online tool such as draw.io).
  • Sample queries for each CDS view to demonstrate how they can be used (at least two different queries per CDS view).

Evaluation Criteria:​

Your data model will be evaluated based on the following criteria:

  • Accuracy and completeness of data elements.
  • Correctness of database table design.
  • Functionality and usefulness of CDS views.
  • Quality of documentation.
  • Creativity and relevance of the chosen business scenario.

Good luck! If you have any questions, please do not hesitate to ask your instructor.

Scenarios​

  1. Online Bookstore: "Book Nook"

Book Nook is an online bookstore that sells physical books, e-books, and audiobooks. They need a system to manage their inventory, customer orders, and author information. The store offers a loyalty program for frequent buyers and hosts virtual book club meetings.

  1. Fitness Center Chain: "FitZone"

FitZone is a growing chain of fitness centers across the country. They need a system to manage member subscriptions, class schedules, trainer assignments, and equipment inventory. They also want to track member progress and offer personalized workout plans.

  1. Food Delivery Service: "QuickBite"

QuickBite is a food delivery service that partners with local restaurants. They need a system to manage restaurant listings, customer orders, delivery driver assignments, and customer ratings. They also offer a subscription service for frequent users with special perks.

  1. University Management System: "EduTrack"

EduTrack is a comprehensive system for managing a large university. It needs to handle student enrollment, course registration, faculty information, class schedules, grades, and campus facilities management. The system should also support online learning options and track research projects.

  1. Car Rental Agency: "WheelDeal"

WheelDeal is a car rental agency with multiple locations. They need a system to manage their vehicle inventory, customer reservations, rental agreements, and maintenance schedules. They also offer a loyalty program and partner with local hotels and airlines for package deals.

  1. Hospital Management System: "HealthHub"

HealthHub is a system for managing a large hospital. It needs to handle patient records, doctor schedules, appointment bookings, room allocations, and inventory of medical supplies. The system should also manage billing, insurance claims, and integrate with various medical devices for patient monitoring.

  1. E-commerce Marketplace: "BazaarBay"

BazaarBay is an online marketplace where multiple vendors can sell their products. The platform needs to manage vendor accounts, product listings, customer orders, payment processing, and shipping logistics. It also includes a review system and personalized product recommendations.

  1. City Public Transportation System: "MetroLink"

MetroLink manages the public transportation for a large city, including buses, trains, and trams. The system needs to handle route planning, vehicle scheduling, ticket sales, and real-time tracking of vehicles. It should also manage employee schedules and maintenance of vehicles and stations.

  1. Event Management Company: "GalaGurus"

GalaGurus is an event management company that organizes various types of events, from small business meetings to large music festivals. They need a system to manage client bookings, venue reservations, vendor contracts, staff assignments, and budget tracking for each event.

  1. Smart Home Automation System: "HomeSmart"

HomeSmart is a company that provides smart home automation solutions. They need a system to manage customer accounts, device installations, automation rules, and energy consumption data. The system should also handle troubleshooting requests and software updates for installed devices.