Writing own sql code in SAP Quick viewer

[Former Member]

Hi Experts,

I have created a quick viewer object joining few tables . The out put getting displayed has duplicate entries.

I would like to embed / write my own sql code to modify the way I want , Like I want to write " DELETE ADJACENET DUPLICATES COMPARING ALL" to show me distnict rows.

Can any one please help me to achieve this. I mean writing query or any other way this can be achieved.

Thanks,

Sourya Prakash.

[Former Member]

Hello Sourya

Could you  share your tables and join conditions you are using.

Sudesh

[Former Member]

Hi Sudesh,

The tables I collected from this view V_T543b and is joining .

Thanks for your reply.

Regards,

Sourya Prakash.

[rvinod1982]

Hi,

I don't think that feature is available in SAP Quickviewer.

Regards,

Vinod

[Former Member]

Hi Vinod ,

Can we do it Query Viewers like using any of teh trasnactions (SQ01 , SQ02 / SQ03)?

Thanks.

[rvinod1982]

Hi,

Its possible in SAP Query using the 3 transactions SQ03, SQ02 and SQ01.

Code can be written in SQ02.

In SQ02, enter the infoset name and then select Enviroinment->Directories->Code.

Regards,

Vinod

[Former Member]

Hello Sourya

As  Vinod, said you can write code in  using SQ02 and also there is class CL_QUERY_DDIC_ACCESS  can be used to read the data and filter as per your requirements. Let me know if this does not help.

Sudesh