Question Re: B4HANA SQL Script Execution in Technology Q&A

B4HANA SQL Script Execution

lakshminarasimhan_n4 — Fri, 30 Aug 2024 14:23:30 GMT

Dear All,

We have the B4HANA system and given below are the detail,

DW4CORE 200 0014 SAPK-20014INDW4CORE DATA Warehouse

Here i need to test some SQL Script and i am able to do it from DB02, but would like to know if there is any other way other than DB02 as this t-code or the "dbcockpit" tcode is not allowed in PRD B4HANA system. In such case we need the "SQL Editor" in PRD to test few scipts.

Re: B4HANA SQL Script Execution

roland_szajko — Mon, 02 Sep 2024 14:41:25 GMT

Hana studio
Program RSDU_EXEC_SQL

Roland

Re: B4HANA SQL Script Execution

Savio_Dmello — Tue, 03 Sep 2024 18:35:28 GMT

From GUI, DB02 is the only option. Alternative, you have to navigate from HANA studio/ Eclipse to execute SQL queries directly against the HANA database.

In SAP HANA Studio/ Eclipse: Navigate to the SQL Console by right-clicking on your system connection and selecting "Open SQL Console."

In SAP HANA Database Explorer: Open SAP HANA Database Explorer through the SAP Business Technology Platform (BTP) or the SAP HANA Cloud platform. Connect to your HANA instance. Use the SQL console to run your SQL queries.