Skip to Content
0
Former Member
Dec 10, 2013 at 07:45 PM

Handling Different Join Conditions in HANA

64 Views

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