DatabaseTables for Procedures in SAP(Native Sql)

[Former Member]

Hi guys,

How can we find the procedures in SAP and what is the database table for find the procedures in SAP Native SQL.

valid point will be rewarded.

Reg,

Hariharan

[Former Member]

Hi

I think it depends on your database server, Oracle or Sql Server

For SQL SERVER

the tables for procedures are

MSSPROCS

MSSSOURCE

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Hi hariharan,

1. In R/3 backend, ie. oracle/sql/others,

no procedures are stored by sap for r/3 functionality.

2. ie. sap does not use procedure concept of database.

it does everything from the front-end application.

regards,

amit m.

[Former Member]

Hi guys,

i have gone through the F1 help of the SAP for the procedure Command in that they have mentioned clearly that An <b>SAP Table at the back end</b>.

if you <b>double click the procedure</b> Name in the ABAP Program it will through you an<b> message saying that no link found</b>, so there will some storage area for the procedure present in the ABAP program.

what my thinking is there will a <b>SAP Table which hold the Program for the Procedure present in the table</b>, i wnat to know that table name for the APO Module.

Reg,

Hariharan.