topic Finding Table name from structure in Application Development and Automation Discussions

Finding Table name from structure

Former Member — Mon, 21 Nov 2005 22:28:26 GMT

Hi,

I need to find the trans. table name for the field ATP Quntity, It's coming from the Structure MDEZ field name MNG04. Please Help me guys??????????/

I tried where used list, it's giving 2 tables But both are not having any data. Please guide me is there is anyother way can i achieve this?????????

Re: Finding Table name from structure

Former Member — Mon, 21 Nov 2005 22:45:51 GMT

Try transaction SE15

Repository Information System --> ABAP Dictionary --> Fields --> Table Fields

Enter 'ATP quantity' for Short Description and execute.

Cheers,

Shyam

Re: Finding Table name from structure

Former Member — Tue, 22 Nov 2005 01:29:01 GMT

If you didn't get the field yet, you can try with SQL trace. Goto Transaction ST05 and switch on the trace. Now get back to your transaction and execute. Then goback to SQL trace and switch of the trace and display trace. Now you can find the list of tables used by transction in the SQL Trace displayed. Then you may need to go through these list of tables to determine the required table. please let me know if any further details are needed.

Thanks

Hari

Re: Finding Table name from structure

Former Member — Tue, 22 Nov 2005 02:51:19 GMT

I don't think ATP quantity is a specific table field value. It is a calculated value, that has life only in the transaction.

Srinivas

Re: Finding Table name from structure

Former Member — Tue, 22 Nov 2005 17:50:21 GMT

Hi Hari,

Thanks for ur help. Can i add Program manipulated field value into Search help display. B'cos in selection criteria we can only create view for tables. How i can display manipulated value that's not in table to display in Search help result screen?

I need to add extra display result in material field's Search help result screen like Stock on hand plant details.

thanks,

Subha

Re: Finding Table name from structure

Former Member — Tue, 22 Nov 2005 18:03:49 GMT

You can go to Table DD02L, enter MNG04 as the FIELDNAME. You will get some values, but I think all of them are structures. You can perhaps then find out where these structures are used.

I think this field is a temporary field used in MRP calculations & so it might be unlikely that you a corresponding table.