Skip to Content
0
Former Member
Nov 10, 2009 at 06:17 PM

IP Characteristic Relationship used via Filter for derivation in Query

552 Views

Hello Experts,

hopefully you can help me with following issue:

Currency is an Attribute from Company. I created a Characteristic Relationsship to derive Currency from Company

Afterwards I created an Aggregation Level with fields

Currency, Company, Material, Amount, Quantity, Unit.

On this Aggregation Level I defined a Filter with Company which will be filled from a Variable (Replacement Path, Query, single value).

I use this Filter in a Ready-Input Query and defined it like follows:

Rows: Amount and Quantity (restricted to TO)

Column: Material and Currency

The field currency should be filled automatically with Currency from Company but it did't. Due to this the Query is not ready input.

I know that it can be filled via User Exit but this is my last solution if nothing else is working. A Variable with Replacementh path and filled by Attribute of Company does not solve my issue.

Thank you in advance for any help.

Kind Regards

Doris