Mastering SAP Transactions: Creating Custom Transaction Codes and Case-Sensitive Table Management

 

  • Welcome back everyone, So basically we were discussing about lock objects in our previous blog.
  • You have noticed, I have been using the term transaction codes very often, In this blog we will learn how to create transaction codes for tables.

How to create a transaction code ?

  • We use transaction code SE93 for creating our own transaction codes manually.

Creating transaction code for our Order Header Table:-

  • Step 1 :- Go to transaction code SE93.

  • You will see a screen, same as below



  • Step 2 :- Give a name and click on create button.



  • Step 3 :- Provide Short description and for creating transaction code for table ( In Start object select the radio button → Transaction with parameters ( parameter transaction ) ).



    Note :- We will discuss and use the remaining radio button, in the nearby future in other upcoming topics.

  • Step 4 :- Press enter.

  • Step 5 :- Since, we want to open SM30, whenever we open our TCODE , therefore provide SM30 in transaction field and click on skip initial screen.



  • Step 6 :- Select all GUI support.



  • Step 7 :- In default values.

    • Name of screen field — Value

    • VIEWNAME - ZAR_HEADER (Write name of table )

    • UPDATE - X



  • Step 8 :- Click on save



  • Now you can use the above created transaction code for opening the SM30 screen for table maintenance from SAP Easy Access.



Significance of Lower Case/Case Sensitive Checkbox :-

Whenever, We open any table in SM30. Suppose I open my order item table in Sm30.

    


I have tried change write the order Description as first letter capital and others as small. As soon as I press enter,

    


  • Tea will turn into TEA.
  • Now, Suppose If customer wants that the name should be saved in the table in the same way as it is written.

How will we achieve that ?

  • Step 1 :- Open our order item table in change mode.



  • Step 2 :- Double click on the order description → double click on the entered domain name.



  • Step 3 :- Enable the case-sensitive checkbox → save and activate the domain and then save and activate the table.



  • Step 4 :- Now go to SM30 and try to change the name of order description.



    • You will see, now you are able to save the order description in the same way, as you will write.

Note :- In hana database, even if you are not selecting the initial values check box and only selecting the key checkbox then, as soon as you will activate the table, the initial value checkbox will be automatically enabled.

  • Before activating the table:-



  • After activating the table :-



So that’s enough for today. We will continue with database utility in the next blog.

Thanx for being a part of this wonderful journey.

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