How do I identify the BW transformations used in a DTP

[martin_chambers]

We are using BW/4 HANA 2.0 and all our transformations use HANA SQL in the routines.

I would like to create a list with the DTP ID and all the transformation IDs used for that DTP.
This is not too difficult if only 1 transformation per DTP, i.e. the transformation directly connects 1 source ADSO with a target ADSO. With stacked transformations,

e.g. ADSO -> Transformation -> InfoSource -> Transformation -> InfoSource -> Transformation -> ADSO

it is more challenging.
Ideally, I would like to write an SQL statement that produces a list like this:

etc.

Can anyone help me out?

[pierrick_78]

Hi Yagananda,

actually table SBIW_TRANSFORMATION_MAPPING Doesn't exist !!!

Whzt is the exact name of this table which makes relation between DTP and Transformation ?

Thanks

Pierrick