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?

[dominik_graus · Accepted solution]

Hi Martin,

In SAP BW/4HANA, you could query the table RSOOBJXREF with TLOGO = 'DTPA' and TLOGO_DEP = 'TRFN'.

Regards,
Dominik

[martin_chambers · Accepted solution]

Thank you Dominik
that is exactly what I was looking for!

[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

[yogananda]

martin.chambers

The best way to do this would be to query the SBIW_TRANSFORMATION_MAPPING table in BW/4 HANA. This table contains all the transformation details for each DTP, including the Transformation ID.

You can use the following SQL query to get a list of DTP ID and all the Transformation IDs associated with it:

SELECT DTP_ID,
       GROUP_CONCAT(TRANSFORMATION_ID) as TRANSFORMATION_IDS
FROM SBIW_TRANSFORMATION_MAPPING
GROUP BY DTP_ID;

This query will return a list of all the DTP IDs and the corresponding Transformation IDs separated by commas.
If this response answers your query, please accept it and close the thread.
Have a wonderful day!

[martin_chambers]

Thankyou Muthaiah for answering so soon.
I tried your SQL query but the table (or view) SBIW_TRANSFORAMTION_MAPPING was not recognized (Invalid table name). I also could not find it in SE16.