Get in Touch

Course Outline

Introduction

  • Explaining what TN is and why it is used.
  • 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.
  • Utilizing IF, THEN, ELSE, and END IF statements.
  • Employing 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 users with TN.
  • Blocking or allowing certain transactions or actions with TN.
  • Integrating TN with other features or tools, such as User-Defined Fields (UDF), User-Defined Objects (UDO), formatted search, and more.

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.
 14 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3200 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories