Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Final Exam in ITAPBUS

    Uploaded by

    Kate Del Rosario
    The document provides instructions for a final exam on ITAPBUS that involves creating documents in SAP B1, including purchase orders, sales orders, and related documents. It also involves performing basic SQL queries and importing a completed item master data template. The exam tasks require adding business partners, items, and completing various document types while providing screenshots as evidence. It concludes with migrating a completed item master data template into SAP B1 Cloud.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Final Exam in ITAPBUS

    Uploaded by

    Kate Del Rosario
    22 views15 pages
    The document provides instructions for a final exam on ITAPBUS that involves creating documents in SAP B1, including purchase orders, sales orders, and related documents. It also involves performing basic SQL queries and importing a completed item master data template. The exam tasks require adding business partners, items, and completing various document types while providing screenshots as evidence. It concludes with migrating a completed item master data template into SAP B1 Cloud.

    Original Description:

    Accounting

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for a final exam on ITAPBUS that involves creating documents in SAP B1, including purchase orders, sales orders, and related documents. It also involves performing basic SQL queries and importing a completed item master data template. The exam tasks require adding business partners, items, and completing various document types while providing screenshots as evidence. It concludes with migrating a completed item master data template into SAP B1 Cloud.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    22 views15 pages

    Final Exam in ITAPBUS

    Uploaded by

    Kate Del Rosario
    The document provides instructions for a final exam on ITAPBUS that involves creating documents in SAP B1, including purchase orders, sales orders, and related documents. It also involves performing basic SQL queries and importing a completed item master data template. The exam tasks require adding business partners, items, and completing various document types while providing screenshots as evidence. It concludes with migrating a completed item master data template into SAP B1 Cloud.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 15

    School of Management

    College of Business and Accountancy


    Final Examination in ITAPBUS
    A.Y. 2021-2022, 1st Semester

    NAME: Danielle Kate O. Del Rosario

    COURSE/YEAR/SECTION: BSA2A DATE: 12/11/21

    Part 1. Creating a Purchase Order and Sales Order Document

    1. Add a Business Partner Master Data


    Input the following information:
    Code: V *add your assigned 4-digit number* (Refer to MS Excel)
    BP Type: Vendor
    Name: Coca-Cola Philippines
    Group: Beverage
    Insert screenshot of the complete details.

    2. Add an Item Master Data


    Input the following information:
    Item No. A *add your assigned 4-digit number* (Refer to MS Excel)
    Description: Coke Zero
    Item Group: Beverage
    Unit Price: Php 25
    Go to Inventory Data Tab
    Warehouse Code: 01
    Warehouse Name: General Warehouse
    Insert screenshot of the complete details.

    3. Create a Purchase Order Document


    Input the following details on the PO Document
    Field Description Field Values

    Vendor Code V *your 4-digit number*

    Vendor Name Coca-Cola Philippines

    Posting Date Date Today

    Item No. A *your 4-digit number*

    Quantity 10

    Insert screenshot of the completed marketing document.


    4. Create a Good Receipts PO from the completed Purchase Order.
    Insert screenshot of the completed marketing document.

    5. Create an AP Invoice from the completed Goods Receipt.


    Insert screenshot of the completed marketing document.
    6. Create an Outgoing Payment from the completed AP Invoice.
    Insert screenshot of the completed marketing document.

    7. Insert screenshot of Relationship Map for PO Document

    8. Add a Business Partner Master Data


    Input the following information:
    Code: C *add your assigned 4-digit number* (Refer to MS Excel)
    BP Type: Customer
    Name: *Your full name*
    Group: Associations
    Insert screenshot of the complete details.

    9. Create a Sales Order Document


    Input the following details on the Sales Order Document
    Field Description Field Values

    Customer Code C *your 4-digit number*

    Customer Name *Your Full Name*

    Posting Date Date Today

    Item No. A *your 4-digit number*

    Quantity 3

    Insert screenshot of the completed marketing document.

    10. Create a Delivery from the completed Sales Order.


    Insert screenshot of the completed marketing document.
    11. Create an AR Invoice from the completed Delivery.
    Insert screenshot of the completed marketing document.
    12. Create an Incoming Payment from the completed AR Invoice.
    Insert screenshot of the completed marketing document.

    13. Insert screenshot of Relationship Map for Sales Order Document

    Part 2. Basic SQL using SAP B1

    1. Generate query report for:


    Table/From: Sales Order
    Select: CardName, CardCode, DocDueDate, InvntSttus
    Insert screenshot of the query generator.

    Insert screenshot of the Query Preview.

    Where: Due Date = ‘Date Today’ ex. 12.10.21


    Insert screenshot of the query generator.
    Insert screenshot of the Query Preview.

    2. Generate query report for:


    Table/From: A/P Invoice
    Select: CardName, CardCode, DocStatus, VatSum
    Insert screenshot of the query generator.
    Insert screenshot of the Query Preview.

    Where: Total Tax > 5000


    Insert screenshot of the query generator.
    Insert screenshot of the Query Preview.

    Where: Document Status = ‘C’


    Insert screenshot of the query generator.
    Insert screenshot of the Query Preview.

    Part 3. Data Migration


    Import to SAP B1 on Cloud a completed Item Master Data
    1. Supply the information using this template.
    Item No. Item Description Item Group

    10

    Additional Information:
    a. It is in the company policy that Item No. has values of 6 alphanumeric characters
    b. Add Item related to food; can be ingredients, fruits, main course or condiments
    c. Item Group should be ‘Food 2020’ for all items.
    Insert screenshot of the completed template (Tab Delimited File)

    2. Create a query that will generate the added items.


    Insert screenshot of the query generator.
    Insert screenshot of the Query Preview.
    Note: Ma’am sorry po magkakahiwalay po kasi yung mga items ko kaya po madaming screen shots po ang
    nailagay ko. Thank you po <3

    Note: Save your file in PDF format.

    Prepared by:

    JEANNE PAULINE S. GUTIERREZ, MIT


    CCIT Faculty

    You might also like