Get in Touch

Course Outline

Introduction

  • Explaining what TN is and why it should be used
  • Describing how TN operates and when it is triggered
  • Comparing TN for SQL and HANA

TN Syntax and Structure

  • Writing and executing TN in HANA Studio
  • Utilising TN parameters and variables
  • Using IF, THEN, ELSE, and END IF statements
  • Using SELECT, FROM, WHERE, and INTO clauses
  • Working with error and error_message variables

TN Examples and Scenarios

  • Validating and controlling data entry and modifications with TN
  • Displaying messages or warnings to users with TN
  • Blocking or permitting specific transactions or actions with TN
  • Integrating TN with other features or tools, such as UDF, UDO, formatted search, and more

TN Best Practices and Tips

  • Testing and debugging TN
  • Optimising 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
 14 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (2)

The exercise and Q&A

Aristantia
Course - SAP MM

passion of the trainer, kindness and good in working with a team.

NOXOLO - Vergenoeg Mining Company
Course - SAP PM Fundamentals to Advanced

Provisional Upcoming Courses (Require 5+ participants)

TN for SAP B1 HANA

2026-11-02 09:30
14 hours
Auckland, ANZ Centre
7800 NZD (Online)
16600 NZD (Classroom)

TN for SAP B1 HANA

2026-11-16 09:30
14 hours
Wellington, Plimmer Towers
7800 NZD (Online)
15300 NZD (Classroom)

TN for SAP B1 HANA

2026-11-30 09:30
14 hours
Te Pou Toetoe Linwood
7800 NZD (Online)
15300 NZD (Classroom)

TN for SAP B1 HANA

2026-12-14 09:30
14 hours
Auckland, ANZ Centre
7800 NZD (Online)
16600 NZD (Classroom)

Related Courses

Introduction to SAP Ariba

 14 Hours
This instructor-led training in New Zealand provides an introduction to SAP Ariba for managing procurement and supplier relationships digitally. Participants will learn to navigate key modules, oversee contracts, and automate workflows to improve efficiency and visibility within strategic sourcing operations.
Read more...

SAP Analytics Cloud (SAC) for Administrators

 14 Hours

This instructor-led, live training in New Zealand (online or on-site) is designed for intermediate-level IT administrators who want to learn how to manage the SAC environment, troubleshoot issues, and provide support to end users.

By the end of this training, participants will be able to:

  • Gain an in-depth understanding of SAP Analytics Cloud administration.
  • Learn how to configure and manage SAC environments.
  • Understand user roles, permissions, and security settings.
  • Manage data connections and data models.
  • Troubleshoot and resolve common SAC issues.
  • Provide technical support to end users.
Read more...

SAP Analytics Cloud (SAC) for End Users

 7 Hours

This instructor-led, live training in New Zealand (delivered online or on-site) is designed for beginner-level end-users who wish to learn how to manage and understand the technical aspects of SAC.

By the end of this training, participants will be able to:

  • Understand the fundamentals of SAP Analytics Cloud (SAC).
  • Learn how to navigate the SAC interface.
  • Create and manage queries and reports.
  • Design interactive dashboards and visualisations.
  • Use SAC features for data exploration and analysis.
  • Export and share reports with other users.
Read more...

SAP Ariba for the Oil Industry

 21 Hours

This instructor-led, live training in New Zealand (online or on-site) is aimed at beginner-level to intermediate-level professionals in the oil industry who wish to optimise 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.
  • Optimise procurement workflows and compliance processes.
  • Integrate SAP Ariba with existing ERP systems for seamless operations.
Read more...

SAP Datasphere and SAP Analytics Cloud for Administrator-Operators

 21 Hours
This instructor-led training in New Zealand empowers intermediate Administrator-Operators to streamline the management of SAP Datasphere and SAC environments. Learners will gain the skills to configure the Cloud Connector, administer roles and connections, and effectively troubleshoot S/4HANA integrations.
Read more...

SAP Datasphere and SAP Analytics Cloud for Operators

 12 Hours
This live training in New Zealand equips beginner-to-intermediate operators with the practical skills needed to use SAP Datasphere and Analytics Cloud. Participants will learn to build dashboards, track KPIs, and explore connected S/4HANA models to gain actionable business insights.
Read more...

SAP MM

 21 Hours

This instructor-led, live training in New Zealand (available online or on-site) is designed for functional consultants who wish to manage procurement operations within a company using SAP MM.

By the conclusion of this training, participants will be able to:

  • Perform end-to-end transactional activities within the SAP system.
  • Create and maintain MM master data in the SAP system.
  • Understand the organisational structure within the SAP system.
Read more...

SAP MM (Materials Management): Configuration, Management, and Processes

 21 Hours
This live, instructor-led training in New Zealand focuses on SAP MM configuration, management, and core processes. Participants will develop practical skills in handling master data, purchasing, MRP, and integrating with other SAP modules. It is ideally suited for consultants aiming to excel in enterprise procurement operations.
Read more...

SAP MM Fundamentals: Materials Management Essentials

 14 Hours
This live, instructor-led training in New Zealand focuses on the core aspects of SAP MM for procurement and stock control. Participants will develop practical skills in managing master data, purchase orders, goods movements, and basic configuration, enabling them to navigate real-world materials management scenarios with assurance.
Read more...

SAP PM Fundamentals to Advanced

 21 Hours

This instructor-led, live training in New Zealand (online or on-site) is designed for business analysts, consultants, and other relevant professionals who intend to use SAP PM to maintain and enhance the performance of business units.

By the end of this training, participants will be able to:

  • Install and configure SAP PM software.
  • Integrate SAP PM features into their business IT infrastructure.
  • Use SAP PM as a tool to fulfil the responsibilities associated with maintenance roles.
  • Leverage SAP PM reports to address client requirements.
  • Understand the significance of SAP PM implementations for plant workflows and worker safety.
Read more...

SAP PM Level 1: Fundamentals of Plant Maintenance

 20 Hours
This live, instructor-led training in New Zealand covers SAP PM essentials for entry-level planners. It guides you through navigating the module, creating and managing notifications and work orders, and understanding equipment structures, supported by interactive exercises and practical application.
Read more...

SAP PM Level 2: Master Data Management and Maintenance Strategies

 20 Hours
This live training on New Zealand is tailored for intermediate planners seeking to control SAP PM master data and set up maintenance strategies. Participants will define corrective, preventive, and predictive plans while developing task lists. You will then activate and monitor these automated plans within a live-lab environment.
Read more...

SAP PM Level 3: Planning and Scheduling of Maintenance Orders

 20 Hours
This instructor-led, live training in New Zealand addresses detailed work order planning and scheduling within SAP PM. Specifically designed for intermediate planners, it emphasises the creation of resource-optimised maintenance orders. Learners will gain the skills to assign materials, tools, and labour using integrated planning tools.
Read more...

SAP PM Level 4: Advanced Management, Reporting, and Analysis

 20 Hours
This specialist SAP PM training in New Zealand empowers learners with advanced skills in KPI evaluation, bespoke reporting, and integration across MM and FI modules. The curriculum prioritises cost control and ongoing optimisation, aiming to elevate operational standards and inform strategic leadership through applied, hands-on learning.
Read more...

Winshuttle Studio Transaction for SAP MM: Automating Mass Data Changes

 14 Hours
Boost SAP MM efficiency through this live training in New Zealand. Learners will acquire the skills to automate bulk data creation, updates, and cancellations using Winshuttle Studio Transaction, thereby enhancing accuracy while mitigating manual errors. The curriculum emphasizes script development and industry best practices.
Read more...

Related Categories

SAP
SAP