Question Re: restrict the characteristic in the query in Supply Chain Management Q&A https://community.sap.com/t5/supply-chain-management-q-a/restrict-the-characteristic-in-the-query/qaa-p/11240342#M150677 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I already replied in your other thread..</P><P></P><P><A __default_attr="3787309" __jive_macro_name="thread" class="jive_macro_thread jive_macro" data-orig-content="special aggregation in the query" href="https://community.sap.com/"></A></P><P></P><P>Regards,</P><P>Loed</P></BODY></HTML> Thu, 20 Aug 2015 02:20:05 GMT Loed 2015-08-20T02:20:05Z restrict the characteristic in the query https://community.sap.com/t5/supply-chain-management-q-a/restrict-the-characteristic-in-the-query/qaq-p/11240341 <HTML><HEAD></HEAD><BODY><P>I have two characteristic: <SPAN style="font-size: 13.3333330154419px;">characteristic#1 and <SPAN style="font-size: 13.3333330154419px;">characteristic#2.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">I explain with an example in report.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">if there are two strings:</SPAN><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 348px;"><TBODY><TR><TD class="xl24" height="19" width="74"></TD><TD class="xl25" style="border-left: none;" width="108">characteristic#1</TD><TD class="xl25" style="border-left: none;" width="108">characteristic#2</TD><TD class="xl25" style="border-left: none;" width="58">Summ</TD></TR><TR><TD class="xl25" height="19" style="border-top: none;">String_1</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1071</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1023</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">523,123</TD></TR><TR><TD class="xl25" height="19" style="border-top: none;">String_2</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1071</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">1071</TD><TD align="right" class="xl24" style="border-top: none; border-left: none;">578,123</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P>In the report should appear only String_2.</P><P>ie rule - show data in the report, if the characteristic#1 = characteristic#2.</P><P></P><P>How to set up such a restriction query?</P><P></P><P>Respectfully yours, Pavel</P></BODY></HTML> Mon, 17 Aug 2015 16:45:14 GMT https://community.sap.com/t5/supply-chain-management-q-a/restrict-the-characteristic-in-the-query/qaq-p/11240341 Former Member 2015-08-17T16:45:14Z Re: restrict the characteristic in the query https://community.sap.com/t5/supply-chain-management-q-a/restrict-the-characteristic-in-the-query/qaa-p/11240342#M150677 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I already replied in your other thread..</P><P></P><P><A __default_attr="3787309" __jive_macro_name="thread" class="jive_macro_thread jive_macro" data-orig-content="special aggregation in the query" href="https://community.sap.com/"></A></P><P></P><P>Regards,</P><P>Loed</P></BODY></HTML> Thu, 20 Aug 2015 02:20:05 GMT https://community.sap.com/t5/supply-chain-management-q-a/restrict-the-characteristic-in-the-query/qaa-p/11240342#M150677 Loed 2015-08-20T02:20:05Z