Finding the DB Table

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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,

[Former Member]

Hi,

so that structure is nowhere using in your database.

Thanks..!!

[Former Member]

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,

KC

[Former Member]

Hi,

ISI_VBMTV_TT is the Table type for the Structure VBMTV.

Regards,

Vijaya Lakshmi.T

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

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

Regards,

Joan

[Former Member]

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.

[SujeetMishra]

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

[Former Member]

Hi,

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

Regards,

Jyothi CH.