Issue in query structures

[Former Member]

Hello Guru's,

I have accounts for company codes like beolw

Company Code Account number Balance

1000 9400 1200

1000 5100 1250

1001 9400 2000

1001 5100 1500

1002 9400 3000

for this i need to calculate the items based on group of Account number

Tax( for company1000) = 9400(account number) + 5100 (account number) = 2450( balance)

Tax( For company is 1001) = 9400 = 2000 ( balance)

Tax ( For campany 1002) = 9400 = 3000( balance)

for this requirement i created a Structure in that i created a new selection characteristic with restricting the account number with 9400, 5100 but i get the balances like

Tax( for company1000) = 2450( balance)

Tax( For company is 1001) = 3500 ( balance) ( wrong value)

Tax ( For campany 1002) = 3000( balance)

please help me in this ....

Thanks,

sneha

[rajkumar_kandula · Accepted solution]

Take Balance as an aggregated key figure with agrregation type Summation of account number and reference characterstic as Company code

[Former Member · Accepted solution]

thanks for quick reply ...

can you please tell me how to do this.

Thanks,

Sneha

[rajkumar_kandula · Accepted solution]

Hi,

TO create that KF you have to define a calculated KF on that accounts KF,

In its aggregation tab, use aggregation tab as SUMMATION and reference characterstic as ur char name

For more info refer

http://help.sap.com/saphelp_nw04/helpdata/en/82/f2dc37f0f12313e10000009b38f8cf/frameset.htm

[Former Member]

Is the property of the account number = suppress results total = never?

Placing the subtotal property setting on the column to the right of where you really want the total to be (right of company code) usually works.

If the above is not correct, then drilling across by the account number (placed above the key figure object) might generate what you are looking for.

Edited by: Sharon West on Dec 11, 2008 11:20 AM

[former_member181964]

Hi,

Company Code Account number Balance
1000                  9400                 1200
1000                  5100                 1250
1001                  9400                 2000
1001                  5100                 1500
1002                  9400                  3000

Create a Restricted Key Figure or New Selection in and name as Tax for Comp 1000 and then drag Account No. and and restrict with 900,5100 and take Balance Keyfigure.So finally your Restricted Keyfigure or Selection is having 2 components, 1. Account No, and Balance.

So in the same way you create anothet RKF or Selction and name Tax for Comp 1001 like that you can do.

Thanks

Reddy

[Former Member]

hello Surender,

As you said we can create individually i have arround 60 items to calucalte like this so i need to create total for three comapny codes around 180. thats why i am asking is there any other solution for this.

Thanks,

Sneha