STMS Import History Table

[S0007586158]

Hi,

In STMS Import History, we have the field "User " which provides the details of the user who did the Import of Transport Request.

From which database table this information is stored?

Regards,
Sam

[former_member182657]

Hi,

As per standard steps behind import history is that STMS will look in table TPALOGHDR to check if the time frame for which the import history is called, is between STARTTIME and ENDTIME.

If it is, it will use the entries in table TPALOG.

If not, it will read the ALOG files on /usr/sap/trans/log and update table TPALOG and pics the user info from field TRUSER ( Last changed by ) as also suggested by Mr.YvesKervadec .

Best Regards,

Gaurav Rana

[former_member188883]

Hi Cheriyan,

As per my understanding there is no database table which stores this information. Such information are stored in the SLOG, ULOG and ALOG files in the transport directory and SAP application picks up from these files.

Hope this helps.

Regards,

Deepak Kori

[S0007586158]

Hi Deepak,

Thanks for the quick response, will check this and confirm.

Regards,

Sam

[ACE-SAP]

Hi

There is in fact a TPALOG table that did store the information from ALOG file, it has a field TRUSER that contains the name of the user who perform the import.

This table is not automatically updated,it only get updated when you refresh import history in STMS (through call function TRINT_FI_FILL_ALOG_CACHE)

Regards

43391 - Documentation for the log file ALOG

1842693 - TMS Import History contains entries for other systems in landscape

[former_member215345]

check trans\buffer entries also

[Former Member]

Hi,

You can see the details in the import history also.

Go to import history and then go to then select display more option and you will be able to see that how imported the transport.

Table would be TPALOG and the field would be ADMIN

Thanks

Rishi Abrol

Message was edited by: Rishi Abrol

[christianpunz]

Thank you SO MUCH!!!!

saved my day!

br

christian