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

[Former Member]

I was unaware of the VC specific extractors. Do you know where I can find out more about them or have any advice on how to set them up?

Thanks,

Paul

[Former Member]

Eric,

I am a colleague of Paul's. We used CTBW to create the data source with our VC characteristics and were able to extract this data to an infocube. The datasource that was created, though, does not seem to have any key figures (e.g. requested quantity) or date characteristics included. Do we have to add these manually after the CTBW creation or is the intention of this functionality to extract this data as-is and use the sales order and SO line items as keys to pull this information into an ODS and join it with a separate normal sales order extraction?

Sean Mawhorter

[Former Member]

Exactly, the objective is to bring in general VC information per order/line item and then combine it with anything else you might need.

I have an old post on this subject right here:

See if it helps.

P.S.: I'm now on ECC6 though, and all issues mentionned with notes have been resolved.

Message was edited by:

Eric Blondin

[Former Member]

The sales orders are being created and changed in R/3. There are change documents for the variant configuration options but the changes don't show up as changes to the sales order.

We are pulling the data over to an InfoCube in APO.

Thanks,

Paul

[Former Member]

You are aware that VC specific extractors are available? You can configure it through CTBW in R/3.

[Former Member]

Hi...... where the change take place ..in R3 or in BW?

Regards

[Former Member]

If you extract the sales orders and the configurable materials and store in a ODS, then pls look at the change log table of the ODS where changes to the sales orders are captured and stored.

Ravi Thothadri