topic Re: Archiving Object BC_E071K in Application Development and Automation Discussions

Archiving Object BC_E071K

Former Member — Wed, 03 Jul 2013 10:20:56 GMT

Hi!

does anyone have any suggestions /experience about archiving with object BC_E071K.

How many years should stay in the database?

What is the best practice?

In which periods have you organized the archiving with BC_E071K?

Are there any preconditions?

thanks for your input

Florian

FredericGirod — Wed, 03 Jul 2013 10:39:29 GMT

Hi Florian,

E071K looks like the table of details about transport request.

There is no rules about that, just requirement of your functionnal team

did you try to check witch kind of data use the most of space ? (trans. TAANA)

maybe developpers didn't care about that

Regards

Fred

Former Member — Wed, 03 Jul 2013 10:51:21 GMT

Hi Frederic,

well at the moment we have more than 12.000.000 records in table E071K.

One result is that transaction SNOTE is really slow.

I am not sure until which date I can archive E071K.

How many years/ monthes should I have E071K records in my database?

thanks and regards

florian

FredericGirod — Wed, 03 Jul 2013 11:25:23 GMT

It really depends of your functionnal teams

for me one year is enough

I used E071K to find, who have modify a customizing key (after a bug)

Have a look to the trans. TAANA to analyse what kind of data you have in E071K (on the OBJECT)

(that will made a GROUP BY .. COUNT ..)

regards

Fred