Which SAP table stores the ABAP program Source Code

[Former Member]

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

[Former Member]

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

regards,

venkat.

[Former Member]

Hi

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

[Former Member]

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.

[Former Member]

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

[RichHeilman]

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

[Former Member]

Hi

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

[Former Member]

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