topic Re: steps to create a view in Application Development and Automation Discussions

steps to create a view

Former Member — Wed, 15 Apr 2009 12:06:20 GMT

<<Don't offer rewards>>

Hi All,

I am a BI Consultant, can any one please help me to create a view for these fields.

ROCANCEL

VBELN

ANGDT

AUART

AUGRU

BNDDT

BUKRS

ERDAT

FAKSK

HWAER

KUNNR

KURST

KVGR1

KVGR2

KVGR3

KVGR4

KVGR5

LIFSK

PVRTNR

STWAE

VBTYP

VDATU

VKBUR

VKGRP

VKORG

VTWEG

WAERK

SPARA

VGTYP_AK

ANZAU

PERIV

please explain me with steps

Appreciate your answers <<Text removed>>

Regards

Santosh

Edited by: Matt on Apr 16, 2009 10:13 AM

Re: steps to create a view

Former Member — Wed, 15 Apr 2009 12:14:56 GMT

Goto SE 11.

Choose the radio button of Views, give the view name and create.

Enter the short description and table names for which u want to create view.

Select the 2nd table-name field and click on relationship button.

Then goto view fields tab.

Select the table name and the fields u want to display.

Save and activate.

Re: steps to create a view

Former Member — Wed, 15 Apr 2009 12:15:09 GMT

Hi,

Go to Transaction SE11

Click on 'View' radio button and give view name (Ex. ZC_VIEW)

click on create

Give your table name in 'Table/Join condition' Tab

and select the fileds in 'View Fields' Tab

Save check and activate

Your view will be created.

Regards

Krishna

Re: steps to create a view

christine_evans — Wed, 15 Apr 2009 12:32:56 GMT

Read the SAP help. http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ecab446011d189700000e8322d00/frameset.htm

Re: steps to create a view

Former Member — Wed, 15 Apr 2009 12:43:00 GMT

Hi,

Plz chk the below links.

http://help.sap.com/saphelp_nw2004s/helpdata/en/a3/5a693c114bf147e10000000a11402f/content.htm

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

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 "Maintenance View"

4) Click on "Copy" button.

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

6) If U are using the tables LIPS, VBAK, LIKP, MBEW (for eg.), 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.

Regards,

Himanshu

Re: steps to create a view

Former Member — Wed, 15 Apr 2009 12:43:51 GMT

use this link

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

~linganna

Re: steps to create a view

Former Member — Wed, 15 Apr 2009 13:39:06 GMT

Hi Santosh,

Table Maintanance Generator are used to view ,modifi tables,Insert table values.

T-code:-SM30 Maintain tabel views .

SE54 Generate Table Maintenance Dialog: Initial table/View Screen .

SE55 Generate Table Maintenance Dialog: generation Environment .



Steps-to-create-Table Maintanance Generator
 
-->Create view in SE11
-->Goto transcation SE11 ABAP Dictionary 
-->Select View and type in the name of the view you want to create. 
-->Press the Create button 
-->In the dialog box that appears, choose Maintenance View 
-->Select tables and fields for the view 
-->Activate the view 
 
OR 
-->Create view in SE11
-->Goto transcation SE11 ABAP Dictionary 
-->enter table name
-->go to Utilities
-->select table maintainance Genarator
-->Enter single step
--> enter Function Group or same table name (all the code for Table mainaitenace is stored here)
-->eneter single step
-->enter Authorization gorup(we can restrict some user,s not tot update data)
 
Activate..

Reagrds,

Prabhudas