topic Which SAP table stores the ABAP program Source Code in Application Development and Automation Discussions

Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 19:07:09 GMT

Hi All,

Which SAP table stores the ABAP source code .

Is it possible to retrieve the abap program code from database table

wherein it is stored .

Scenario :

In our project SAP got decommissioned and SAP database is migrated to Oracle . As SAP is decomissioned , we are not able to access the SAP frontend . But we need a program code to service a request . Is it possible to retrieve the program code from the database

which is migrated to oracle .

Thanks

Shikha

Re: Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 19:40:01 GMT

hi check the table REPOSRC ..give the name of the program name ---see the code..

regards,

venkat.

Re: Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 19:44:23 GMT

You must do it like this...


DATA: BEGIN OF SOURCE_TABLE OCCURS 0,
      LINE(150) TYPE C.
DATA: END OF SOURCE_TABLE.

DATA: NAME LIKE TRDIR-NAME.

NAME = 'Z_PROGRAM'.

READ REPORT NAME INTO SOURCE_TABLE.

LOOP AT SOURCE_TABLE.
WRITE:/ SOURCE_TABLE-LINE.
ENDLOOP.

Greetings,

Blag.

Re: Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 19:46:08 GMT

Thanks for your reply. But the table REPOSRC does not exist in SAP database . I am using SAP 4.6 Version .

Does this table exist in higher version ?

Can we get the program code by any other table / or by any other means through database . Sap database is migrated to oracle 10g.

Thanks

Shikha

Re: Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 19:59:12 GMT

Hi ,

Thanks for your reply .

But as SAP is decommissioned , we are not able to access SAP Frontend .SAP database is migrated to oracle 10g . I am looking for table where SAP program source code is stored so that it can be retrieved from the database table if possible .

Thanks

Shikha

Re: Which SAP table stores the ABAP program Source Code

RichHeilman — Mon, 28 Apr 2008 20:03:33 GMT

This is an interesting question as the answer is may be different depending on your version. For example, in new releases the table REPOSRC appears to hold a compress version of the course code in the DATA field, but you would need to be able to decompress it if trying to read this directly out of the DB. I would assume that it uses gZip to do the compression, and there are ABAP utilities built in to do the compress/decompress. Of course you can always read the source code by using the READ REPORT statement in any release, but of course this will not help you if you can not log on to your system. Basically, if you system is corrupt for some reason, the best option is to restore from a backup.

REgards,

Rich Heilman

Re: Which SAP table stores the ABAP program Source Code

Former Member — Mon, 28 Apr 2008 20:59:53 GMT

Is there any other table where report source code is stored in SAP

in lower versions(i.e 4.6 and lower versions) other than REPOSRC.

There are few tables which just gives the information about the program code but i am still not able to get source code of program .

It will be very helpful if someone can suggest some means of retrieving the abap code from SAP table .

Thanks

Shikha

Re: Which SAP table stores the ABAP program Source Code

Former Member — Thu, 01 Oct 2009 18:02:29 GMT

Hi Jain,

We are trying to do the exact same thing of decommissioning SAP and migrating just the data base to Oracle 11g.

Can you share the steps that you followed for decommissioning SAP?

Thanks in advance!!

Shankar