ABAP Query Variant Does Not Exist

[Former Member]

Hi,

After remote client copy from production to quality server with copy profile “SAP_ALL”, I faced with “Variant does not exist” for ABAP Query.

TCode SQ01, execute query with Variant, the pop up did show the variant, but when continue, it just show “Variant xxx does not exist”. 

I checked in production, the variant was not protected.

May I know how to solve this?

Thank you.

[ThangaPrakash]

Hello ZL,

Did you check the VARID table does the variant exists there.

In VARDI table you need to give the report name generated by SQ01 query.

To find the same goto SQ01 --> Query --> More functions --> Display report name.

Pass the report name to VARID table and check whether the variant exists int he table.

Regards,

Thanga

[Former Member]

Hi Thanga,

There's some report name with AQTG.... and AQFK....., may I know what's the difference?

[ThangaPrakash]

Hello ZL,

Can you please explain where did you find this report name and what steps you used to achieve this ?

Regards,

Thanga

[Former Member]

Hello,

Run the t-code once again, system--> status. double click on program name and select variants. if you have a backup before update, compare that and this. you may have to recreate the variant.

and after recreating it will work fine.

se38--> display variants.

Regards,

Arati

[Former Member]

Hi,

Solved based on SAP Note 374503. Thank you all.