Creating Custom Ad-hoc Queries in SAP

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.

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

Who This Training Is For

  • End users
  • IT/Business analysts
  • System Administrators


  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Creating Custom Ad-hoc Queries in SAP certificate

This Course is In the Following Learning Paths:

SAP Materials Management Consultant
SAP Materials Management Consultant

This learning path for a career as an SAP Materials Management Consultant covers the core configuration tasks in SAP's M...

SAP Material Master Data Specialist
SAP Material Master Data Specialist

Work with SAP's Material Master Data to become a Material Master Specialist.  Learn the foundations of creating and...

Show All Learning Paths


Nicole  Land

4.7 Average Rating

140 Reviews

603 Students

5 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.

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

Student Feedback


Average Rating


Language: English
Level: Intermediate
Duration: 1.00 hours
Type:  Instructor-led
Releases: ECC 6.0
Category: BASIS, HANA & Tools

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business