How to control different acct number in Bex Query Designer

[Former Member]

I have created 1 income statement using query designer which in the column has key figures such as company code, Amt and Fiscal year/period. Each column represent different company code. Example column 1 represent company A, column 2 represent company B and column 3 represent company C.

In row, i have sorted the account number and categorised it as below item:

- Admin Expenses

Acct no 10000

- Other Operating Expenses

Acct no 10000

Total

For company A, and C, the acct no 10000 should appear in Admin Expenses.

For company B, the acct no 10000 should appear in Other Operating Expenses.

How do i control these account number to be appear in different item for different company?

Thank You and Best Regards.

[Former Member]

Hi,

You can do that using constant selection,

[http://help.sap.com/saphelp_nw70/Helpdata/en/46/91f0f090ea13e8e10000000a155369/content.htm]

Regards,

Durgesh.

[former_member182470]

Hi Charlie,

You have restrict your Key Figures by respective Codes. Eg: KF1, restrict with Company Code A, Account No. etc..

Repeat the same for all the KF's. Then your KF's will display the values pertain to the resopective restriction.

Regards,

Suman

[Former Member]

Company A, Company B and Company C have same accout no which is 10000 but in report they appear in different line item. So in line item admin expenses, the amount for gl account 10000 should appear for company A and company C but for company B should appear as 0 value. While in line item other operating expenses, the amount for gl account 10000 should appear for company B and but for company A and C the gl account amt should appear as 0 value.

Please guide me.

Thank You and Best Regards.

[former_member182470]

Hi Charlie,

Step 1: Try using Constant Selection for the AC.NO 10000 for A and C based on Admin Expenses.

Step 2: Use Constant Selection for the AC.No 10000 for B based on Operating Expenses

Hope this helps........

Regards,

Suman

[Former Member]

Thank u for the fast respond.I have tried using constant selection and the result comes out like table below. The actual result that i want the report to appear is as Table 2. Appreciate your help.

Table 1

Company A Company B Company C

Admin Expenses

- Acct no 10000 100 300 700

Oth operating expenses

- Acct no 10000 100 300 700

The actual result should appear as below table:

Table 2

Company A Company B Company C

Admin Expenses

- Acct no 10000 100 0 700

Oth operating expenses

- Acct no 10000 0 300 0

Thank You and Best Regards.

[former_member182470]

Hi,

I think you have considered all three A, B & C in both Admin Expenses Constant Selection and also in Operating Expenses.

Please go through my earlier post again and check whether you have followed the same?

Do Constant Selection for A and C by restricting Admin Expenses

Do Constant Selection for B by restricting Operating Expenses

Regards,

Suman