Get in Touch

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 (2)

Upcoming Courses

Related Categories