steps to create a view

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[christine_evans]

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

[Former Member]

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

OR

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

[Former Member]

hi

use this link

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

~linganna

[Former Member]

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