Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Massive user deletion via eCATT

ryskovab
Discoverer

‎04-27-2018 12:14 PM

0 Kudos

I was asked delete over 600 000 user IDs from a SAP system (the user IDs were created automatically by clicking on a web link and shouldn't be there).

I wanted to use eCATT for that -> TCD (Record ) -> SU01

The problem is that I am able to delete only 9 997 users during one eCATT script run. Even if I put much more user IDs to the Variant file. SAP simply finish when delete 9 997 users.

Is there any limit that the Variant file can have only 10 000 rows (3 lines standardly generated + 9 997 Variants)
Is it possible to extend the limit?

Thank you in advance for your answer.

4 REPLIES 4

pokrakam
Active Contributor

‎04-27-2018 12:18 PM

0 Kudos

Shouldn't take more than half an hour to write a simple ABAP program. If you're not friends with ABAP then get a developer involved.

ryskovab
Discoverer
In response to pokrakam

‎04-27-2018 3:53 PM

0 Kudos

theoretically it seems to be a good idea. Practically it is not. The customer has very strict rules. It would take one month to arrange access for a developer to the system. And it would take another one month to go through all approval procedure to push a transport request to production system.

pokrakam
Active Contributor
In response to pokrakam

‎04-27-2018 4:11 PM

0 Kudos

Well, if the users aren't causing any harm...

Otherwise it doesn't take _that_ long to chop 600k records up into 61 segments and run them one after another. A couple of hours at most, less time than trying to figure out alternatives.

Personally I find it more than a bit bizarre that they have such supposedly strict controls on programs but hey, lets wave eCATT scripts through they can't do anything harmful like delete users or anything like that. It's a bit reminiscent of a recent thread Why are the people who define allowed transactions in production apparently not very smart?

AjayHS
Product and Topic Expert
Product and Topic Expert

‎05-04-2018 8:01 AM

0 Kudos

Hello Barbora,

eCATT is generally used for functional testing and not for master data creation/deletion.

Between wrt to number of records, did you try using External Variant ? passing value through excel to the Test Configuration ?

May be you can try to create excel file with all the records to be deleted and pass it to Test Configuration.

Hope it helps.

Thanks

Aj