How to calculate key figure values based by referring another z-tables and another ADSO

[Former Member]

Hi Experts,

We have a requirement like below.

1. First we have created one query(input ready) for Cost center Vs Statistical Key figure which is stored in one ADSO1

2. Then we have created another query(Input Ready) Cost center Vs Activity Type which is getting and storing data in another ADSO2

3. Then we have created another query for Cost center VS Cost element which is getting data and storing into ADSO3

all these 3 queries output we are putting in work book with different sheets.

In the 3rd query we have 5 extra key figures which are not coming from Source system.

Out of these 5 key figures 3 are input enabled. which are working fine

Structure like below

CC | CE | Unit | KF1 | KF2 | KF3 | KF4 | KF5

CC1 CE1 KG 10 20 30 =30*ADSO1-QTY = KF1*KF4

CC1 CE2 LT 6 10 60 =60*ADSO2-QTY = KF1*KF4

here for KF4, first we need to check one master data table with combination of Cost center and Cost element, in this it will assign one activity or one SKF .

If Activity s assigned then get quantity from ADSO2

IF SKF is assigned then get the quantity from ADSO1

This is our requirement, how can achieve this requirement

Could you kindly help me

Thanks and Regards,

Harish.K