table view in se11

[Former Member]

Hi all,

how to create table view in se11 (example please), and is it necessary to create Ztable for view or I can create

view for 2 tables eg. VBAK and VBRK.

points....

[Former Member]

Hi,

Yes you can create using existing tables like VBAK, VBAP.

Goto SE11 and click on the radiobutton "Views" , enter the name and say create and select "Database view".

Then enter the tables to be joined and specify the fields and all.

Thanks & Regards,

Navneeth K.

[Former Member]

Hi,

Hi no issues you can go ahead creating the view.

Check the below link for your assistance.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm

Cheers!!

VEnk@

[former_member404244]

Hi,

Generally we don't create view for a ztable..

u can create views using existing tables (U can do for ztables also)Goto SE11 "Views" , enter the name and say create and select "Database view".

Specify the fields and in the join conditions specify which tables u want to join..

Regards,

Nagaraj

[Former Member]

Hi,,,

Yes you can create views for these 2 tables,, and include wat ever fields you want in your view from these 2 tables......

(1)- enther your view name in se11, click create then it will ask

for type of view then tick database view,, then click enter...

(2)- enter short descp,,,, on left hand side specify the table name youw want to use..... on right hand side specify the fields name from the table which are common in both table.

(3)- then click on view field tab,,,,, and enter the fields which you want in your view.......

donot forgot to activate your view....

thanks

saurabh