Stored Procedures 

Stored procedures are written entirely in SQL and are executed on the database system.

 

Stored procedures are not recommended by SAP.

Stored procedures are not recommended by SAP. The reason is that stored procedures put the load on the database, the central resource, and therefore restricts the scalability of the whole cluster / system.

Stored procedures can only be considered as quick correction of an architecture / database design problem in a customer project that uses one database.