GTS status log information

[spanigra]

Hello Gurus,

I need to prepare/pull a report where I could see historical version of blocked documents . Here I am not talking about current status of customs document. We need to pull the log from CDHDR/CDPOS table log and get the “oldest” entry for that document. For example when document created at that time document would have blocked due to different reason but now it would have released.

So are there any other tables/program/FM in GTS for logging the changes or the different statuses / Historical versions?

Please propose any solution.

Thanks in advance

Ravi Sankar

[gnishant]

Dear Ravi, in my knowledge the CDHDR/CDPOS tables are the only source of history / audit information. There is no other table which can give you the list of documents which were blocked at the time of creation or later, but are currently released.

[former_member600690]

Hi Ravi,

For SPL and Embargo: you can find the logs with earlier status information in table - /SAPSLL/CUHDSTA

and for Legal control - you can find the find the same in - /SAPSLL/CUITSTA. Good thing is date fields are also available here, so you can add the date specific logic as per your requirement.

Hope it helps.

Thanks,

Raj Mirikar

[spanigra]

Thanks Raj,

In the tables /SAPSLL/CUHDSTA or /SAPSLL/CUITSTA, we can see the “current” status as it is today, but not a historical version (“how it has been in time period xyz”).

I hope I have cleared my requirment details.

Regards

Ravi