on 12-10-2013 7:45 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.