Steps to create a View..

[Former Member]

Dear Gurus,

plz help me how to create a help & maintanace view.

Plz tell me the steps....

[Former Member]

hi,

Help View.

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

Maintenance View

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

______________________________________________________________________________

Creating Help Views

Procedure

Enter an explanatory short text in the field Short text.

You can for example find the view at a later time using this short text.

Enter the primary table of the view under Tables in the Tables/Join conditions tab page.

Only tables that are linked with the primary table (indirectly) with a foreign key can be included in the view.

Save your entries.

You are asked to assign the help view a development class. You can change this development class later with Extras ® Object directory entry.

If required, include more tables in the view. In a help view you can only include tables that are linked to one another with foreign keys.

Position the cursor on the primary table and choose Relationships. All existing foreign key relationships of the primary table are displayed. Select the foreign keys and choose Copy. The secondary table involved in such a foreign key is included in the view. The join conditions derived from the foreign keys (see Foreign Key Relationship and Join Condition) are displayed.

You can also include tables that are linked with a foreign key to one of the secondary tables already included. To do this, place the cursor on the secondary table and choose Relationships. Then proceed as described above.

For maintenance and help views, there are certain restrictions on the foreign keys with which the tables can be included in the view (see Restrictions for Maintenance and Help Views). The foreign keys violating these conditions are displayed at the end of the list under the header Relationships with unsuitable cardinality.

On the View fields tab page, select the fields that you want to copy to the view. The key fields of the primary table were automatically copied to the view as proposals.

Choose Table fields. All the tables contained in the view are listed in a dialog box. Select a table. The fields of the table are now displayed in a dialog box. Select the required fields in the first column and choose Copy.

On the Selection conditions tab page, you can (optionally) formulate restrictions for the data records to be displayed with the view (see Maintaining Selection Conditions for Views).

The selection conditions define the data records that can be selected with the view.

Siva

[Former Member]

Hi Ullas,

Please check this link

Creating Maintenance Views

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

Creating Help Views

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

Best regards,

raam

[Former Member]

Hi Ullas,

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.

Award points in order to say thanks.

Regards,

Kiran

[Former Member]

Dear Kiran,

I followed th e steps u listed...but after the 6th step, Im getting a status message that 'Tables in Help View must be linked via Foreign Key' and Im able to enter th 2nd table..

plz help me..

Ullas U