cancel
Showing results for 
Search instead for 
Did you mean: 

How to find database table name

former_member214272
Contributor
0 Kudos

Hi,

How to find the data base table name from

Technical Information for UI Element

For e.g. We have follwing Information, We have to Find out the data base table and filed name.

General Information About the Application and Component

Application: CPROJECTS

Web Dynpro Component: DPR_DOCUMENT

Window Information: WI_DPR_DOCUMENT

View Information: VI_TREE

Our Problem is

Is there any way , we can trace delete folder From Document tab page with there details For E.g. date and time and name of person who delete the folder from Document tab page.

We check it From change tab page but this option is not available.

Thanks

Sunil

Accepted Solutions (0)

Answers (1)

Answers (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

Becuase WDA uses MVC, there are several layers of abstraction between the UI and the database. The technical information in the screen will never directly tell you the database table. It tells you the name of the context that the information is bound to. The context may be derived directly from the underlying database, created based upon a DDic Structure or View, or defined directly in the WD tool. Furthermore, the actual access to the database should not be within WDA anyway. It should always be within a model object - which is usually the assistance class or some service call.

I suggest that you perform a SQL Trace during the running of the transaction. This will show you all the tables that were read from or written to during the transaction.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d1/801f89454211d189710000e8322d00/frameset.htm