FM :- reading the program for the database links

[Former Member]

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

[Former Member]

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.

or

Check the table D010TAB.

Regards,

Selva M

[Former Member]

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

[kesavadas_thekkillath]

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

[Former Member]

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.

or

Check the table D010TAB.

Regards,

Selva M

[Former Member]

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

[ThomasZloch]

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

[Former Member]

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.

[Former Member]

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.