prod. sys. transformations global decl. deleted. how track TP from E071 Tab

[Former Member]

Hi SAP BI/BW Techines .

please help me on the following issue.

"In production system in one of the transformations global declaration has been deleted. we are not able to track the TP by which this has been done by using E071 table. can any one guide us how to track how our transformations has been changed in production in over night . "

I will reward points for any possible help .

Thanks

Alok

[Former Member]

Try transaction SLG1, object RSTRFN, give the date range when you think the action was done and execute. you will not get the TR info but you will get to know who has done it and when.

[KamalMehta]

Hi ,

Also if you want to track chnages from E071 then you can do the following :

1. Program ID put it as 'R3TR' .

2. Object Type as 'TRFN' .

3. Object name is the technical name of the Trabsformation .

Also you can give the date range .

Hope it helps

Thanks

Kamal

[Former Member]

HI Kamal ..

same thing we can do using E071 and i already did those ...

But it is not working in my case ..

Thanks

[Former Member]

Hi Kamal ..

Moreover there is no entries for these transformations in E071 table

after 09th month of last year but suddently they got inactivated on 07.01.2012.

I guess these details would give you borader prospest to analyse the issue !!!!

Thanks

[mr_v]

If u have access, u can check RSTRAN table in PROD. This will give history of transformation i.e. last changed by, time stamp etc.

If its manually changed, u can check last changed by column and with time stamp u may track the transport

[Former Member]

HI Kamal...

I am trying out SLG1.

Will update you soon.

Thanks

[KamalMehta]

Hi ,

Have you tried SE03 . You should be able to get the information from there .

Also do you have the Program RSDG_TRFN_ACTIVATE_ALL installed in your system .

You can activate the transformation using this .

Thanks

Kamal Mehta

[KamalMehta]

Hi ,

You can go to SE03 -->>SEARCH FOR OBJECT IN TRANSPORT >>PUT IT AS R3TR , TRFN and on right side give the technical name of the transformation and execute you will get the list of all the Transport w.r.t this Transformation .

Thanks

Kamal