Category: SAP

SQL String Functions in SAP HANA with Examples and syntax

SQL String Functions in SAP HANA with Examples and syntax:- SQL String Functions in SAP HANA with Examples and syntax. The SQL string Function in SAP HANA contains something different then the SQL SERVER.Below all the SQL functions are explained one by one with examples and with syntax. 1.ASCII(‘character_value’) or ASCII(number): functions returns the ASCII […]

Add CFL into the matrix columns in SAP B1

Add CFL into the matrix columns:- Add CFL into the matrix columns in SAP B1. In this post, I will explain to you how to Add CFL into the matrix columns.CFL stands for ChooseFromList .It is feature of the sap that allow you to put the CFl on form items like EditText,Column,Button ,etc.Through it we can […]

Transaction Notification in SAP B1

Transaction Notification in SAP B1:- Transaction Notification in SAP B1. In this post, I will explain Transaction Notification in SAP B1.SP_Transaction Notification is the stored procedure automatically created in each database when we create the database.We use this procedure for handling the validation against the business object so that we can prevent the users from […]

SQL Date and Time Function in SAP HANA

SQL Date Time Function in SAP HANA:- SQL Date and Time Function in SAP HANA. The SQL Date and Time Functions in SAP HANA contain something different then the SQL SERVER. Below all the SQL functions are explained one by one with examples and with syntax. 1.ADD_DAYS(d,n): Here d stands for date and n stands […]