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

Number of participants



Price per participant

Testimonials (11)

Related Courses

Related Categories