topic Re: TABLES in Application Development and Automation Discussions

TABLES

Former Member — Fri, 25 Nov 2005 08:21:00 GMT

i need to find tables & their field names corresponding for these structure

struct name field name

RV45A KWMENG- Quantity

KOMPAX NETWR- Net value for the lineitem

CAUFVD GSTRP/GLTRP

Reply imm

Re: TABLES

Former Member — Fri, 25 Nov 2005 08:24:08 GMT

Hi,

Go to SE84

than ABAP Dictionary -> Fields.

Enter your field name there.

Regards,

Amey

Re: TABLES

Former Member — Fri, 25 Nov 2005 08:31:58 GMT

Using SE11 also you can Get the Field Names.

regards

vijay

Re: TABLES

christian_wohlfahrt — Fri, 25 Nov 2005 08:38:27 GMT

Hi!

It would be easier, when you mention a transaction (because structures can be used in many transactions, which book in different tables).

I guess, you have contracts or sales orders. Net value is then stored in VBAP-NETWR, also some amounts are stored in VBAP.

CAUFVC can be linked to orders with table AUFK. There are some dates (e.g. IDAT1), but I'm not sure if this matches your search.

Regards,

Christian

Re: TABLES

sridharreddy_kondam — Fri, 25 Nov 2005 08:39:31 GMT

Hi,

Go to SE11 --> enter the required table and Display...

There u can search/get u r required fields..

Regards,

Sridhar reddy

Re: TABLES

christian_wohlfahrt — Fri, 25 Nov 2005 10:10:22 GMT

Hi,

just found the two dates in AFKO.

Christian

Re: TABLES

abdul_hakim — Fri, 25 Nov 2005 10:13:26 GMT

Hi,

Do SQL Trace in the corresponding transaction you will get it...

Regards,

Abdul

Re: TABLES

Former Member — Fri, 25 Nov 2005 15:25:46 GMT

You have to specify the transaction/program/screen in which you are seeing these fields. Sometimes, the same structure fields can be used in different transaction screens and hey may end up in different tables.

Srinivas

Re: TABLES

Former Member — Fri, 25 Nov 2005 15:36:31 GMT

Go to SE11, display the structure say RV45A. Once the fields are displayed, click on the field & click on the Where-Used icon. This might give you what you need.

The other crude way is to go to table DD03L (Tables & Field names), put in KWMENG in the fieldname column & search. It will return you all the tables where KWMENG is used.

I personally think the first approach will help you.

Re: TABLES

Former Member — Fri, 25 Nov 2005 15:58:51 GMT

Hi,

Why dont you have where use list for the same in SE11.