topic Re: ABAP Views using in Programming in Application Development and Automation Discussions

ABAP Views using in Programming

Former Member — Mon, 26 Dec 2005 09:14:20 GMT

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

Re: ABAP Views using in Programming

Former Member — Mon, 26 Dec 2005 09:18:51 GMT

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.

Re: ABAP Views using in Programming

Former Member — Mon, 26 Dec 2005 09:20:24 GMT

u can create view in SE11

click on view radiobutton .u need to have the access key to create.

Re: ABAP Views using in Programming

madan_ullasa — Mon, 26 Dec 2005 09:28:42 GMT

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..

Re: ABAP Views using in Programming

Former Member — Mon, 26 Dec 2005 11:04:47 GMT

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