Query Modeling Scenario

[Former Member]

HI All,

Here is a scenario i am trying to model in a Bex Query.

Original Record set

Customer Material Value $

ABC XYZ 100

ABC EFG 200

ABC HIG 300

CBA XYZ 100

LMN XYZ 100

The requirement is to find all customers who have ONLY purchased Material = XYZ and no other product. This means that Customer ABC who has Purchsed XYZ is to be excluded from the results since he has bought other products also.

The result of the query should be

Customer Material Value $

CBA XYZ 100

LMN XYZ 100

Please help how to model this query. Points galore for people who has a solution....

Thank You

[Former Member · Accepted solution]

Try this solution:

Build three 3 figures:

KF 1 : $ value

KF2 : Restricted KF with $ value and restriction on Material = XYZ

KF3 : Formula (KF2 minus KF1)

Put a condition on KF3 to display data only where KF 3 is zero.

In your scenarion for customer ABC KF3 will be not equal to zero and so will not be displayed as it does not match the condition.

hope this is helpful.

Cheers

Amol

[Former Member · Accepted solution]

Hi Amol,

That is one way of doing it. The requirement is to pass this data onto a external system and i cannot use Conditions. Thanks for trying. I have given points

[Former Member · Accepted solution]

Hi,

Try using Virtual Charecterstics, with the help of virtual Charecterstics you can get the exact Value.

That will reslove your issue.

all the best.

Regards,

Nagesh Ganisetti.

*Assign points if it helps.

[Former Member · Accepted solution]

How do i configure Virtual Charachteristics in a query?? I havent used it before. Please shed some light on it....

Thanks

[Private_Member_9643 · Accepted solution]

Virtual key figures are key figures within an InfoProvider that are not filled with data. Instead the key figure value is determined at runtime of the query using custom ABAP coding (the same is true for virtual characteristics)..

Some coding samples:

[Former Member · Accepted solution]

Also, in the scenario i presented, i dont know how Virtual Charachteristics will help me...

[Former Member · Accepted solution]

Good Question!

To my understanding of the BW system, you can use the selection in the while calculating the Virtual Charecterstics. It looks very much possible to me.

Also look in the front-end also.

I will try this and let you know.

All the best.

Regards,

Nagesh Ganisetti.

[Former Member · Accepted solution]

Thanks Nagesh...please let me know if you get time.....i need to do my blueprinting and this is the only thing holding me up