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.

Certified SAP MM Consultant

SUMIT JAIN

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.

Course curriculum

  • 1

    Learn SAP Query Step by Step

    • SAP Query

    • Introduction - SAP Query

    • Material Master Report

    • Material Master Tables

    • Creation of User Group - SQ03

    • Creation of Infoset - SQ02

    • Assignment of Infoset to User Group - SQ02

    • Creation of SAP Query - SQ01

    • SQVI Query Report Creation

    • Conclusion