delete table in tcode sqvi

[Former Member]

Hi Experts,

I created a query with 3 tables MARA, MAKT, MARC with joining condition. but if i want to delete MARC table in tcode SQVI system do not allow to delete the table..

Kindly help me in what way i delete thwe table MARC.

Harsh Saxena

[Former Member · Accepted solution]

hi,

there is no any other solution to delete in tcode SQVI. I only have the authorization of SQVI. Kindly help me out.

Harsh Saxena

[Former Member · Accepted solution]

hi,

Try to open the infoset in transaction SQ02 and see if you have authorization to delete the table MARC here.

Thanks,

Subash

[Former Member · Accepted solution]

Hi Harsh,

I hope you are using the Quick Viewer (SQVI) query and not the infoset query using SQ02.

So you can re-create a new query and ignore the table MARC in the join tables.

Regards,

Immanuel

[Former Member]

Hi,

Remove the fields related to MARC in the infoset , then you can delete the table MARC.

Thanks,

subash

[Former Member]

Hi Harsh,

Once the joins are saved the tables cannot be deleted from the Quick Viewer.

Regards,

Immanuel.