HANA Procedure :SAP HANA Procedure in 10 minutes

Introduction

Suppose we have a table with 5 column and we want to change NETWR (Net Sales) from Dollar to Euro For this scenario we will write procedure.



Creating Procedure in SAP HANA

1. Click on your Package Right Click--> New-->Procedure
   
2. Give the name of Procedure and Description of Procedure
   
3. After this one more folder Procedure will create inside your package and a sample BEGIN and END code will be Generated. You have to write your Logic here.
   
4. Write the code in between BEGIN and END and in the select statement
   VBELN – Column name
   ERDAT  - Column name
   KUNNAR- column name
   NETWR- column name(Net revenue)
   round(NETWR/1.240) as Euro – round value of column NETWR and column will show as Euro
   
5. Check and Activate after that one procedure will be created in your package
    
6. After Activation one procedure will be created inside SYS_BIC Schema.
   
7. For calling the schema write SCHEMA schema Name
   
8. last Step is Run and check the output.
   
   
   
   
   
   
   For more information send me mail on sandeepcts1989@gmail.com