Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extract column mapping from Query transform

Hi All,

How do we extract columns and their mappings for individual Query transforms within Dataflows?

I am trying to extract it from ATL within each Query transform, but it gives only an SQL statement like

SELECT Table_Name.Column_Name1,

Table_Name.Column_Name2,

.....

....

...

FROM Table_Name

WHERE Condition1 = 'Y'.....


This way I am not able to get the target column name.

I tried searching in repository tables AL_COLMAP, AL_COLMAP_NAMES, AL_COLMAP_TEXT, but they don't give desired output.


Any help will be much appreciated.


Thanks.

Former Member
Not what you were looking for? View more on this topic or Ask a question