Skip to Content
author's profile photo Former Member
Former Member

How to create view

How to create view , please tel me the steps

Thanks

Regards

Basu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:07 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:08 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:10 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 09:12 AM

    Hi,

    Go through this info.

    Four different view types are supported. These differ in the

    way in which the view is implemented and in the methods

    permitted for accessing the view data.

    <b>Database views</b> are implemented with an equivalent view on

    the database.

    <b>Projection views</b> are used to hide fields of a table (only

    projection).

    <b>Help views</b> can be used as selection method in search helps.

    <b>Maintenance views</b> permit you to maintain the data

    distributed on several tables for one application object at one time.

    step by step creation of Maintenance view:

    With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

    It can be set in transaction SE11 - Tools - Table maintenance generator.

    Table maintanance Generator is used to manually input values using transaction sm30

    follow below steps

    1) go to se11 check table maintanance check box under attributes tab

    2) utilities-table maintanance Generator-> create function group and assign it under

    function group input box. Also assign authorization group default &NC& .

    3) select standard recording routine radio in table table mainitainence generator to move table

    contents to quality and production by assigning it to request.

    4) select maintaience type as single step.

    5) maintainence screen as system generated numbers this dialog box appears when you click on create button

    6) save and activate table

    One step, two step in Table Maintenance Generator

    Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

    Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

    SM30 is used for table maintenance(addition or deletion of records),

    For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

    Sm30 is used to maintain the table ,i.e to delete ,insert or modify the field values and all..

    It creates the maintenance screen for u for the aprticular table as the maintenance is not allowed for the table..

    In the SE11 delivery and maintenance tab, keep the maintenance allowed..

    Then come to the SM30 and then enter the table name and press maintain..,

    Give the authorization group if necessary and give the function group and then select maintenance type as one step and give the screen numbers as system specified..

    Then create,,,

    Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

    We use SM30 transaction for entering values into any DB table.

    First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

    Then it will create a View.

    After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

    Hope this resolves your query.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.