In a database management system (DBMS), a stored procedure is a set of SQL statements with an assigned name that is stored in the database for repeating tasks on top of fast changing real-time data processing.
A stored procedure is used to consolidate and centralize data intensive logic. It can accept input parameters and return output parameters. There are scalar- and tabular outputs possible. Stored procedures next to calculation views play a key role in the strategic goal of pushing the processing logic to the database through the usage of procedure plans and the optimizer.
At design time, it is defined via the .hdbprocedure artifact.