03-30-2009 4:02 PM
If we know the table name is there an easy way to find out what transaction is used to maintain it?
For e.g. VBAK is maintained by VA01.
What about SKAT?
I am sure someone here knows what table SKAT is maintained using but everynow and then I find myself in a situation where I know the table and not the transaction so I would like to find out an easy way to do so.
03-30-2009 4:11 PM
03-30-2009 4:09 PM
Hi,
You can do this way
1) Identify the Package by opening the Table in SE11, Menu > Goto > Object Directory
2) Go to SE80 give the Package name and check for the Tables Folder and Transactions folder
It will give what all the Tables associated with that package and the transaction used in that packages which filles the related tables.
Regards
Bala Krishna
03-30-2009 4:10 PM
hi ,
go to SE16>table name ( DD25V)>Enter primary table name as (SKAT)-->enter AGGregate as (V) in the selectopn screen
you get the view name from above results..
next go to tabble->TSTCP>Enter View name as ( /SM30 VIEWNAME=(tablename),UPDATE=X )
from above results you can get the t-code related to table name
Regds / Prabhudas
03-30-2009 4:11 PM
03-30-2009 4:17 PM
...but to know it
To the OP, how about understanding the purpose of the table (e.g. by looking at the table description or contents), then finding it in the SAP menu, maybe with the help of tx SEARCH_SAP_MENU, or use SE93 to scan for appropriate strings in the transaction name.
SKAT -> FS00 or FSP0.
Thomas
03-30-2009 4:25 PM
You got the right transaction, thanks for that.
But if I were to use SEARCH_SAP_MENU, there is no way I would have found the transaction.
SKAT - G/L Account Master Record (Chart of Accounts: Description)
FSP0 - Display G/L Account chart of acct data.
As you can see the relation is just not there.
03-30-2009 4:28 PM
Megan - even if you know the program, you may not be able to determine the tables it updates (or even uses).
Rob
03-30-2009 4:35 PM
More and more am getting inclined to that conclusion. But surely you see the usefulness of a solution to this, dont you. As programmers we are always looking at programs and tables and may not know the transaction that needs to be maintained. A lot of times clients are using new SAP talent to do the customization and they dont know the transaction. So if we could find out what transaction it corresponds to that would be great.
03-30-2009 4:42 PM
03-30-2009 4:50 PM
if you open SAKT in se11 and hit the where used list... all that programs are using the table.... pick the list of program names and hit TSTC table and provide them in the PGMNA, for proble list you will find the Transaction code... you can start search from them...
03-30-2009 4:53 PM
Jay,
When I do where used for SKAT, it returns 700 programs. It is too time consuming.
03-30-2009 4:56 PM
I don't think it would work anyway. Many updates are done by FMs that are called by update programs, but do not have transactions associated with them.
Rob
03-30-2009 4:56 PM
That's what Rob was suggesting... we cannot pin point on one transaction.... That's the fun of Tech development