Swap Function In BEx?

[Former Member]

Hello All

Can anyone let me know what exactly is the SWAP function.When do v use it and in what scenario's do v use it?

Generally when u right click on execution of query on a particular characteristics v will get this option(SWAP)?

Pl let me know

regards

balji

[Former Member · Accepted solution]

Hi,

Take an example:

custid prodid sales

c100 p100 200

c100 p101 202

result.......<b>402</b>

c101 p100 300

result...... <b>300</b>

c102 p100 400

c102 p101 200

result...... <b>600</b>

Now,

If u swap prodid with custid

result will be as:

p100 c100 200

p100 c101 300

p100 c102 400

result...... <b>900</b>

p101 c100 202

p101 c102 200

result...... <b>402</b>

by this if u want to see the sales by prodid wise u can swap in this way..

shylaja.

[Former Member · Accepted solution]

hi shylaja

thanks for your info given

regards

balji

[Former Member]

Balaji,

To keep it simple,

Swap characteristic 1 / structure 1 with

characteristic 2 / structure 2

You can use this function to swap a characteristic / structure with another characteristic / structure

This is a context menu function.

Check this link

http://help.sap.com/saphelp_nw04/helpdata/en/f2/874bb779ea724d890502922a859d33/frameset.htm

-Doodle

[Former Member]

hi Doodle

thanks for your info

regards

balji

[Former Member]

Hello Balaji,

Say for eg. there is a report showing countrywise customer wise sales with Country as the first col. and Customer as the second col and sales figures as thid col as shown below

Country Customer Sales qty

India XYZ 100

xxx 200

USA ppp 50

xxx 250

now u want to see it as customer wise country wise sales.

you will swap country with customer at run time for this.

Customer Country Sales qty

XYZ India 100

xxx India 200

USA 250

ppp USA 50

hope it helps...

thanks,

[Former Member]

hi aby

thanks for your info given

regards

balji

[Former Member]

Hello Balaji,

SWAP function is used to interchange or swap positions of two characteristics or structures in the query output.

You can swap the axes of the query also. If you have characteristics in the rows and key figures in the columns and you choose Swap Axes, then the key figures are displayed in the rows and the characteristics are displayed in the columns.

Check this lin kfor more details

http://help.sap.com/saphelp_nw04/helpdata/en/d3/ea523ac1ea1d35e10000000a11402f/content.htm

Hope it helps.

Regards,

Praveen

[Former Member]

hi praveen

thanks for your info given

regards

balji

[former_member181964]

Hi,

http://help.sap.com/saphelp_nw04/helpdata/en/f2/874bb779ea724d890502922a859d33/frameset.htm

Thanks

Reddy

[Former Member]

hi surendra

thanks for your info given

regards

balji