Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DatabaseTables for Procedures in SAP(Native Sql)

Former Member

‎2007 Aug 03 8:21 AM

0 Kudos
120

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

3 REPLIES 3

Former Member

‎2007 Aug 03 8:27 AM

0 Kudos
89

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

‎2007 Aug 03 9:38 AM

0 Kudos
89

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

‎2007 Aug 03 11:41 AM

0 Kudos
89

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.