topic Re: which table for which programs in Application Development and Automation Discussions

which table for which programs

Former Member — Wed, 26 Dec 2007 07:31:57 GMT

i need to delete the tables and programs in sap i have no idea how to check if the programme is been deleted how to find and delete the certain tables in the sap i know the table names but how to find out the tables for certain programs, because i am going to delete the content in the package entirely so i need help in this.

Re: which table for which programs

Former Member — Wed, 26 Dec 2007 07:35:17 GMT

hi,

Since you know the table names,

go to where used list of tables and see whether it is used in the program or not.

Re: which table for which programs

Former Member — Wed, 26 Dec 2007 07:36:19 GMT

i am talking about the custom programs.

Re: which table for which programs

Former Member — Wed, 26 Dec 2007 07:50:53 GMT

hi,

You can goto Se80 tcode and provide your development class name by choosing Development class from dropdown list.

Here you will get list of table names( under dictionary objects-->Database tables ),transaction codes,include program names.

then you can check where ztable is used in zprograms using where used list.

You can delete whichever you dont need further.

Regds

Sivaparvathi

Please reward points if helpful...

Re: which table for which programs

Former Member — Wed, 26 Dec 2007 08:01:29 GMT

DD02L Table contains the SAP Tables.

DD02T Table contains the SAP Table Texts.

DD01L Table contains the Domains

DD01T Table contains the Domain Texts.

DD03L Table contains the Table Fields.

DD03T Table contains the Table Field Texts. (Language Dependent)

DD04L Table contains the Data Elements.

DD04T Table contains the Data Element Texts.

DD05s Table contains the Foreign Key Fields

Rewards if useful.