Friday, 17 June 2016

Maintenance Views


  • Maintenance Views give a business oriented view of the data and at same time allows you to maintain the data.
  • Maintenance Views are more like Database views where you have specify the foreign key relationship between the tables. The foreign key relationship should exist between the tables i.e. data from several tables can be presented to in Maintenance view collectively.
  • All the tables used in the Maintenance View should have a foreign key relationship.
  • Using Maintenance View insertion , deletion , modification of  records is possible.



Ex :

Steps :


  • Go to Transaction Code SE11.

  • Click the view radio button.

  • Enter the View name Start's with Y or Z<View name > and click on create.

  • Pop-up will appear. Click on Maintenance View and click on Copy button.

  • Click on continue.

  • Enter the short description.
  • Ex  : VBRP.

  • Records are,

  • Ex : T000.

  • Records are,

  • Enter the table name .
  • Click on Relationships Button.

  • Select the related table and click on copy button.


  • Click on View fields Tab.
  • Click on Table fields Button to select require Fields.
  • Select the table name and click on choose.
  • Select the required fields.
  • Click on Copy button.


  • Click on Table Fields button.
  • Select another table.
  • Select the fields and click on copy.
  • Selected fields are,

  • Click on Maintenance Status Tab.
  • Save -> Check -> Activate.

  • Maintenance View is also known as Table Maintenance Generator ( SM30 )
  • Utilities -> Table Maintenance Generator.

  • Initial screen,

  • Enter the Authorization group. 

  • Enter function group name.



Maintenance Screen


  • There are 2 types.
  1. One Step :- Display and change in same screen.
  2. Two Step : - Display and change in different screens.

One Step

  • Select Maintenance type as one step  .
  • Click on Find Screen Number (s).

  • Select proposed screen numbers and click on continue button.
  • Screen number,
  • Click on create button.
  • Save it either in Package or Local Package.

  • Status Bar,

  • Click on back button.

  • Click on Contents Button.


Output



To edit records

  • Click on Edit option.
  • To modify record
  • Click on Save button.
  • To insert  a  record / records.
  • Click on New Entries Button.

  • Enter a record / records and click on save.
  • To delete a record .
  • Select a record and click on delete .


To delete Table Maintenance  Generator .

  • Utilities -> Table Maintenance Generator.
  • Click on delete option.

  • Click on Continue.


Two Step

  • Click on Maintenance type : Two step
  • Click on Find Screen Numbers.
  • Click on Propose screen numbers.

  • Screen numbers are,

  • Click on create button.
  • Save it in either Package or Local Package.
  • Status,
  • Click on Back button.


Output


  • To Edit Click on Edit button.

  • To modify record
  • Click on Save button.
  • To insert  a  record / records.
  • Click on New Entries Button.

  • Initial screen,

  • Enter a record / records and click on save.
  • To delete record / records.
  • Select the record and click on delete.




  • Status,


                                       more information.....

No comments:

Post a Comment