view creation

[Former Member]

hi experts

i want create view of vbrk, vbrp, vbak table. its posible if yes how pl explain.

[Former Member]

Hi,

You can create a view in T.Code SE11 for the mentioned tables.

Regards,

Sumant.

[Former Member]

Hi!

Of course it is possibe. Maybe the VBAK cannot be attached to the VBRK-VBRP tables easily.

Transaction SE11. Choose view radio button, enter a name (Z...) then click on create.

Choose database-view.

Define the table join

VBRK_{VBELN = VBRP}VBELN

To attache the table VBAK, you have to use the VBFA table (document flow) like this

VBFA_{VBELN = VBRP}VBELN AND

VBFA_{POSNN = VBRP}POSNR AND

VBFA_{VBELV = VBAK}VBELN

Check it out with some table entries and you will see the exact keys.

Regards

Tamá

[Former Member]

Hi Anil,

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.

Database views are implemented with an equivalent view on

the database.

Projection views are used to hide fields of a table (only

projection).

Help views can be used as selection method in search helps.

Maintenance views 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.

********Reward all the helpful answers.

Rgds,

P.Naganjana Reddy

[Former Member]

Hi Anil,

You can use SE11 Transaction.

You can create 'DATABASE VIEW'.

You need to link the fileld in VBRP,VBRK,VBAK for join conditions.

Reward if useful.

Thanks,

USR

[Former Member]

hi,

chk this.

Creating maintenance View:

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

Regards

Reshma

[Former Member]

Hi anil

http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm

for more detailed info look on:

http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+dictionary&;

[Former Member]

Hai,

A view is an aggregated dictionary object. Aggregate object or complex object are objects, which are created by using object. E.g., Table is created using data element and domain. A view is created using tables.

A view is an imaginary table or virtual table. Using one or more tables can create a view. Physically, view does not contain any data. The view is filled dynamically during runtime.

View is mainly used to restrict or limit, access to information or data by employees, area, plant and so on. By using view, you can display information specific to a particular user or to their work or the information for which they have the right to access.

Types of Views

R/3 System offers following types of views:

• Database View: You can create this view on transparent table. It supports all the three operations like Selection, Projection & Join

• Projection View: This type allows you to suppress some fields from the transparent table. This view is defined only with relational operator projection.

• Help View: These views are exclusively used by the SAP help system. All relational operators are supported. These views are generated when the user presses F4 function key on the field on selection screen. You can see these views only with SAP help and not with open SQL statements.

• Maintenance View: This type of view enables the maintenance of a group of related tables using SM30 Transaction, which is for extended table maintenance.

Creating View

• From initial screen of data dictionary, enter the name of object i.e. view.

• Select view radio button and click on the push button.

• Dialog box is displayed for types of views.

• Select the view type.

• On the next screen, you have to pass following parameters.

• Short text

• In the table box you need to enter the table names, which are to be related.

• In join table box you need to join the two tables.

• Click on the TABFIELD. System displays the dialog box for all the table fields and user can select the fields from this screen. These fields are displayed in the view fields box.

• Save and Activate: When the view is activated, view is automatically created in the underlying database system. As long as the table exists in the database, the view also exists (Unless you delete it).

I hope this will help you out...

[Former Member]

Goto SE11 and select View -> Database View and mention your table names:VBRK, VBRP, VBAK.