TN for SAP B1 HANA Training Course
TN or transaction notification is a feature of SAP Business One that allows you to validate and control the data entry and modification in the database.
This instructor-led, live training (online or onsite) is aimed at beginner-level SAP Business One users and developers who wish to learn the basics of TN and how to use it to validate and control data entry and modification in the database.
By the end of this training, participants will be able to:
- Set up and use TN in HANA Studio.
- Write and execute TN in SQL.
- Use TN to validate and control data entry and modification.
- Use TN to display messages or warnings to the users.
- Use TN to integrate with other features or tools, such as UDF, UDO, formatted search, etc.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction
- Explaining what TN is and why use it
- Describing how TN works and when it is triggered
- Comparing TN for SQL and HANA
TN Syntax and Structure
- Writing and executing TN in HANA Studio
- Using the parameters and variables of TN
- Using IF, THEN, ELSE, and END IF statements
- Using SELECT, FROM, WHERE, and INTO clauses
- Using error and error_message variables
TN Examples and Scenarios
- Validating and controlling data entry and modification with TN
- Displaying messages or warnings to the users with TN
- Blocking or allowing certain transactions or actions with TN
- Integrating TN with other features or tools, such as UDF, UDO, formatted search, etc.
TN Best Practices and Tips
- Testing and debugging TN
- Optimizing and improving TN performance
- Avoiding common TN errors and pitfalls
- Documenting and maintaining TN
Summary and Next Steps
Requirements
- Basic knowledge of SAP Business One and HANA database concepts
- Familiarity with SQL and stored procedures
Audience
- SAP Business One users
- SAP Business One developers
Open Training Courses require 5+ participants.
TN for SAP B1 HANA Training Course - Booking
TN for SAP B1 HANA Training Course - Enquiry
TN for SAP B1 HANA - Consultancy Enquiry
Consultancy Enquiry
Testimonials (2)
The trainer was very good, he knew the subject well and know how to explain to us any questions we had and that helped us a lot.
Dirman Ionut - HELLA Ghiroda
Course - SAP PM Fundamentals to Advanced
I was very impressed with the trainers preparation. As he went along he kept going back over the subjects that he had covered
Ted Audain - Frucor Suntory Ltd
Course - SAP MM
Upcoming Courses
Related Courses
Introduction to SAP Ariba
14 HoursSAP Ariba is a cloud-based solution that helps organizations manage their procurement, supplier relationships, and sourcing strategies in a unified digital environment.
This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level users who wish to understand the key features of SAP Ariba and how it integrates into strategic sourcing and procurement operations.
By the end of this training, participants will be able to:
- Navigate SAP Ariba and understand its positioning within the SAP ecosystem.
- Manage suppliers, contracts, and sourcing processes using Ariba’s core modules.
- Collaborate with vendors and automate procurement workflows through Ariba Network.
- Apply best practices to improve procurement efficiency, visibility, and compliance.
Format of the Course
- Interactive lecture and discussion
- Hands-on practice with real scenarios (if demo environment available)
- Case-based examples and best-practice reviews
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP Ariba Procurement: Administration
14 HoursAudience
- System Adminstrators
- Functional and Technical Consultants
Goals
- This course will prepare you to:
- Learn about the Ariba Cloud infrastructure and resources, data types and integration methods, how to maintain catalogs and approval rules, how to enable new features.
SAP Ariba for the Oil Industry
21 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at beginner-level to intermediate-level professionals in the oil industry who wish to optimize their procurement processes using SAP Ariba.
By the end of this training, participants will be able to:
- Understand the key functionalities of SAP Ariba relevant to the oil industry.
- Manage supplier relationships, sourcing, and contracts effectively.
- Optimize procurement workflows and compliance processes.
- Integrate SAP Ariba with existing ERP systems for seamless operations.
SAP Hana for Data Analysts
21 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at data analysts who wish to use SAP HANA to capture data from diverse data sources for fast processing and analysis.
By the end of this training, participants will be able to:
- Understand SAP Hana in-memory database
- Accelerate access company data
- Model data in an SAP Hana database
- Carry out real-time analytics on large amounts of continuously changing data.
SAP HANA Introduction
14 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at beginner-level database administrators who wish to understand the basic concepts of SAP HANA and learn how to use its development and administration tools.
By the end of this training, participants will be able to:
- Understand the basic concepts of SAP HANA.
- Become familiar with the SAP HANA architecture and its key components.
- Learn about SAP HANA development and administration tools.
SAP MM
21 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at functional consultants who wish to manage procurement operations in a company with SAP MM.
By the end of this training, participants will be able to:
- Preform end-to-end transactional activities in the SAP system.
- Create and maintain MM master data in the SAP system.
- Understand the organizational structure in the SAP system.
SAP MM (Materials Management): Configuration, Management, and Processes
21 HoursSAP MM (Materials Management) is a module in SAP ERP used to manage procurement, inventory, and material resource planning across an organization. It integrates with other SAP modules such as FI, CO, and SD to streamline business processes.
This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level functional consultants and developers who wish to configure, manage, and execute SAP MM processes within an enterprise system.
By the end of this training, participants will be able to:
- Perform end-to-end SAP MM transactions from purchase requisition to goods receipt and invoice verification.
- Configure key components of the MM module including organizational structure, master data, and purchasing settings.
- Manage vendor and material master data effectively to support procurement operations.
- Integrate SAP MM with other SAP modules for complete business process management and reporting.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP MM Fundamentals: Materials Management Essentials
14 HoursSAP MM (Materials Management) is a key module within the SAP ERP suite that handles procurement, inventory management, and material planning processes across an organization.
This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to gain a solid understanding of SAP MM concepts and functionalities, with some exposure to hands-on configuration and transactions.
By the end of this training, participants will be able to:
- Understand the core concepts and components of SAP MM.
- Describe the end-to-end procurement and inventory management process.
- Navigate SAP MM transactions for materials and purchasing.
- Apply basic configuration and master data management in SAP MM.
Format of the Course
- Interactive lecture and discussion.
- Theory with guided demonstration.
- Hands-on practice with limited real system exercises.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP PM Fundamentals to Advanced
21 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at business analysts, consultants, and other corresponding personnel who wish to employ SAP PM for sustaining the performance of business units.
By the end of this training, participants will be able to:
- Install and configure the SAP PM software.
- Integrate the features of SAP PM into the IT structure of their business.
- Utilize SAP PM as a tool for executing the responsibilities of maintenance roles.
- Make use of SAP PM reports to resolve the needs of clients.
- Recognize the importance of SAP PM implementations to plant workflow and the safety of work personnel.
SAP PM Level 1: Fundamentals of Plant Maintenance
20 HoursSAP PM (Plant Maintenance) is a module in SAP used to support all maintenance activities in an organization, including inspection, preventive and corrective maintenance, and repair operations.
This instructor-led, live training (online or onsite) is aimed at beginner-level planners and supervisors who wish to become familiar with SAP PM and understand how to create and track notifications and work orders.
By the end of this training, participants will be able to:
- Navigate and operate basic functions within the SAP PM module.
- Create and manage simple maintenance notifications and work orders.
- Understand the technical structure, including equipment and technical locations.
- Track the progress of maintenance activities through notifications and orders.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP PM Level 2: Master Data Management and Maintenance Strategies
20 HoursSAP PM (Plant Maintenance) enables the creation and structuring of master data to support efficient maintenance planning and execution. Accurate and well-maintained data is key to automated planning and effective execution of maintenance strategies.
This instructor-led, live training (online or onsite) is aimed at intermediate-level maintenance planners who wish to manage SAP PM master data and configure maintenance strategies, task lists, and maintenance plans.
By the end of this training, participants will be able to:
- Create and maintain structured master data for maintenance activities.
- Define and implement corrective, preventive, and predictive strategies.
- Develop task lists and link them to automated maintenance plans.
- Activate and monitor plan execution in SAP PM.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP PM Level 3: Planning and Scheduling of Maintenance Orders
20 HoursSAP PM (Plant Maintenance) enables detailed scheduling and management of work orders aligned with materials, labor, and capacity planning. This level focuses on creating fully scheduled and resource-optimized maintenance orders.
This instructor-led, live training (online or onsite) is aimed at intermediate-level planners and planning managers who wish to execute detailed work order planning and scheduling across maintenance teams and assets.
By the end of this training, participants will be able to:
- Develop efficient work orders linked to maintenance strategies and task lists.
- Assign materials, tools, and human resources using integrated planning tools.
- Schedule work orders based on capacity and operational priorities.
- Track and update progress, adjusting plans as needed in real time.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP PM Level 4: Advanced Management, Reporting, and Analysis
20 HoursSAP PM (Plant Maintenance) provides robust tools for analyzing maintenance operations, managing costs, and supporting strategic decisions. This level focuses on the use of KPIs, reports, and integration with other SAP modules to drive operational excellence and continuous improvement.
This instructor-led, live training (online or onsite) is aimed at advanced-level users who wish to develop reporting, analytics, and cross-functional integration skills to improve maintenance decision-making and cost management.
By the end of this training, participants will be able to:
- Analyze maintenance cost data and manage budgets efficiently.
- Use SAP PM reporting tools to monitor key indicators and generate custom reports.
- Leverage data integration with MM and FI modules for broader analysis.
- Apply continuous improvement techniques using process analytics and reporting feedback.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
SAP SD
21 HoursThis instructor-led, live training in Croatia (online or onsite) is aimed at functional consultants who wish to create a business process for product management using SAP SD.
By the end of this training, participants will be able to:
- Define an organizational structure in the SAP system.
- Understand and implement master data in SAP SD.
- Create sales inquiries, quotations, sales orders, and invoices in SAP the system.
Winshuttle Studio Transaction for SAP MM: Automating Mass Data Changes
14 HoursWinshuttle Studio is a data management and automation platform that integrates with SAP to streamline repetitive business processes.
This instructor-led, live training (online or onsite) is aimed at intermediate-level SAP and data professionals who wish to increase time efficiency and reduce errors by automating mass data creation, updates, and cancellations within SAP MM using Winshuttle Studio Transaction.
By the end of this training, participants will be able to:
- Understand the core features of Winshuttle Studio Transaction.
- Create and optimize scripts for automating SAP MM processes.
- Execute mass data creation, changes, and cancellations efficiently.
- Improve accuracy and compliance through automation best practices.
Format of the Course
- Interactive lecture and discussion.
- Hands-on script development exercises.
- Live-lab implementation of SAP MM process automation.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
