Native SQL Procedure inside ABAP code

[ullas_u2]

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.

[franois_henrotte]

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.