Missing technical link from Datasphere remote tables to source system

[erik_pedersen]

Hi experts,

I need to find the link between a select on a remote table in datasphere and the similar select on the source system. I am using DP Agent as connector between Datasphere and in this case a BW/4Hana system.

I can see the SQL select towards the source system in the M_REMOTE_STATEMENTS in datasphere - no problem. But how can I find the unique link to the SQL executed on the source system? By comparing starting time of the statement in Datasphere and source system I can actually find a kind of link when looking into M_EXPENSIVE_STATEMENTS on the source system.

I have tried to connect the 2 statements through transaction_id and/or Connection_id, but without any success. I think I need to access other interface tables, but which ones?

Any Good Ideas,

Regards

Erik Pedersen

[Martin_Kuma]

These are two different systems. Thus the transaction IDs will not match. Does not matter, that both are SAP BI systems 🙂

The actual statement with timestamp, or maybe the hash?