Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to report on SAP SET Articles

Ladies and gentlemen,

does anybody of you have experiences with reporting on SAP SET articles? I would like to have a look on ECC and QlikView side.

In our company the process is as followed:

STEP 1:

SET Article in customer orders includes all components that make up that set including row which stands for SET itself.

Example:

(1) SET x = Amount 1, Value 100, Costs 90

(2) article y = Amount 1, Value 0, Costs 0

(3) article z = Amount 1, Value 0, Costs 0

(4) article aa = Amount 1, Value 0, Costs 0

STEP 2:

(1) SET x Article is being billed and only this one is in the invoice.

And now -> our controlling departement wants to see costs on all the rest of the positions (2 - 4), which revenue we made with each product/article, NOT set.

Is there any possibility to redistribute the values and drag the positions from order into invoice for this analysis purpose?

How would you design this issue?

Thank you very much in advance

Regards

Stan

1 Reply
Not applicable

Re: how to report on SAP SET Articles

Anybody seems to be interested in this issue "Pricing of BOM".

I found on the internet just only for SAP specific solution - You can read it at:

http://scn.sap.com/docs/DOC-32501

OSS 844141

http://help.sap.com/saphelp_40b/helpdata/en/93/743505546011d1a7020000e829fd11/content.htm

Community Browser