Transport and Lifecycle Management of Required Objects
The ABAP classes that implement the SQLScript metadata rules can be transported with the SAP NetWeaver CTS (Change and Transport System). The following section describes the software logistics options for the corresponding SQLScript procedures.
You can create the procedures for each system in your system landscape using the SQL console in the SAP HANA studio or using transaction DBACOCKPIT in the BW system as SAP HANA catalog objects. In the software, this option is only supported by syntax highlighting in the SAP HANA studio, but it is also very simple and direct. Note however that every change to the implementation of a procedure must be replicated manually in all other systems in your system landscape.
You can create and activate the procedure as a SAP HANA repository object in the development system. (The activated object is then in the DB schema _SYS_BIC.) This allows you to use the SAP HANA software logistics functions to provide data to downstream systems. This option involves a considerable amount of configuration in order to set up a workable development environment in the SAP HANA studio. It is often worth the extra effort though, as you receive better system support and can use Lifecycle Management for SQLScript procedure implementations in SAP HANA.