Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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.
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)
The exercise and Q&A