TM: where to find carrier deviating address in DB tables?

[petrzitnik]

Hello,

we are creating customer report, where we need to place deviating (manual) address of executing carrier from the FO.

In FO root the deviating address is refferenced by TSPEXEC_ADDRESS_ID, but where (DB table) the key is linked to?

IN ADRV table, the manual address is linked to DB_KEY of FO as APPL_KEY, but doesn't have to be unique and I can't distinguish, which one is valid.

Does anyone know the answer how to select valid ADDRNUMBER? I assume TSPEXEC_ADDRESS_ID is the key, but do not know how to use.

Many thanks

Petr

[jesussalazar]

You should be able to see which Key and ADDRNUMBER is assigned to the FO under transtaction BOBT,

under:

There you can see the Key and actual ADDRNUMBER for a particular FO.

BR,
Jesus.

[petrzitnik]

Hello Jesus,

thank you for the answer. I am aware of this. Question is, how to address in the code of our report

Thank you, Petr