topic Re: DatabaseTables for Procedures in SAP(Native Sql) in Application Development and Automation Discussions

DatabaseTables for Procedures in SAP(Native Sql)

Former Member — Fri, 03 Aug 2007 07:21:38 GMT

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

Re: DatabaseTables for Procedures in SAP(Native Sql)

Former Member — Fri, 03 Aug 2007 07:27:07 GMT

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

For SQL SERVER

the tables for procedures are

MSSPROCS

MSSSOURCE

Reward points for useful Answers

Regards

Anji

Re: DatabaseTables for Procedures in SAP(Native Sql)

Former Member — Fri, 03 Aug 2007 08:38:50 GMT

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.

Re: DatabaseTables for Procedures in SAP(Native Sql)

Former Member — Fri, 03 Aug 2007 10:41:41 GMT

Hi guys,

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

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

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

Reg,

Hariharan.