Unlocking SAP Views: Navigating Maintenance Views and Help Views in Your Database Journey

 Welcome back everyone

So basically we already have created database view and projection view in our previous blog and in this blog we will see about Maintenance view and help view.

Maintenance View Creation :-

Note :- We can only create help view, if not more than one record should exits in dependent/secondary tables.

  • Step 1:- Go to se11 and select view radio button and give some name for maintenance view and click on create button.
  • Step 2:- Select maintenance view radio button and press enter → give short description.

Note:- Since in our order item table we have multiple data for same data in order header and since maintenance view does not allow presence of multiple data in secondary table.

Therefore, we will be creating two more tables with the following data in them, and then we will start with the maintenance view.

    


So, basically create the two tables, I don’t think it will cause any problem to anyone because we already have discussed in details how to create a table.

        


  • Create the second table and describe a foreign key relationship as required and maintain cardinality as 1 to 1.



  • activate the table.



Requirement :- Create a maintenance view with the help of above two tables { ZAR_PROJ1 and ZAR_PROJ2 } , create a table maintenance generator of the view and insert the following details.

    


  • Step 3 :- We already have given short description.

  • Step 4:- In tables column provide the name of our main table or primary key table { ZAR_PROJ1 } and click on relationship → select the dependent table and click on copy button.



  • Step 5 :- Click on view fields { please take MANDT field as the first field in maintenance view }.

  • Step 6 :- click on table fields and select the first table, from the first table MANDT and project number are already there so we don’t need to select again.

  • Step 7:- again click on the second field and select the remaining fields and click on copy button .



  • Step 8 :- Activate the view → go to utilities and create a TMG for our view.



Purpose of Maintenance View :-

  • We can enter data in the view from SM30 and the entered data will be automatically flow into the tables.

  • Go to sm30 and enter the data which is mentioned in the requirement above.



  • As you will click on save, the data will automatically save into the columns of the two tables, you can check the tables.

Help View Creation :-

Note :- We can only create help view, if not more than one record should exits in dependent/secondary tables.

  • Step 1:- go to se11 → select view radio button → provide a name and click on create button.

  • Step 2 :- select help view radio button → and press enter.

  • Step 3:- Provide short description.

  • Step 4:- In tables column enter ZAR_PROJ1 table and click on relationship.

  • Step 5 :- select the dependent table and click on copy button.



  • Step 6 :- Click on view fields { Since, it is a help view therefore MANDT field is not compulsory, you can remove if you want.

  • Step 7 :- select fields which you want from the both tables.

  • Step 8 :- Save and activate the view.



Note :- In case of help view, the contents tab remains disabled.

Use of help view :-

→ It is used in search helps , so we will discuss in upcoming blogs.

→Help view will display the contents when it is used in search help.

Thanx for being with me.

We will start with indexes in next blog.

Location: India

Comments

Post a Comment

Popular posts from this blog

Understanding Different Types of SAP Function Modules: Normal, RFC, and Update

Image
  1. Normal/Regular Function Module :- It can be called inside the system. Here Pass by value + Pass by reference both is fine. 2. RFC Function Modules :- You can call from same system or from another possible. In RFC function module you can only have pass by value. In the same system if you are going to add the DESTINATION NONE’ while calling the RFC then it’ll be called in separate session. 3. UPDATE Function Modules :- This is generally used to update the database record. Update Function Module can be called from the same system. ( Background RFC / trfc / grfc ) This is used to achieve generally the SAP LUW. Some time we use from performance perspective also. When COMMIT WORK gets executed then Update starts getting executed. Important Questions on Update Function Modules :- When Update function Module gets Triggered ? ON COMMIT WORK IF a update function module gets failed, under which transaction we can see that ? OR What is the T-Code for ...
Read more

Mastering ABAP: A Step-by-Step Guide to Function Modules and Groups for Modularized Programming

Image
  Function Modules :- It is a modularization technique. The transaction code to create a function module is SE37. To create a function module, we need to create a function group. Function Group :- Function group is a container for the function modules. The transaction code to create a function group is SE80. A function group can store up to 99 function modules. Requirement :- let’s create a function module for sum of two numbers. 1. Creation of function group :- Step 1 :- Go to SE80 transaction code → Object Navigator. Step 2 :- From the drop down select function group. Step 3 :- Give a name of function group. Step 4 :- press enter. Step 5 :- Click on yes a popup screen will appear. Step 6 :- Give short description → press enter → Assign package and transaction request and press enter. Step 7 :- Right click on function group and click on activate to activate the function group. Step 8 :- You will see two includes, will be added afte...
Read more

Introduction to SAP

Image
  1. ERP :- Enterprise Resource Planning The purpose of ERP software is to manage the entire organization. 2. SAP :- System Application and Products in real time data processing 3. History of SAP :- SAP was introduced by SAP AG in 1972 at Walldorf. ( Germany ). SAP is a German based product. 4. Features of SAP :- It is an integration of all functions in to one common software. It is available in more than 40 language across the world. It is a user-based license agreement. ( requires user name and password ). 5. SAP R/3 Architecture :- ( 3 - 3 tier architecture , R - Real ) - SAP is a real time architecture. Layers in SAP Architecture :- Presentation Layer ( User Interaction Layer ) Application Layer ( Writing the programs and applications ) Database Layer ( To store and retrieve the data ). 6. SAP NetWeaver :- SAP NetWeaver (NW) is an integrated technology platform which can support various SAP applications. Examples :- SAP ERP ( Enterpr...
Read more