Skip to Content
0
Jul 21, 2016 at 06:34 AM

Right Outer Joint in Calc. view

33 Views

Hi All, I have one scenario in calculation view . In left table ,I have 10 fields & in rgiht table ,I have one field ( AUFNR.) . Common field is AUFNR which is also key field .There are some records in left table which I want to exclude however I need to pick 9 fields ( column) from left table & 1 field from right table ( AUFNR ) . Example. say there are 50 records in left table while 40 records in right table . I need to pick only 40 records with one field from right table & 9 field from left table . Can I use right out joint with cardinality 1:1 Thanking you .