Sales order extraction and variant configuration

[Former Member]

We use DataSource 2LIS_11_VASCL to extract sales order data from R/3 and have recently started using configurable materials. We enhanced the extract structure to contain customer-defined fields and populate them with the characteristic values of the configured material using a user exit that calls the function module 'VC_I_GET_CONFIGURATION'.

The problem is that when the configured options for the material on the sales order are changed the reversal record in the DataSource does not contain the original characteristic values.

Eg. Sales order is created for configurable material 1234 with colour characteristic 'red' and quantity 100

==> DataSource receives record for material 1234, colour 'red', quantity 100

The colour characteristic is changed to 'yellow' and the quantity on the sales order is changed to 120.

==> DataSource receives reversal record for material 1234, colour 'yellow', quantity -100 and changed record for material 1234, colour 'yellow', quantity 120

The net result in the BW system is for the data to be split between the two colours; 100 for 'red' and 20 for 'yellow'.

Can you suggest a way for us to get the old characteristic values on the reversal record?

Thanks,

Paul

[Former Member · Accepted solution]

This can be done, will have to be coded though. Two data sources 2LIS_11_VASCL and a 1CLxx. Load them into separate DSOs. Create an End-routine between the LIS DSO and the target DSO. Look up the VC DSO (yes, dont merge by loading) and Delete new delta records (-100 RED , +120 Yellow) from the package while appending +20 Yellow by doing simple math for every row. Leave the existing +100, Red in the target datasource. But, Remember to keep the Color as the key in the Data target (DSO), otherwise records get collapsed.

<i>But, this exactly is what BI should <u>not</u> do - Generate Data. I would first attempt to change the process. Shouldnt we be creating a separate order for 20 Yellow items..</i>

Thanks

Anand