CVC creation only for products with data

[former_member374308]

Hi Experts,

We need to generate CVC from infocube data. Currently, we generate CVC for all product-customer combinations.

However, we dont want CVC where product does not have sales history or future sales orders.

Please let me know, How can we achieve this?

Thanks.

[Former Member · Accepted solution]

Hi Pratiksha

I am sure you would be have cube or DSO where you stores all the sales related information i.e. sale historyor future sales orders. You can create a small logic in APO BW transformations as below.

When you are loading the data into CVC infocube try to look up into this Sales DSO/Cube and only load the data into CVC infocube if you have product-customer information  Sales DSO/Cube. This will make sure you only receive valid combination into CVC infocube. This should be very easy logic to built in APO BW.

Please cross check from your side and let us know if this information helps you.

Thanks

Amol

[former_member374308 · Accepted solution]

Hello,

Is there any standard way to do this ?

Or I will have to write custom routine ?

Thanks.

[Former Member · Accepted solution]

Hi

You require to get the customer routine written by BW consultant which should be very easy few liner code.

If it solves your issue, please request you to close the thread.

Thanks

Amol