Skip to Content
0
Dec 15, 2021 at 08:40 AM

regarding to delete duplicate column

122 Views

Hi All,

i have created a CV either using graphical or Script in hana, and have joined the 2 tables ekkn and ekbe based upon the po document number and year.

ekkn has only one item

po no item price

10002 10 105

ekbe has 2 lines for the same item

po no item posting date delivered price

10002 10 12/01/2020 80

10002 10 12/02/2020 10

i created an inner based upon po and item, and in the join the price is duplicated in 2 columns, (i can achieve the summation by removed the posting date, but the posting date is required in the report)

po no item posting date delivered price price

10002 10 12/01/2020 80 105

10002 10 12/02/2020 10 105

as you can see there since there are 2 line items in ekbe the price from ekkn is also repeated twice which is wrong.

i have created a calculated column (diff) which is the difference between price - deliver price

po no item posting date delivered price price diff

10002 10 12/01/2020 80 105 25

10002 10 12/02/2020 10 105 95

the diff ( calculated column) is wrong it should total of price 105 - total of delivered price (90) = 15.

How can we achieve this/?

thanks for your help in advance