‎2005 Dec 26 9:14 AM
Hi Experts,
I am going to create a report using <b>Views</b> concept.
I don't know about Views concept. How i have to create view. how can i use the same in program for more than one table.
Please send me a sample code.
I hope that i will get answer soon.
if u feel free send your answers to my id nemalapp@bsci.com
Thanks & Regards
Prabhakararao
‎2005 Dec 26 9:28 AM
go to SE11 and click on the view radio button. click create and u get 4 type of views. select database views. database views are created using "INNER JOINS".
in "table/joins conditions " screen, give the two table names which you to join using views.And then in "view flds" tab, give the field names u want to use.
hope this is clear.
if any doubts u can mail.
regards,
Madan..
‎2005 Dec 26 9:18 AM
Hi prabhakara,
1. Views
U can create them thru se11.
2. In views, u can use
one table, or more than one table
and link them with common fields.
(Do not forget to take into consideration
MANDT field)
3. U can use them in abap sql
just like any other table name.
I hope it helps.
regards,
amit m.
‎2005 Dec 26 9:20 AM
u can create view in SE11
click on view radiobutton .u need to have the access key to create.
‎2005 Dec 26 9:28 AM
go to SE11 and click on the view radio button. click create and u get 4 type of views. select database views. database views are created using "INNER JOINS".
in "table/joins conditions " screen, give the two table names which you to join using views.And then in "view flds" tab, give the field names u want to use.
hope this is clear.
if any doubts u can mail.
regards,
Madan..
‎2005 Dec 26 11:04 AM
Hi here are the steps.
go to se11. create the view by considerings fields from more than one table.
consider MANDT also for this.
then write select statements over this view.
Satish