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 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
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (2)
Teacher knolage
Collin Sampson
Course - SAP S/4HANA Overview (S4H00)
I liked the fact that the trainer was very flexible and offered information about subjects that were not included in the initial material. I liked his experience in other projects and the tips and tricks resulted from this experience. The training was interactive and even though the exercises were predefined, we could take the exercise in another direction than previously defined.
