コース概要

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

要求

  • 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 時間

参加者の人数



Price per participant

お客様の声 (4)

関連コース

SAP Unicode Conversion (ADM750-SAP)

21 時間

SAP BusinessObjects Business Intelligence (BI)

28 時間

SAP OpenText StreamServe

21 時間

PowerBI Integration with SAP Business One

21 時間

SAP S/4 Hana (S/4Hana)

21 時間

Building Views in ABAP Core Data Services (S4D430)

21 時間

SAP ABAP for Developers

21 時間

SAP ACTIVATE Project Management (C_ACTIVATE13)

14 時間

SAP S/4HANA and SAP Business Suite System Administration I (ADM100)

35 時間

SAP S/4HANA and SAP Business Suite Authorization Concept (ADM940)

21 時間

SAP ASE for Database Administrators

28 時間

SAP Basis for Administrators

35 時間

SAP Data Archiving (BIT660)

21 時間

SAP ILM and Data Archiving: Customer-Specific Developments (BIT670)

21 時間

SAP Business Suite 7 for End Users

21 時間

関連カテゴリー