cancel
Showing results for 
Search instead for 
Did you mean: 

Handling Different Join Conditions in HANA

Former Member
0 Kudos

Hello Experts,

I have couple of questions with respect to Joins:

a) I've Fact Table 'MSEG'.

  Now MSEG---->MKPF(via MBLNR and MJAHR)

         MKPF---->LIKP(via First 10 characters of XBLNR) and Keeping LFART as 'ZRET' for returned Delivery

         LIKP----->LIPS(via VBELN and MSEG.MATNR=LIPS.MATNR).Here we've 1:N cardinality

         LIKP.VGBEL---->VBAK.VBELN

         VBAK.VGBEL----->VBRP.VGBEL(Again 1..N)

This is all to find the Actual Delivery created for that returned Delivery.

How can we encompass this sort of logic via HANA Joins ?

b) How can handle additional Join condition of MSEG.MATNR = LIPS.MATNR to reach LIPS from LIKP.

c) Again there's a need to go to an Actual Delivery document via the following path:

     VBRP.VGBEL---->LIKP.VBELN

How to take care of this as it will create a Self join type of condition?

Your response is greatly appreciated.

Thanks & regards,

Jomy

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I'd encourage you to write up a simpler example that describes the problem you're facing. Then folks (like myself) might be more inclined to chime in.  

Former Member
0 Kudos

Hello Jody,

I'll try my level best to simplify things.

I hope this diagrammatic representation makes it easy for everyone's understanding.

Thanks & regards,

Jomy