Mastering SAP Table Maintenance: Insert, Update, and Delete Data with Ease

 Welcome back everyone.

  • So basically, we have created our ZAR_HEADER table yesterday, So we will learn how to maintain { insert, update, delete } data in the table.

    • Open the table in change mode → go to utilities → table contents → create Entries.





    • We can see the client number automatically appears.

    • Enter the following details and click on save.



      • You will get the message, database records successfully created.

    • Similarly put some more records and click on save.



    • If, I want to see the records in the button, there is a content button {Ctrl + Shift + f10}→ click on this button and press f8 {execute button }.

      OR

      • You can click on utilities → table contents and display

    Changing data in table :-

    • Note :- We can change, only non primary key data in our table.

    • Display the entries, select the row where you want to change the data and click on change pencil button.





    • Click on save and data will be changed, Again note we can only change data in non primary key.

Changing/Inserting/Deleting data through SE16 :-

  • Go to transaction code SE16 and enter the table and press enter → you will see the screen same as earlier.



  • We can perform the same things from SE16N also → It is basically the newer version of SE16.

    • Simply go to SE16N and click on execute → you will see a screen like below where you can do whatever you want.



Table Maintenance Generator :-

  • We maintained our data through SE11, SE16 and SE16N,
  • But In the projects, which is a live system, end users does not have the privilege to access SE11 or SE16 or SE16N
  • For that purpose, we create TMG for users, this is the best way to maintain data in the table.

How to create a TMG of a table?

  • Step 1:- Go to SE11 → open your table in change mode.

  • Step 2:- Go to utilities → click on table maintenance generator.



  • Step 3:-

    • Authorization group:- Suppose, a group consists of 10 people who is authorized to maintain the table.
    • So, if there is any specific group provide the authorization group or else provide &NC& which simply means everyone can maintain the data

  • Step 4:- In the function group provide the table name.

  • Step 5:- Select one step in maintenance type.

    • Single step :- Only overview screen is applicable.
    • Two step :- Both overview screen and single screen are applicable.

  • Step 6:- Click on find Scr. Number → propose screen number → click ok

  • Step 7 :- Click on create button which is just beside the { Find Scr. Number }.

  • Step 8:- Assign the package and press enter → TMG has been created.



  • Now you can maintain your data through SM30 → simply go to SM30 and give the table and do whatever you want.

Important Points related to TMG :-

  1. Data browser/ table view maintenance options needs to be Display/Maintenance allowed.
  2. Whenever you add new columns/fields to the table after generation of TMG, the newly added fields will not appear automatically while maintaining the data with help of SM30. We need to delete the TMG and generate it again.
  3. Deleting the TMG never delete the table data.
  4. To delete the TMG, Open the table in Change Mode, otherwise delete button will not be visible.

Important Points discussed so far :-

  1. MANDT :- It shows the client number of SAP system.
    • Table having MANDT field are called as client dependent or Client Specific tables.
    • Tables does not have MANDT field are called as Client Independent tables.
  2. Data browser/ Table view maintenance options :-
    • Display/Maintenance allowed.
    • Display/Maintenance not allowed.
    • Display/Maintenance allowed with restrictions.
  3. Size category :- A table can store how many number of records.

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 moni
Read more

Unlocking SAP ABAP Secrets: Interactive Classical Reports with GET CURSOR, At User Command, and a Comparison of HIDE Statements

Image
 Welcome back everyone, We were discussing about the interactive classical reports, so let’s continue it. Interactive Classical Reports- GET CURSOR :- In Interactive Classical Reports, GET CURSOR statement is used to create secondary list according to cursor position. The parameter FIELD provides the name of an output field. The parameter VALUE provide the output value. Syntax : GET CURSOR FIELD <lv_field> VALUE <lv_value>. In the above syntax - the field name and field value will be returned in to variables lv_field and lv_value respectively. Requirement :- If you remember, In our last two blog, We have been displaying the order header table in a basic list and order item table in the secondary list. We have used SY-LISEL and HIDE statements to achieve the requirement. Now, we have to use the get CURSOR to achieve the same to same requirement. Code :- ************************************************************* *Start of Program *Declaring Strcutrure
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 after ac
Read more