Skip to Content
0
Jul 02, 2020 at 02:38 AM

Deriving a characteristics at BEX Report level

109 Views Last edit Jul 02, 2020 at 02:44 AM 4 rev

Dear Experts,

We'd a certain Requirement - Where a characteristic is to be derived based on Key figures & Character

Scenario is as like below.

In the below mentioned cross tab "Character to be Derived " column to be derived based on below mentioned condition

a. if Reaso = # & Order Qty = Invoice qty then Character to be derived as 'Y' else #

OrderNo OrderItem Reaso Charactertobederived OrderQty InvoiceQty

O1 10 X X 10 0

O1 20 # # 10 5

O2 10 # Y 10 10

Thanks

-Ram