topic REGARDING VIEWS in Application Development and Automation Discussions

REGARDING VIEWS

Former Member — Fri, 29 Jun 2007 08:16:02 GMT

HI EXPERTS,

I HAVE TO CREATE A VIEW..tables which i am using are LIPS,VBAK,LIKP,MBEW..n fields are:

LIPS-WERKS,

LIPS-NTGEW,

LIPS-MATNR,

LIPS-VRKME,

LIKP-LFDAT,

VBAK-KUNNR,

MBEW-STPRS,

how can i create a view using these fields...plz sort it out..m in hurry

regards,

raman.

Re: REGARDING VIEWS

Former Member — Fri, 29 Jun 2007 08:24:09 GMT

hi if you want to use individually

use SE11 and create

http://help.sap.com/saphelp_nw04/helpdata/en/f5/35c83ecedc636be10000000a114084/content.htm

Rewards If Useful.

Re: REGARDING VIEWS

former_member404244 — Fri, 29 Jun 2007 08:29:18 GMT

Hi,

plz have a look at the below link..

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

Regards,

Nagaraj

Re: REGARDING VIEWS

Former Member — Fri, 29 Jun 2007 08:29:30 GMT

Hi Prakash,

From SE11 create the DB view and join the tables with the key fields

Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched.

Re: REGARDING VIEWS

Former Member — Fri, 29 Jun 2007 08:30:10 GMT

Hi Prakash,

1) Execute the transaction SE11.

2) Select "View" radio button and enter a name for a view (Ensure that the name starts with z....)

3) Now in a new list, select "Database View"

4) Click on "Copy" button.

5) in the new window, enter any short description about ur object

6) Since U are using the tables LIPS, VBAK, LIKP, MBEW, list them out under Tables on the left hand side in the tab (Table/Join Conditions).

7) Under the "joins" enter all the join condition that you have between these tables.

😎 Goto "View Fields" tab. Herein enter the fields that you want. Under the title "View field" - enter the name you would like to see, under "table" - enter the table name from which this field should get its data from; under "field" - enter the field name as it is in the table.

9)After entering them all, press enter.

10)goto "Selection Conditions" tab. here enter those conditions which you would have written in the where clause of the select statement.

11)perform syntax check

12)activate.

Thats it.

<b>Award points in order to say thanks.</b>

Regards,

Kiran

Re: REGARDING VIEWS

Former Member — Fri, 29 Jun 2007 09:05:19 GMT

hi kiran,

thanx for ur reply..but i dont know how cud i define these join conditions...can u plz guide me by giving an example related to the fields i hav mentioned...

regards,

prakash