Hana Calculation View conditional join

[KonradZaleski]

Hi All,

I have the following requirement where i have to join below three fields to get the PURCHASING_VENDOR & PUR_VENDOR_DESCRIPTION from table 2

Table A MANDT WERKS LIFNR LTSNR ZZ_SUB_TTL100 Table B MANDT SHIP_LOCATION DC VSR PURCHASING VENDOR PURCHASING VENDOR DESCRIPTION

TABLE1.WERKS = TABLE2.DC

TABLE1.LIFNR=TABLE2.SHIP_LOCATION

TABLE1.LTSNR=TABLE2.VSR

For some scenarios, DC in the table2 is not maintained I.e DC is null. in that case whenever DC is null, can we only make join on ship_location & VSR to get Purchasing_vendor ? How can we achieve this in HANA Cal.view?

Any advice will be much appreciated.

Thanks,
Sudheer

[KonradZaleski]

Let me know if my answer solves your issue. If yes, please mark it as the answer.

[SergioG_TX]

you will need to break down the logic to get the populated values in a branch of your view... then the null values in another branch w a different join... then union the results from both subsets of data.