topic Re: FM :- reading the program for the database links in Application Development and Automation Discussions

FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 10:53:55 GMT

Hello gurus,

I have a situation in which i need to find out that a program is inserting or modifying data in how many database tables..

I think there is a FM for this ... can anybody please help me in this

regards,

khushy

Re: FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 11:02:48 GMT

I dont think you will find such a function module, Where as CDHDR & CDPOS tables would be the bset to tell you aobut this information.

However if you want to know for a specific table, you can make use of FM 'CHANGEDOCUMENT_READ' by passing the object class & table name.

Hope this helps.

Regards

Abhii

Re: FM :- reading the program for the database links

kesavadas_thekkillath — Wed, 15 Sep 2010 11:07:48 GMT

You can do a ST05 Trace and get it. I have not heard about any fm for this purpose.

Re: FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 11:07:58 GMT

HI,

Use function module GET_TABLES to get the number of tables used in a program. Program is ur input.

It gives you all the sap standard tables used in background and the tables you used inside the program.

Check the table D010TAB.

Regards,

Selva M

Re: FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 11:09:38 GMT

what about searching SDN? we had a thread with your answer today already.

Re: FM :- reading the program for the database links

ThomasZloch — Wed, 15 Sep 2010 11:29:20 GMT

you mean this thread:

Unfortunately non of the proposed solution works 100%, ST05 finds all actual DB accesses of the current run, other accesses that might occur when the same program is run under different conditions (selection criteria, etc.) are not found. The program environment analysis does not find DB accesses in called function modules, among others, and it gave me false alarms, listing internal table operations as DB operations.

Thomas

Re: FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 11:38:11 GMT

I agree with Thomas...solutions provided are not working properly ..Get tables is giving a very loonng list ... if i wnat to find that this program is inserting data in which tables then.... how ????

regards,

Khushy.

Re: FM :- reading the program for the database links

Former Member — Wed, 15 Sep 2010 11:40:19 GMT

ok you're right. Sorry for this one.

I didnt have a closer look into the thread i just saw that there were answers provided which didnt look too awkward.