Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex Query - Show rows from another characteristic

Hi Guys,

I have a problem, I need to create a query to be displayed in Excel that shows accounting informacion by number, like this:

Account Balance

12110201 1 USD

12110202 1 USD

12110204 1 USD

.

.

.

That works so far, the problem is that I need to add 2 more columns and in 1 of the new columns I need to show only some accounts, like this:

Account Balance NewColumn1

12110201 1 USD

12110202 1 USD Balance of 12110202

12110204 1 USD

the other one is more challenging because it need to show informacion from a different account, like this:

Account Balance NewColumn1 NewColumn2

12110201 1 USD

12110202 1 USD Balance of 12110202

12110204 1 USD Balance of 2406910000

the first values came from my accounts tables that contain balance from sub accounts, but the value 2406910000 is in fact a sub account value.

Can some of you expers can help me on this? Is it possible?

Please help.

Former Member
Former Member replied

It will look like :

SubAccounts Amount NewCol1

120305010200 1 dll Amount for SubAccount 22110201

120305020000 1 dll Amount for SubAccount 22110202

120305020100 1 dll Amount fo Account 1209910000

120305020200 1 dll

120305030000 1 dll

120305030100 1 dll

120305030200 1 dll

No, it s not necessary that it will always look like that.

You can play around with Sort Values in Queries.

Put the Sort Ascending, change this property on Subaccounts

Play around with Sort property of Amount.

You can have the display like you need.

But i think, main point here is "Restricted Keyfigure", first if you are getting that result CORRECTLY or not.

Later on you can play around with Sort Option, Display result as etc. to make the display appropriate etc...

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question