on 06-11-2007 11:50 AM
Hi all,
My requirement is
if more than one kondm 'material pricing group' has been found then select the kondm which is appearing
the most for this material in this table
example
matnr mat pricing grp
101 c7
102 c7
103 c1
104 c2
105 c7
then the value for 101,102,105 shud be displayed this is an just an rough example i don know the records
thanks and regards
patnaik
Hi,
Take MATERIAL & MATPRICE GRP as part of Keyfields of ODS. And take No of docuemnts sort of KF as part of Datafields. Give 1 as value in the update rule for No of docuemnts KF .
In the Query designer Take MATNR in rows and Take No of docuemnts KF in the columns .You should restrict the KF with MPGRP characterstic and take Constant property on this Charaterstic . And make condition like No of docuemnts sort of KF > 1.And Hide this KF column.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.