• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SHDB – Transaction Recorder in SAP-Security

We have already come across LSMW for mass changes to SAP data. Let us not assume that LSMW is the only tool which can be used to update data in SAP. SAP provides quite a few number of tools, each with its unique features, to allow mass updation of data. In the current article I talk about the Transaction Recorder tool which can be accessed through the transaction SHDB. Like LSMW, SHDB is also used to record certain user actions in the SAP GUI for a particular transaction.

These actions are used to create a recording which can be processed at a later time to upload data. Through SHDB it is also quite easy to generate an ABAP report from the recording and modify the generated code to read an input file with a list of records and upload the data though the program. In this article I demonstrate the entire sequence
of actions though a recording to reset the password of a user through SU01.

We start the transaction SHDB and click the button for new recording. We give an appropriate name for the recording and input the transaction (SU01 in this case) which we are trying to record.

Capture.1461

On clicking the check button we are taken to the normal SU01 screen where we reset password of any user id already created in the system (USER01)

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written
 material and demo video tutorials. To gain in-depth knowledge and be on par with practical
 experience, then explore SAP Security Training.

Capture.1462

On saving the new password and clicking the back button, we are returned SHDB where we can check the steps in the recording.

Capture.1463

To test the recording we change the user id to “USER02” and save the recordings. Now we can process the recordings from SHDB.

Capture.1464

On successful processing for the recording, we get a screen showing that password for the USER02 wa indeed changed.

Capture.1464

Although its technically feasible to manually change the data in the recording and process them through SHDB, the generally accepted approach is to generate a program for the recording and update a list of records though ABAP code. SHDB main screen has options to generate a program from recording.

Capture.1466

Capture.1467

Capture.1468

On clicking the check button, we are taken to the normal SU01 screen where we set the password of any user_id already created in the system(USER01)Capture.1469

On saving the new password and clicking the back button, we are returned SHDB where we can process the recording.

Capture.1470

To test the recording we change the user to “USER02” and save the recording. Now we can process the recording from SHDB

Capture.1471

On successful processing for the recording, we get a screen showing that password for USER 02 was indeed changed.

Learn more about SAP Security Interview Questions in this blog post.

Capture.1473

Although it’s technically feasible to manually change the data in the recording and process them through SHDB, the generally accepted approach is to generate a program for the recording and update a list of records though ABAP code. SHDB main screen has options to generate a program from recording.

Capture.1474

On selecting this option, SHDB prompts us for the attribute details for this skeleton code to read data records from a file into an internal table, and loop over each record to update data into SAP.

Capture.1475

As you can see from the above example, like LSMW, SHDB provides us with another alternate method of upload of data into a SAP system. Which method you finally chose depends a lot on whether you are more comfortable in writing code or creating at the LSMW script.

For Indepth knowledge on SAP Security click on:
Summary
Review Date
Reviewed Item
SHDB – Transaction Recorder in SAP-Security
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SHDB – Transaction Recorder in SAP-Security"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.