Table for transports import dates

[Former Member]

Hi,

Is there any table with details about when a transport was imported to some client? I found e070 but the date on that one isn't the same as the one in the logs in sm20n transaction. I spent a bit of time looking for the field with no luck.. Any ideas?

Thanks

Tania

[Former Member]

Hi,

Is there any table with details about when a transport was imported to some client? I found e070 but the date on that one isn't the same as the one in the logs in sm20n transaction. I spent a bit of time looking for the field with no luck.. Any ideas?

Thanks

Tania

[Former Member]

Hi Tania,

The Table is E070.

U locate it very well.

The reason may be u r checking it in dev. system

Check in Prod. or Testing System to which it was Imported.

the another way is to check it tcode STMS.

first dobule click the system for which u want o/p.

On the application toolbar click import history.

Click on time interval and change the desired dates.

Hope this helps.

Regards

-

---

Sachin Dhingra

[Former Member]

I had a look at STMS and the dates in the import history say for QAS or PRD are exactly the ones I'm looking for. Is this report getting the dates from QAS or PRD or are they stored somewhere in DEV as well? We need an audit report to make sure that everything that goes from DEV to QAS has gone from QAS to PRD as well. Does something like that exist already?

Would it be possible to get all that data from any client/system?

[Former Member]

Hi Tania,

I have also make the same for Audit.

For all the Request released from DEV. to QAS

Login in QAS check either for E070 or t-code STMS.

For all the Request released from QAS to PRD

Login in PRD check either for E070 or t-code STMS.

From T-code STMS once u get the desired result choose menu.

SYSTEM->LIST->SAVE->Local file->SPreadSheet

and save it as .xls file.

Hope it helps.

Regards

-

---

Sachin Dhingra

[Former Member]

Hi,

Check in the function group TMSU_IQ, this might be helpful,

Rgds,