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.

13  Reviews   4.8


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

Exam/Certificate

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


Instructor

Nicole  Land

4.8 Average Rating

81 Reviews

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

Specialties
• 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 


More Courses by Nicole  Land:

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

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

View All Courses

Student Feedback

4.8

Average Rating

Reviews

Subscribe to All Courses
Subscribe

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
Releases: ECC 6.0
Category: BASIS, HANA & Tools

SAP students

277

student views.
Join them!



Learning Path

This training course is included in the following Learning Path:

SAP Materials Management ConsultantSAP Query ReportingSAP Material Master Data Specialist