SAP

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 value of the first character in the input

2.BINTOSTR(‘encoded_value’): […]

Add CFL into the matrix columns:- In this post i will explain 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  choose value from the list for the form items. Examples: […]

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 doing some action when the […]

SQL Date 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 for the number of days you want to add […]

User Define Function in SAP HANA:- User Defined Functions in SAP HANA are the read only function that means we can not perform any DDL and DML(insert update and delete) operation inside the body of the function.There is two type of user-defined functions: Scalar User Defined Functions and Table User Defined Functions. There are two types […]

Work with matrix sap b1 form:- In this post i describe you, how to work with matrix sap b1 from and .Making the class for creating the form and manipulating the matrix. Note-Don’t forget to add reference of two important UI and DI APIs namely: 1-SAPbouiCOM 2-SAPbobsCOM [AdSense-A] Step-1:Making the class for creating the form and manipulating […]