Finding Table name from a srtuct.

[Former Member]

I need to find a trans tablefrom a given struc.I tried many ways but was not able to get it.Can anyone please help me out in findin the table name.And also tell me the different methods to find the table name.the struc i have been given is MEPO1320.

Thanks and regards.

Seema

[Former Member]

I need to find a trans tablefrom a given struc.I tried many ways but was not able to get it.Can anyone please help me out in findin the table name.And also tell me the different methods to find the table name.the struc i have been given is MEPO1320.

Thanks and regards.

Seema

[Former Member]

Seema,

Its not necessary that the strcuture is a part of the table or it is used as a INCLUDE in Tr. table. In this case I don't think you will find a table where the structure MEPO1230 is used.

What exactly are you trying to do?

Regards,

Ravi

[Former Member]

I need to use the open quantity field (obmng ) in a report.n this filed is present in the struc name specified.this name i got it trhu transaction me22n.

[Former Member]

Seema,

I don't think the data for this field is stored but it calculated at runtime. You need to find the delivered quantity for that line item from the delivery documents and subtract that from the ordered quantity.

You can find the delivery documents in LIKP table, or you can look at the doucment flow table VBFA.

Well as you are dealing with Purachaing, loop at EKET table.

I don't think there is any other way.

Regards,

Ravi

Note : Please mark the helpful answers

Message was edited by: Ravikumar Allampallam

[Former Member]

Hi,

Go to the struture and go to the object repository. You can find the names of the tables that are used in building the structure in Dictionary objects.

Thanks,

Rashmi.

[Former Member]

Check EKET table for

open Qty = EKET-MENGE - EKET-WEMNG.

[Former Member]

hai seema,

The table which store information about Structures and Tables are as follows:

DD02L - table properties

DD02T - table texts

DD03L - field properties

DD03T - field texts

to find specific fields if you know the structure's fieldname.

1) First, goto SE11, and enter your structure name. Goto the field that holds your data, and double-click on the element name. Once inside the element, do a where-used list for that element, searching tables only. Then go into each table, and see if you can find the one holding your data. There may sometimes be a huge number of tables displayed, but a lot of them will be empty.

2) Get the name of the program behind your transaction, goto SE80, and enter the program name. 99% of the time it will be part of a module-pool and bring up the pool. Goto the dictionary structures, and search each table there for the one holding your data.

3) Open a new session with transaction ST05, select SQL Trace, click on the Trace On button, and go back to your transaction (while leaving the session with ST05 open). Submit your transaction, and go back to the ST05 session. Click on the Trace Off button, then select the List Trace button. Continue with standard selections, and a BASIC TRACE LIST will appear. search thru the tables displayed under ObjectName.

hope this may be helpful.

regards,

praba.

[Former Member]

hi

good

you can use the reference table MEPO1320 which is having a filed named meins.It will help you to solve your problem.

thanks

mrutyun

[Former Member]

HI!

YOu can get Open Quanity as Formula Open Quantity = eket-menge-eket-wamng

But if you want to know other tables and structures which are used in program SAPLMEGUI then use T-COde AL21 ang specify here For External tables

[Former Member]

Take a look at this.. if you have a data element and if you want to find which tables is it being used in... then go to se11 and enter the data element you want to find in data element/data type field... then click on where-used list.. then click on INDIRECT APPLICATION and select database tables...

If you do this you will get a list of DB tables where this field is being used and think you can work your way up from there...

I learned this trick from some pdf and thought this is really worth sharing as it becomes really difficult sometimes to find where the data is really stored...

[Former Member]

Hi,

If you have a field name , Go to se80(object navigator).

U will find REPOSITORY INFORMATION SYSTEM.

Double click and u will find ABAP DICTIONARY.

again double click and u will find many options like (structure, field etc).

On clicking the resp area U will be able to input your reqd field which will give you the information like table name etc.

Hope U find this info helpful.

Thanx- sapna

[Former Member]

Hello Seema,

This is what u can do....

On the screen where the field MEPO1320 is displayed in ME22n, u start the debug by entering /h in the command box. then u can set a watch point on this structure-field name and restart the trx. With this the program will stop at the point where the watchpoint gets triggerd. This way u will reach a point where there is actual tranfer from trans. table or formula.

[Former Member]

Hi Seema,

1. Use the Where-user-list to track the structure.

2. If you know any program that the structure is using ..use ST05 to track it.

Regards,

Sunil

[Former Member]

hi,

go with se84 t code , in that go for abap dictionary, there go for fields,

in MEPO1320 get the fields u want and put those fields in field name,

and execute u will get the respective table choose the table u want with

respective to fields

regards.

Praveen