Skip to Content
0

SAP HANA CALCULATION View Join table with Analytic view

May 31, 2017 at 03:56 PM

37

avatar image

Hello ,

1. We have a scenario where we need to derive Range of FUNDCTR from table . I created input parameters and applied filter on FUNDCTR filtered FROM & TO . Is this the right way to achieve it ?

2. I have created a Analytic view ANV1 based on FMBL & FMBH & FMFCTR . Reason why i joined FMFCTR is to get the BUKRS from it . Now i need to join the ZTABLE inorder to create the final output.

Can anyone suggest a way to join the ZTABLE & ANV1 to obtain the result mentioned in the image ?

scenario1.jpg (97.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

RAM PRAKASH CHADALAVADA Jun 01, 2017 at 10:27 AM
0

Any suggestions folks ?

Share
10 |10000 characters needed characters left characters exceeded