Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Constant selection on multiprovider with several infoproviders

<body><p>Hello,</p><p></p><p>We need to join five different kinds of data. First we planned using infoset, but as infosets don't accept LEFT OUTER JOIN with more than two tables we had to find another solution. 'Constant selection' should do the trick. But it's not stright forward.</p><p></p><p>To limit the problem I try the following:</p><p></p><p>Cube A (PO item) has the characteristics Sales document and Sales documet item, and the KF PO Order Qty.</p><p>Cube B (SO item) has the characteristics Sales document, Sales documet item and Sales Office, and the KF Sales Price.</p><p>Cube C (billing) has the characteristics Sales document, Sales documet item and Billing type, and the KF Billing Quantity.</p><p>All cubes have lots of other characteristics and key figures.</p><p></p><p>Initially I get this result from my query:</p><pre __jive_macro_name="code"><![CDATA[ Sales document SD item Billing type Sales Office PO Order Qty Billing Quantity Sales Price 206699 10 ZF2 # 3 # 3010 1226 # 3]]></pre><p></p><p>I want all the related key figures to appear in the same row, so we use constant selection to join the data. This is done according to documentation and other information found on constant selection:</p><p>&#91;http://help.sap.com/saphelp_nw70/helpdata/en/e7/5f983c1a356858e10000000a114084/frameset.htm&#93;</p><p>&#91;https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4478&#93 <b>[original link is broken]</b> <b>[original link is broken]</b> <b>[original link is broken]</b>;</p><p></p><p>On KF PO Order Qty we add constant selection on Billing type and Sales Office. On Billing Quantity we add constant selection on Sales Office. On Sales Price we add constant selection on Billing type. The result is not as expected:</p><pre __jive_macro_name="code"><![CDATA[ Sales document SD item Billing type Sales Office PO Order Qty Billing Quantity Sales Price 206699 10 ZF2 # 3 3 # 3010 3 1226 # 3]]></pre><p></p><p>If I simplify the query, joining only PO and Billing, removing Sales Office and Sales Price, with constant selection on Billing type for PO Order, then I get the expected result (i.e. on a single row):</p><pre __jive_macro_name="code"><![CDATA[ Sales document SD item Billing type PO Order Qty Billing Quantity 206699 10 ZF2 3 3]]></pre><p></p><p>Actually, it seems from the result with all three cubes that PO and Billing are joined as are PO and SO, but only separately! I therefore try another simplification. Only SO and Billing, with constant selection on Sales Office for KF Billing Quantity and on Billing type for Sales Price. I get the following result:</p><pre __jive_macro_name="code"><![CDATA[ Sales document SD item Billing type Sales Office Billing Quantity Sales Price 206699 10 ZF2 # 3 # 3010 1226]]></pre><p></p><p>Just as if there were no constant selection at all! What is wrong? This last problem seems to be the same as described in thread &#91;2552676|<a class="jive_macro jive_macro_message" href="" __jive_macro_name="message" modifiedtitle="true" __default_attr="2552676"></a>&#93;, but I find no solution to the problem there.</p><p></p><p>Please help!</p><p></p><p>Points will be assigned to everyone which can help me solve the issue.</p><p></p><p>Best regards,</p><p>Christoffer Owe</p></body>
Not what you were looking for? View more on this topic or Ask a question