Learn SAP Query Step by Step
What you'll learn
- 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
Requirements
- IDES System or some other SAP testing system should be installed
- You should be familiar with the Basic concepts of SAP Navigations.
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.
Who this course is for:
- 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
Course content
- Preview03:12
- 01:48Material Master Report
- Preview04:00
- Preview01:47
- 06:37Creation of Info set - SQ02
- 00:38Assignment of Infoset to User Group -SQ02
- 06:46Creation of SAP Query -SQ01
- 04:02SQVI Query Report Creation
Instructor
![Sumit Jain](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 844 Reviews
- 3,171 Students
- 31 Courses
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.