Question:
Hi
I may be asking the impossible here. Does anyone know how to eliminate all records for an order by a characteristic of one of it's items? I am using BW version 2.1C.
example: I need to eliminate all Sales Orders that have been started.
The only way of identifying this is by an item which is created manually when we have started the order. These items have a specific item category and a pseudo material e.g. 'START'.
I can eliminate all sales order items with either the item category and/or material ='START' but not all the records relating to the order.
e.g. Order No. '1000', has 2 items:
item '10', item cat 'ZTAR', Material 'Part No'
item '20', item cat 'ZTAMR', Material 'START'
Order No. '1001', has 1 item:
item '10', item cat 'ZTAR', Material 'Part no.2'
in my report I only want to include the records relating to order no.'1001'.
Any suggestions?
Thanks
Jer1
Answer:
Before data loding is done, try Start Routine available in Update Rules to filter-out unnecessary records based on a certain criteria.
Answer:
Thanks for the reply suji.
I don't think I made it clear what I am trying to do.
I am trying to carry out this process in Business Explorer as part of a query or combination of queries.
I need the records in the infocube for other reports but need to filter them for this particular requirement.
Thanks
Jer1
Answer:
In that case make use of Filters and Restrictions.
Answer:
Thanks - that was where I went first but I have had another go -
created a new restricted key figure which gave a value >1 if the material = 'Stage1' and a condition which eliminated all records where the RKF>1.
Works great