cancel
Showing results for 
Search instead for 
Did you mean: 

Transpose columns to rows in SAP BW

0 Kudos
3,371

Hello,

I want to transpose colums from my datasource to rows in my data target like the scenario below

Source System ( Datasource) :

Destination (DSO) :

How can I get this result ?

Thanks in advance for your help.

Accepted Solutions (1)

Accepted Solutions (1)

Geetha_Madhuri_Bobbili
Active Participant

Hi Ahmed,

1. You can write Start Routine or End Routine in Transformation.

2. We can use the Rule Groups functionality to achieve the same.

Please follow the below thread for step by step procedure.

http://dailybusinessobjectsupport.blogspot.com/2011/09/transposing-fields-in-sap-bw.html?m=1

Regards,

Geetha.

LinkedIn Profile: https://www.linkedin.com/in/geetha-madhuri-971268184/

Answers (2)

Answers (2)

shanthi_bhaskar
Active Contributor
0 Kudos

I had previously but I dont have code now, You need to do this with by using the ABAP Event like AT FIRST, AT LAST etc.. I had done using the Expert routine.

Thanks for your reply Shanthi , I succeed to do it using an AMDP Script.

former_member231709
Active Contributor
0 Kudos

You can use for this "Rule Groups" in transformation. For example: https://archive.sap.com/documents/docs/DOC-11537

0 Kudos

Thanks for your reply Eugeniy, do you think I can use "Rule Groups" if I have hundred of columns to transpose to rows?

best Regards,

Ahmed

former_member231709
Active Contributor
0 Kudos

You may use for this coding in expert routine. It might be easier.

0 Kudos

Do you have some examples of "expert routine" I can use to transpose colums to rows ?