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
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:
How to take care of this as it will create a Self join type of condition?
Your response is greatly appreciated.
Thanks & regards,