topic For maintenance view in Application Development and Automation Discussions

For maintenance view

Former Member — Mon, 12 Dec 2005 22:12:43 GMT

Hello Guys,

For this view it is asking only one table name

how it is possible to make a view.

Try to give some information regarding views.

Re: For maintenance view

Former Member — Mon, 12 Dec 2005 22:28:34 GMT

The views is a logical view of a dictionary table, they are used to update/show a part of the data of one or more tables.

For example you have two table Z1 and Z1T (where there are the descriptions of the keys of Z1):

Z1:

MANDT (key field)

FIELD (key field)

Z1T:

MANDT (key field)

SPRAS (key field)

FIELD (key field)

DESCRIPTION

so you can create a maintenance view Z1V to update simultaneously the data of Z1 and Z1T. After you can create a program by generatore maintenance view to manage Z1V.

See here for more details:

http://help.sap.com/saphelp_46c/helpdata/en/4f/991f82446d11d189700000e8322d00/frameset.htm

Max

Message was edited by: max bianchi

Re: For maintenance view

Former Member — Mon, 12 Dec 2005 22:40:50 GMT

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

Place the cursor on the primary table and choose Relationships. All existing foreign key relationships of the primary table are displayed. Select the required foreign key and choose Copy. The secondary table used in such a foreign key is included in the view. The join conditions derived from the foreign keys are displayed."

Say, MARC and MARA. Enter Primary table as MARC, and then click "Relationships". It gives U the list of foreign key relations. Select MARC with MARA, and U can see both the tables are included in the Maintenance view. Hope this helps.