Creating Custom Ad-hoc Queries in SAP
IC0965

Creating Custom Ad-hoc Queries in SAP

In this course, you will build your skills by creating a simple query in SAP using the MARA table as a single data source, and then learn how to make that query more complex by using JOINS to add the MAKT table. Complete your learning by creating an advanced query by introducing the alias table concept.

2  Reviews   5.0 of 5.0

Course Goal

  • Locate the technical data required to build a query
  • Create simple queries using the quickviewer
  • Create advanced queries using the quickviewer
  • Convert a quickview query to an SQ01 user group

Audience

  • End users
  • IT/Business analysts
  • System Administrators

Exam/Certificate


Lesson Plan

2
Query Overview

3
Let's Review the Basics

4
Demo 1: Simply Query
5
Demo 2: Advanced Query Using Table Join
6
Demo 3: Advanced Query Using Alias Table
7
Demo 4: Publish to SQ01

8
Wrap Up
9
Course Handout

Instructor

Nicole  Land

4.8 Average Rating

39 Reviews

81 Students

4 Courses

Nicole  Land

SAP Consultant

I am an SAP CERTIFIED consultant focusing on delivering creative solutions to business problems. My superpower is the ability to define overwhelming business problems and break them down into manageable milestones. I do this by leveraging years of project management expertise, deep SAP functional knowledge & relentless devotion to user satisfaction.

Experience includes:
• Complex troubleshooting
• Configuration of PP, MM, SD, Logistics, IM & QM
• Configuration of SAP CRM and GTS modules
• Project planning and execution in leadership roles.
• Data migration, analysis & cleansing.

Specialties
• SAP Certified for PP (production planning & manufacturing
• Very proficient with SAP MM, SD, IM, QM
• Data migration
• Business Process Alignment & Optimization
• Project Managemeng
• End User Training & Documentation 


More Courses by Nicole  Land:

Leveraging PO Confirmations in SAP
Leveraging PO Confirmations in SAP

In this course, you'll learn why creating and sending POs to your vendors shouldn't be the end of the procure...

4.9

Average Rating

Review and Manage the SAP MRP List
Review and Manage the SAP MRP List

This course covers the navigation and management of the SAP MRP List in order to identify and resolve issues coming o...

4.7

Average Rating

Using Quota Arrangements in SAP
Using Quota Arrangements in SAP

If you are a Materials Buyer, you know that procuring a single material from multiple sources can present unique chal...

4.8

Average Rating

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$69


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Intermediate
Duration: 1.00 hours
Type:  Instructor-led
Release: ECC 6.0
Category: SAP Basis, HANA & Winshuttle Tools

SAP students

57

student views.
Join them!


Related Courses