SAP Power User Materials Management (MM) and Production Planning (PP) with Excel
Free of cost
by funding
-
Certificates: Microsoft Excel" certificate
2 original SAP user certificates -
Examination: Practical project work with final presentations
Module examination Microsoft Excel
SAP user certification UC_MM_S42023
SAP user certification UC_PP_S42022_EN -
Teaching Times: Full-timeMonday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
-
Language of Instruction: German
-
Duration: 14 Weeks
Spreadsheet calculation with Microsoft Excel
Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)
Basics of table editing
Working with formulas and functions
Formatting cells, editing and printing tables
Filling, moving and copying
Calculating with date and time
Creating and editing diagrams
Using individual print settings
Manage workbooks
Using chart templates and chart layouts
Using Excel templates
Sorting and filtering data
User Materials Management (Purchasing, MM) with additional qualification in Sales and Distribution (SD) with SAP S/4HANA
S4H00 SAP S/4HANA Overview (approx. 4 days)
Overview of SAP S/4HANA
Navigation, SAP Fiori, SAP Business Client, SAP Logon
System-wide concepts with organizational units, master data and transactions
Overview of financial accounting and logistics modules, mapping of the respective processes in SAP
Reporting, system structure and migration
SAP service offerings
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
S4500 Business Processes Sourcing and Procurement (approx. 8 days)
Overview and navigation
Processes and corporate structure in procurement
Procurement process
Procurement master data
Stock material compared to consumables
Request via self-service
Extended transactions in procurement
Automated procurement process
Evaluations and analyses
S4600 Business Processes in Sales (approx. 8 days)
Navigation with Fiori
Company structures
Sales processes at a glance
Master data
Automatic data determination and scheduling
Availability check
Collective processing
Further processes in Sales
Complaints processing
Monitoring and sales analyses
S4520 Purchasing (approx. 10 days)
Master data
Sources of supply and conditions
Source determination
Optimized purchasing processing
Document release procedure
Special procurement processes
Supplier evaluation
Further selected topics
S4525 Consumption-based scheduling and forecasting (approx. 4 days)
Consumption-based scheduling
Planning run, forecast
Further options in consumption-based scheduling
Project work/case study, certification preparation and SAP user certification in materials management (approx. 6 days)
SAP User Production Planning (PP)
S4H00 SAP S/4HANA Overview (approx. 3 days)
Overview of SAP S/4HANA
Navigation, SAP Fiori, SAP Business Client, SAP Logon
System-wide concepts with organizational units, master data and transactions
Overview of financial accounting and logistics modules, mapping of the respective processes in SAP
Reporting, system structure and migration
SAP service offerings
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
S4210 Basic data for production and product management (approx. 7 days)
Master data for production
Material, parts lists, work centers, routings
Extended parts list functions
Extended routing functions
S4200 Business processes in SAP S/4HANA Manufacturing (approx. 7 days)
Overview of supply chain planning
Master data, sales planning, program planning, material requirements planning
Overview of the execution of production
Manufacturing with production orders
Manufacturing with process orders
Production with repetitive manufacturing
Material provision via Kanban
Project work/case study, certification preparation and SAP user certification for production planning (approx. 3 days)
Changes are possible. The course content is updated regularly.
You understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.
You will also be familiar with the processes in the area of SAP Material Management and have an overview of the areas of lifecycle data management, the use of the system for work centers and work schedules, the basic concepts and procedures in the area of planning with SAP as well as the concepts of program and requirements planning. You will demonstrate your knowledge with two SAP user certificates.
The course combines the application areas of production planning and materials management and is aimed at work schedulers, persons responsible for work centers and work schedules, consultants, project team members and key users (persons from specialist departments) who are responsible for the introduction of production planning with SAP, persons with training or professional experience in the commercial or administrative field, specialists from the areas of materials management and logistics as well as persons with a degree in industrial engineering, economics or business administration.
Knowledge in the use of various MS Office programs is a prerequisite for successful and efficient work in professional life.
The globally standardized and recognized SAP certificate is considered one of the most important manufacturer certifications in the commercial sector, with which you can improve your career prospects on the job market across all industries. Specialists in the field of production planning and materials management are in demand from both large and medium-sized companies in industry, trade and the service sector.
Training partner of SAP® Germany
In cooperation with the SAP training partner alfatraining Bildungszentrum GmbH, we will qualify you for a job in industry and business.
You are directly connected to the SAP® Germany servers and learn on the original SAP® training system (IDES) in the latest version. This gives you the necessary practical experience during the course.
All SAP user courses also conclude with the original SAP certification. Our SAP instructors are qualified SAP consultants who will provide you with intensive support and prepare you optimally for the certification exam.
Didactic concept
Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).
You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.
Virtual classroom alfaview®
Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face teaching via video technology.
The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).