Skip to Content

An SAP end-user trainer sometimes gets lucky. I’m always over the moon if I find out at the start of a project that there is a dedicated training environment. It even gets better when the client is being refreshed on a regular basis. In that case, it is only necessary to set-up data for the training exercises once. Alas, this is seldom reality, and creating training data over and over again becomes quickly a labour of Sisyphus.

I can’t count how many hours I’ve spent setting-up exercises in my life. I remember a project in the South of France where I had to train the purchase flow. In one particular training, the trainees only needed to know how to create a purchase requisition, and how to do the goods receipt. That’s why I needed to create purchase orders. To be precise, 720 of them. That is one-month training, twelve trainees per day, and – because repetition is the key to mastery – three purchase orders each. So, instead of having lunch under the Mediterranean sun with a French baguette, cheese, and a burgundy wine, I  converted PRQ’s to purchase orders like crazy while inhaling my lunch in the training room.

In the past, I heard people talk about LSMW. Moreover, I knew that it was a tool to upload data into an SAP system. However, it was only in #BCO6181, one of the best units at Victoria University that it dawned on me: LSMW can be used to create the right data for exercises for end-user training. There is even a second tool that can be used for that purpose: eCatt. Why did nobody tell me?

After exploring both LSMW and eCatt during tutorials in the unit ERP implementation, and some experimenting at home, I realized that for training eCatt is the way to go. It is very similar to what you normally have to do from a functional perspective, and it takes less time than LSMW. Let’s get a closer look at eCatt.

Using eCatt to get training data into the system

There are four simple steps to get data into the system with eCatt. Firstly, you have to do the transaction once while you record it. Secondly, you have to name each field that you want to be filled in. Those names will become the headers of columns in an Excel sheet. After that, you have to upload the training data. You do this by downloading the data template to Excel, adding the required data, and upload the file again. As a final step, you execute the test script.

/wp-content/uploads/2015/05/ecatt_713479.png

Here you can find an extensive explanation http://scn.sap.com/docs/DOC-8235 of how to work with eCatt, written by Melanie Reinwarth and with contributions of Rakesh Kumar Jain.

To put it to the test, I created ten materials from scratch, first by hand and then with eCatt. As a seasoned material-master-creator, it took me a little over  4 minutes to do so. As a beginner in eCatt, the creation of 10 materials took me nearly 14 minutes more. At first glance, the manual creation is much faster. However, when you need more materials, the manual time will grow linear, while the eCatt time stays constant. Hence, in this case using eCatt becomes beneficial from the moment you need more than 40 materials.

Let’s go back to the 720 purchase orders from the beginning, and let’s assume that creating a material takes the same amount of time than creating a purchase order. By hand, it would take more than 5 hours, with eCatt only 14 minutes. Now close your eyes and imagine, how many baguettes you can eat and how many wines you can drink in 4,5 hours… I rest my case.

/wp-content/uploads/2015/05/2015_05_29_031037_713483.png

To end, I would like to encourage all the trainers to ask for the authorization for t-code SECATT and start trying today. To the security administrator, I would like to ask to say “yes” to all the trainers that want to use SECATT.  To all other people out there: if there is something else you are hiding from me, now it is the time to speak up.



To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Rishab Bucha

    Nice blog Joke Kerkel,

    One addition is that ecatt can even be used for client who has SAP up and running.

    You can setup regression testing scripts and use them effectively to test your core processes and validate them

    (0) 
    1. Joke Krekels Post author

      Happy that you liked it, Rishab Bucha. I only experimented with the basis of e-Catt, but it seems a powerful tool. Thanks for the tip.

      (0) 
    2. Tom Cenens

      For regression testing I would advice to take a look at CBTA (Component Based Test Automation) in SAP Solution Manager. It’s free of charge for Enterprise Support (or higher) contract customers and it’s easy to use for the end-user to record and play back test cases (it uses e-catt underneath so certain elements are used in CBTA, for example you can use test data containers).

      (0) 
  2. Tom Cenens

    Hi Joke

    I saw you signed up for SAP Inside Track Belgium and then I saw you posted that you had written your first blog post so I had to come and read it and I have to say well done 🙂 . It’s  a fluent read which is great and I applaud the pictures (nice touch, seriously).

    I don’t know if you are familiar with Winshuttle because that might also be of interest to you given it’s capabilities to do similar things. I could check if I can get a presentation going at SAP Inside Track on it if you’re interested. Let me know.

    Best regards

    Tom

    PS: please continue to blog 🙂

    (0) 
    1. Joke Krekels Post author

      Hi Tom,

      Thanks for reading my blog and for helping to put SAP Inside Track back on the rails in Belgium. I experience the SAP community in Australia, where it is very lively and I hoped it would be the same in Belgium. So I’m happy there is an Inside Track. It is nice to learn and share with your peers.

      I would be interested to learn about Winshuttle. I checked my lecture notes and it was mentioned on one of them. So, if you get a presentation up and running I would certainly come and see it. In the meantime I will Google it. I will do the same with CBTA – I saw you already signed up to give a demo about that tool.

      Looking forward for SAP Inside Track and meeting you.

      Best regards,

      Joke

      (0) 
  3. Joachim Rees

    Hey Joke,

    thanks for sharing!

    In the past years, I have used SHDB (that’s the “Recording”-button in SM35) to reduce my efforts in creating test data. I think I created some nice scripts and saved myself a lot of time in comparison to manual creation.

    Today, I want to try if eCatt fits my needs even more.

    The problem I have so far is, that I did not find some recent tutorial on how to create a simple “real live” recoding (say: VA01 – create Sales order) with eCatt.

    Your blog beeing from 2015 is one of the newest, the link you mention (https://archive.sap.com/documents/docs/DOC-8235) is from 2012, and the link there to “eCATT Part 2 – Recording a Scenario” – which sounds like just what I want by its title – goes to a document from 2007 (https://archive.sap.com/documents/docs/DOC-10031) .

    Now “old” doesn’t mean “wrong”, but I sure would feel more comfortable, if I would find a recent (say: ~last year) tutorial of some kind.

    Do you have any hint on that?

     

    best

    Joachim

    PS: What I imagine doing is something like this:

    – Have scripts for master date (Materials, Vendor, Customer, maybe prices …)

    – Have scripts for transactional data (purchase order, inbound delivery, sales order, outbound delivery …)

    – being able to connect the scripts to each other so I can build more complete scenarios (without using duplicate code/recordings)

    – being able to easily transfer those scripts between systems, so I can start creating “my” data with the push of a button on a new (dev-)system.

    (0) 

Leave a Reply