Reg forms

[Former Member]

Hi ALL.

Is It possible to retrive the data from maintance-view?

If Yes how to retrive ?

[Former Member]

Hi

The data of a view is derived from one or more tables, but not stored physically. The simplest form of deriving data is to mask out one or more fields from a base table (projection) or to include only certain entries of a base table in the view (selection)

The base tables of the view must be selected in the

first step of a view definition. In the second step-, these tables must be linked by defining the join conditions. It is also possible to use the join condition from a foreign key defined between the tables .

In the third step, you must select the fields of the base tables to be used in the view. Selection conditions that restrict the records in the view can be formulated in the fourth step.

All the tables in a maintenance view must be linked with foreign keys, that is the join conditions for maintenance views are always derived from the foreign key

cannot directly enter the join conditions as for database views

Regards

Divya

[Former Member]

Hi,

As mentioned in the last post, create a maintainence view from SE11 transaction and then you would be able to get the data in the same way as that of a data base table.

Hope this helps!!

regards,

lalit