topic Re: Finding the DB Table in Application Development and Automation Discussions

Finding the DB Table

Former Member — Sat, 02 May 2009 06:32:45 GMT

hi Guys ,

VBMTV is a structure i have to find out the corresponding table .. how to find the corresponding table

can any give the solution for this ,,

Regards,

Y Ravichandra.

Re: Finding the DB Table

Former Member — Sat, 02 May 2009 06:33:59 GMT

check with the Where used list of that structure with the database tables checkd.

Re: Finding the DB Table

Former Member — Sat, 02 May 2009 06:47:33 GMT

Thanks for reply , I have checked but its saying not found in the Data base

Re: Finding the DB Table

Former Member — Sat, 02 May 2009 06:56:39 GMT

It is a strucure which is used by stadard SD FMs. It will not directly apppend to any DB table. It will update the data or read the data to/from different DB tables like Sales Document: Header Data(VBAK),Sales Document: Item Data and Sales Document: Business Data(VBKD).

Thanks and Regards,

Re: Finding the DB Table

Former Member — Sat, 02 May 2009 06:57:13 GMT

Hi,

so that structure is nowhere using in your database.

Thanks..!!

Re: Finding the DB Table

Former Member — Sat, 02 May 2009 21:30:50 GMT

Hi,

It doesnt have any TABLE in the database.

in which scenario and what kind of data is to be stored..

Will u elaborate ur requiremnet.

Thanks and Regards,

Re: Finding the DB Table

Former Member — Mon, 04 May 2009 04:12:28 GMT

Hi,

ISI_VBMTV_TT is the Table type for the Structure VBMTV.

Regards,

Vijaya Lakshmi.T

Re: Finding the DB Table

Former Member — Mon, 04 May 2009 05:18:41 GMT

Hi ,

Structure VBMTV is not used directly in any table .

But a few function modules and programs are using thisstructure.

FM SD_SELECT_SALES_ORDERS_WWW using the the fields of the structure of VBMTV ,

select records from the table like - - VBKA , VBFA etc.

To get more information use the where used list as described in the other posts.

Regards

Pinaki

Re: Finding the DB Table

Former Member — Mon, 04 May 2009 05:34:23 GMT

Hi,

Find out the primary key fields in structure and then do "where used" on those fields, you will definitely find the table.

Re: Finding the DB Table

Former Member — Mon, 04 May 2009 09:57:39 GMT

Hi,

First see the structure through se11 double click on data element of the field. now you are in data element screen. Now drop your cursor on the domain name and select the where used list which is there on your application tool bar . Now a new window will appear . Check the table field check box and enter now you will get all the tables regarding that field.

Regards,

Himanshu

Re: Finding the DB Table

Former Member — Tue, 05 May 2009 08:36:54 GMT

find out with "Where used list" of that structure with the database tables check box selected.

Regards,

Joan

Re: Finding the DB Table

Former Member — Wed, 06 May 2009 06:10:04 GMT

Hi,

You can use "Where Used List" for knowing about the DB Table.The another way is you can use the se11 transaction and know about about that particular field and with the help of that you can chose the DB table.

Thanks & Regards,

Dhanalakshmi.

Re: Finding the DB Table

SujeetMishra — Wed, 06 May 2009 06:53:04 GMT

Dear Ravichandra,

please use where used list for the primary key field and that will be your table name.

Have a Nice Day,

Regards,

Sujeet

Re: Finding the DB Table

Former Member — Wed, 06 May 2009 07:58:10 GMT

Hi,

You can find out from 'Where-used list'.

Regards,

Jyothi CH.