topic Re: VIEWS in Application Development and Automation Discussions

VIEWS

Former Member — Tue, 19 Jun 2007 09:34:27 GMT

Hi All,

Can u tell me in which database table the table names that were used in the views are stored???

Former Member — Tue, 19 Jun 2007 09:44:19 GMT

TVDIR stores the tables and views which has table maintainance generator.

We can create table maintainance generator using sm30 TCODE.

If you create table maintainance generator for your table then there will be an entry of your table in TVDIR.

anversha_s — Tue, 19 Jun 2007 09:47:18 GMT

hi,

Chk these tables.

DD02V
 "Date dictionary tables
 
DD03L
 "Date dictionary tables and fields

Rgds

Anversha

Former Member — Tue, 19 Jun 2007 09:51:12 GMT

hi,

all databse tables are stored in TADIR table and in REPOSRC structure. all views are stored in TRDIR table.

if helpful reward some points.

with regards,

suresh.

Former Member — Tue, 19 Jun 2007 09:58:55 GMT

good

TBTCO Job status overview table

TBTCP Batch job step overview

TVDIR View Directory

thanks

mrutyun^