Skip to Content
avatar image
Former Member

I get different results with LEFT OUTER JOIN and ASSOCIATION

My association

define view ZCDSV_QTITMASC
  as select from ZCDSV_QTITMLNK as a
  /*  left outer join vbap           as b on  a.vbeln     = b.vbeln
                                        and a.ref_posnr = b.posnr*/
  association to vbap as _to_vbap_ref on  a.vbeln     = _to_vbap_ref.vbeln
                                      and a.ref_posnr = _to_vbap_ref.posnr
  key a.vbeln,
  key ref_posnr,
  key fg_posnr,
      //b.matnr                          as tp,
      _to_vbap_ref.matnr               as tp1


If I uncomment the LEFT OUTER JOIN, I get the expected result:

How can I make the association give the results like the LEFT OUTER JOIN?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2017 at 05:12 PM

    Are you on HANA?

    Maybe you have to specify the correct cardinality.

    HANA optimizes and thereby can change the result.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the response. Tried every possible combination but unfortunately no change in results. Closing this thread as I did the query the old way and resolved the issue with a left outer join instead of association.