Join condition in QuickViewer

Former Member — Tue, 03 Feb 2009 21:37:33 GMT

hello

i am trying to design one query in QuickViewer which has joins. for that i selected DataSource as Table Join where i joined the 2 tables based on thier primary keys.

but i am having a where condition in which the field-value from the first table should be less than the field from the second one. My query statement looks like this

select but000~partner into corresponding fields of table i_partner
  from but000 inner join crm_jcds on but000~partner_guid = crm_jcds~objnr
  where but000~chdat < crm_jcds~udate
    and crm_jcds~inact <> 'X'.

I tired to join chdat and udate fields and tried to add condition but it was not allowing. it gave me option of Selection parameters as CHDAT but there i suppose it expects some hard-coded values.

any idea how we can have such condition inside QuickViewer?

Thanks in advance.

regards

rajeev

Re: Join condition in QuickViewer

Jelena_Perfiljeva — Wed, 04 Feb 2009 22:06:30 GMT

I don't believe this is technically possible in QuickView. It might be possible in SAP query (SQ01) with some programming (not 100% sure though), but a custom ABAP report might be an easier solution.

Re: Join condition in QuickViewer

Former Member — Mon, 11 May 2009 05:59:31 GMT

Developed query

topic Re: Join condition in QuickViewer in Application Development and Automation Discussions

Join condition in QuickViewer

Re: Join condition in QuickViewer

Re: Join condition in QuickViewer