Native SQL Procedure inside ABAP code

ullas_u2 — Fri, 12 Nov 2010 11:49:29 GMT

Dear All,

On debugging the standard SAP program /SAPAPO/BOP; I found a native SQL stored procedure has been called (inside EXEC SQL...ENDEXEC block). Inside this block some parameters are passed to the procedure and some others has been returned after processing inside the block.

The procedure name is "APS_ORDER_GET_DATA".

I need to know the way to check the underlying code that has been written for this procedure or I need to know the logic/purpose of this procedure.

My problem is; I found that in one of the returning parameters (internal table), found one record is missing and I need to know the reason.

Can anybody help..?

Regards

Ullas.

Re: Native SQL Procedure inside ABAP code

franois_henrotte — Mon, 29 Nov 2010 16:26:44 GMT

you have to execute some DB statement to get the code of stored procedure

the statement depends on your DB system

for example, Oracle :

SELECT line FROM all_source WHERE name=u2019MY_STORED_PROCu2019 ORDER BY line

put it also inside a EXEC / ENDEXEC.

topic Re: Native SQL Procedure inside ABAP code in Application Development and Automation Discussions

Native SQL Procedure inside ABAP code

Re: Native SQL Procedure inside ABAP code