REGARDING VIEWS

[Former Member]

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.

[Former Member]

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.

[former_member404244]

Hi,

plz have a look at the below link..

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

Regards,

Nagaraj

[Former Member]

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.

[Former Member]

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

[Former Member]

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