Question on Database Tables

[Former Member]

Hi,

I have a few fields like below:

STRNO

TPLKZ

FLTYP

PLTXT

STORT

SWERK

KOSTL

IEQUI

TPLMA

All the above fields belong to one or the other tables in PLM.

Question ?

I have to do data extraction from the respective tables.

How do i find out exactly which physical table(database table) is holding the data of these fields?

Please mention the steps for identifying the database table using the field name.

Thanks & Regards,

Vijay

[seshatalpasai_madala]

Hi,

You can some results as follows

1) Goto Field's data element.

2) On data element click where-used-list there in the screen select Table fields.

3) Then check if this is key field of the table if not see if the field has any foriegn ky assignment,

Regards,

Sesh

[Former Member]

Hi,

Thanks for the information.

Could you please tell me in detail how to do it?

1) Goto Field's data element - How to do this?

2) On data element click where-used-list there in the screen select Table fields - How to do this?

3) Then check if this is key field of the table if not see if the field has any foriegn ky assignment - How to do this?

Please help me. It is urgent. As i am a beginner in SAP, i am finding it a bit difficult.

Thanks & Regards,

Vijay

[seshatalpasai_madala]

Hi,

In which Transaction you are seeing these Fields.

If you are seeing these fields in SE11, then for each field there will a Data type which in most cases will be a Data element.

So if you click on the name of that Data type you will be taken to Data Element.

There on the application toolbar you will have this button "Where Used List"

Use this button in the Pop-up screen that comes up Select the check box

" Tables".

Then the result will show you all the tables where this Data element is used.

Then You can click on each table and see if this Data element's field is KEY.

Check box "Key" will be checked.

Other process is

Once you are in the Data element, goto its properties tab.

CLick on the Package name.

Goto the package and check the Dictionary Objects in this Package.

In the Dictionary objects check for Database Tables.

Regards,

Sesh

[Former Member]

goto se80

|

click on repository information system

|

expand ABAP Dictionary

|

expand fields

|

double click on table fields

on the right side of the screen enter the fieldname/description of the field and press execute to find the tables where the field is present. once you get into one table you can know the others by clicking on the where used list.

regards,

srinivas

<b>*reward for useful answers*</b>