query variants

[Former Member]

hi,

I have to use 7.0 variants in 3.5 gui.

I create variants in 7.0 but i cannot see them when i run the report with 3.5

variants created in rsrt can be seen in 3.5 gui only.

is there any trick ?

regards

sp

[Former Member]

Hi,

You also have to look at note [1003481|https://service.sap.com/sap/support/notes/1003481]

and [Migration of Business Explorer|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0197e0f-021d-2a10-de9a-865331b4d45d]

they are about migrating from 3.5 to 7.0 but at least you can have an idea what does RSR_MIGRATE_VARIANTS program do.

Mustafa

[Former Member]

teşekkürler. i will try this.

[Former Member]

Hi,

You are right, you cannot see variants in 3.5 which were created in 7.0. They are stored in different tables and different formats.

You can migrate 3.5 variants to 7.0 but 7.0 to 3.5 is not possible. At least you have to deal with a lot of abap code. I am pasting a variant maintenance code, it may be useful if you write your own code.

*&---------------------------------------------------------------------*
*& Report Z_MASS_VARIANT_MAINTENANCE *
*& *
*&---------------------------------------------------------------------*
*& Program to mass update BEx Variants within SAP NetWeaver 2004s *
*& *
*&---------------------------------------------------------------------*
REPORT Z_MASS_VARIANT_MAINTENANCE.
parameter variable like RSRVARIANT-VARI.
parameter vname like RSRVARIANT-VNAM.
parameter sign_01 like RSRVARIANT-SIGN.
parameter opt_01 like RSRVARIANT-OPT.
parameter low_01 like RSRVARIANT-LOW.
parameter high_01 like RSRVARIANT-HIGH.
tables: RSRVARIANT.

select * from RSRVARIANT.
if rsrvariant-VARI = variable AND rsrvariant-vnam = vname.
rsrvariant-SIGN = sign_01.
rsrvariant-OPT = opt_01.
rsrvariant-LOW = low_01.
rsrvariant-HIGH = high_01.
elseif rsrvariant-vnam = vname.
rsrvariant-SIGN = sign_01.
rsrvariant-OPT = opt_01.
rsrvariant-LOW = low_01.
rsrvariant-HIGH = high_01.
endif.
update rsrvariant.
if sy-subrc <> 0. insert rsrvariant. endif.
endselect.

Mustafa

Edited by: Mustafa Aydogdu on Apr 7, 2009 1:22 PM