Learn SAP Query Step by Step

Learn about the creation of SAP Quick viewer Reports which helps to user to create the report as per business needs.
3.8 (19 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
102 students enrolled
Instructed by Sumit Jain Office Productivity / SAP
$45
Take This Course
  • Lectures 9
  • Contents Video: 30 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

SAP MM Material Management - Welcome to this training course presentation of the SAP Materials Management -

What is SAP query and why do we need queries?

Many times a need arises for SAP Users and Functional Consultants to generate quick reports without getting any ABAP coding done – time taken to complete the coding in development, transport and test it in QA system and then transport to production – is sometimes too long. In such cases, SAP query is a tool provided by SAP for generating these kinds of reports.

Overview of the course: - I will start talking about the basic SAP Query Creation concepts. SAP Query Creation with some real LIVE examples. What separates this course from other SAP courses is a focus on clarity and presentation. All lessons are easy to follow and feature a step by step guide to help beginners.

What are the requirements?

  • IDES System or some other SAP testing system should be installed
  • You should be familiar with the Basic concepts of SAP Navigations.

What am I going to get from this course?

  • understand the concept of creation of SAP Query
  • understand the concept of tailor made reports as per business requirements
  • understand the quick report creation in SAP

What is the target audience?

  • This SAP Query course is meant for newbies who are not familiar with the Report creation method via SAP Query.
  • This course is probably not for you if you don't want to enter in to the SAP Career.
  • SAP Functional Consultants

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
SAP Query Basic Details
Preview
03:12
Material Master Report
01:48
Material Master Tables
Preview
04:00
Creation of User Group - SQ03
Preview
01:47
Creation of Info set - SQ02
06:37
Assignment of Infoset to User Group -SQ02
00:38
Creation of SAP Query -SQ01
06:46
SQVI Query Report Creation
04:02
Section 2: Conclusion
Conclusion
Preview
01:33

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sumit Jain, Certified SAP MM Consultant

Over 10 years of experience on SAP MM, IM and WM functional consultant in various SAP R/3 implementations, industries- Process, Manufacturing, Energy and chemical.

Excellent understanding of business processes in Logistics – Material management & Inventory management.

Experienced in 6 full life-cycle implementation phases of a project (ASAP Methodology) - blueprinting, realization, testing ( Unit testing, User acceptance testing, Assembly testing and integration testing ), final preparation, training, documentation, data uploading, go live and post go live (production) support.

Interacted with business partners to understand the AS-IS process and work on developing TO-BEprocess.

Designed, tested and supported for the development of functional specifications for RICEFW objects..

Conducted Business blue printings - Requirement definitions, system/process mapping & solution design.

Worked on different kinds of projects such as New End-to-end implementation projects, Development projects, up gradation projects, Enhancement projects.

Configured MM Organizational Elements: Company code, Purchasing Organization, Plant & Storage loc.

MM-Purchasing/Procurement: Hands on experience in configuring Material Master, Vendor Master, Partner schema, Purchase requisition, Purchases order, Venison management, shelf like check and pricing schemas.

Expertise in designing scenarios like outline agreements, RFQ, source list, info records, quota arrangement, Scheduling agreement, Reservation, Vendor consignment, subcontracting and vendor evaluation.

Inventory Management: Customizing done in Goods Movements, Cross Company and Intra-company Stock Transport orders using Stock Transport order (STO), Subcontracting, Customer and Vendor Consignment & Third Party Orders, Physical Inventory, Cycle Counting.

Configuration of Inventory Management Movement Types, Number ranges for material document of Goods Receipt, Goods Issue, shelf life check for movement types and Stock Transfers- inter and intra company.

Ready to start learning?
Take This Course