Join condition in QuickViewer

[Former Member]

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

[Jelena_Perfiljeva]

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.

[Former Member]

Developed query