SAP

SQL Aggregate Functions in SAP HANA with Examples and syntax:- The SQL Aggregate function in SAP HANA contains something different then the SQL SERVER.Below all the SQL Aggregate functions are explained one by one with examples and with syntax. 1.AUTO_CORR(<column>, <maxTimeLag>    {SERIES(…) | ORDER BY <col1>, …}): This function is used to compute all autocorrelation […]

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 New System in Hana Studio:- In this post, I will explain to you how to Add New System in Hana Studio.Adding the new system in hana studio is very simple.For connecting to a SAP HANA system you required to know the Instance Number and Server Host ID.Also, connect to the instance we need the combination […]

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 […]

Making the query report  in sap b1:- In this post, I will explain to you how to Making the query report in sap b1. Below are steps to Making the query report in sap b1. Step1: this navigation- Open the query generator window in this navigation. Tools->Query Manager->Query Generator. step2: window or-Once query generator window opened we can […]