Maintainence View-Data Selection

[Former Member]

Hi,

I need to update a table in Oracle with the SAP data.

The SAP data is in a maintainence View.When I try to select the data into an internal table ,I am getting an error message that tells that the corresponding View is not defined in the DB as a table ,projection view or database view.

Can we select data from a Maintainence View??

Thanks.

[Former Member]

HI,

YOU CAN SELECT DATA FROM MAINTANANCE VIEW

FOR FATCHING DATA YOU MUST USE DATABASE TABLES OR DATABASE VIEW.

MUKESH AGGARWAL

[Former Member]

Hi,

1.We cann't select data from maintenace view.It is just to update the data in database by enduser.

2.Only ,we can select data from Projection and Database views only.

Regards,

Shiva Kumar

[Former Member]

Hi,

check this

MAINTENANCE VIEWS:

Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

Data that is distributed on more than one table often forms a logical unit, called an application object. You should be able to display, change and create the data of such an application object together. Users usually are not interested in the technical implementation of the application object, such as the distribution of the data on several tables.

You can maintain complex application objects in a simple way using a maintenance view. The data is automatically distributed on the underlying database tables.

All the tables used in a maintenance view must be linked with a foreign key. This means that the join conditions are always derived from the foreign key in the maintenance view. You cannot enter the join conditions directly as in a database view.

A maintenance interface with which the data of the view can be displayed, changed and created must be generated from the definition of a maintenance view in the ABAP Dictionary.

When the maintenance interface is created, function modules that distribute the data maintained with the view on the underlying tables are automatically generated.

The maintenance interface is generated with the Transaction Generate Table View (Transaction SE54) or from the view maintenance screen with Utilities -> Tab.maint.generator.

With thanks & regards,

Sravani yendru.