Skip to Content

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

Bex Query - How to capture characteristic value and set it as filter value?

Dear Experts,

I would like to create a tricky report that listed sales quantity by companis. Companies consists of production plant as well as trading company.

Company / Sales Quantity / Sales Quantity 2 (which produced by Company itself)

A / 100 / 50 (50 was produced by company A)

B / 80 / 0 (this is a trading company)

C / 150 / 150 (All are produced by company C)

First I thought of using variable to capture Company value and then under Sales Quantity 2 I set producing company = this variable. But this only works if I filter company values. Any workaround idea that I can get the above with all the listing of companies?

Any assistance would be great! Thanks!

JL

Former Member
Former Member replied

Hi,

Have you tried elimination of Internal business Volume?

http://help.sap.com/saphelp_bw32/helpdata/en/d5/784d3c596f0b26e10000000a11402f/content.htm

Impliment this solution by adding another KF Sales qty2. with ref. to Sales qty.

In characteristic pair you can have Company and Production Company(navigational attribute).

By implimenting this solution the system will eliminate if the quantity is produced by the company it self. You can create CKF in query to get the result you need.

Jaya

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question