TN for SAP B1 HANA

• 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

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.

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