cancel
Showing results for 
Search instead for 
Did you mean: 

When KF value only provided at higher level and not at more detailed level

Former Member
0 Kudos

Dear Experts

I have a multiprovider consisting 2 DSOs:

1. DSO for price.

Eg.

Char-A__Char-sub1___Char-sub2___KF_PRICE

AAAA__ AA11________AA22________$10

AAAA__AA11_________AA23_______ $17

As shown above, AAAA is made up of 2 sub-items AA22 and AA23 , each priced differently.

2. DSO for Qty

Char-A____KF_QTY

AAAA_____200

As shown above, this DSO for quantity does not have sub-item qty. What should be the quantities for each sub-item? Its always exactly the same as the Qty at Char-A level . Eg. 200 pieces of AAAA is made up of 200 pieces of AA22 and AA23.

The user wants to drilldown to sub-item levels to see Price X Qty.

I tested, when not drilled down to these levels, the display and figures are correct.

But when drilled down , the report will have additional line for each record due to the fact that the Qty is not at sub-item level.

So, qty will be shown in another line and the price will be on the line with the sub-item.

How can this situation be resolved using BEx? Else, I would use staging to resolve this. But I am hoping BEx level can resolve it. If staging is used, I would need to copy the same qty to each sub-item for each record by adding qty field into Price DSO or union the 2 DSOs into 1 DSO. But I thought Multiprovider is already a Union?

Kindly could you provide me some advice, clues or opinion?

Thanks in advance.

My Best regards

Pascal

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

This issue can be resolved by using constant selection

For step by step approach please refer the below pdf.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70dcd7b5-6a3d-2d10-c984-e835e3707...

Hope it helps.

Regards,

AL

Former Member
0 Kudos

Dear AL

Thank you so much!

regards

Pascal

Answers (0)