Variant Configuration Extraction to SAP BW

[Former Member]

Where can I find documentation about Variant Configuration Extraction to SAP BW ?

Thanks in advance for your help !

[Former Member · Accepted solution]

I suppose you mean the configuration of f.e. materials, orders etc.  Like classification?

If so: use txn CTBW in ECC.  I recently answered a few topics about this.

It's easy to use, really.

[Former Member · Accepted solution]

Thanks for your reply.

It's about the configuration of an article in SD (the link is VBAP-CUOBJ). The field VBAP-CUOBJ_CH is not filled. So, this is not about batch data ?

The best solution is probably creating a new datasource for this data.

The funtion for retrieving the data from the configuration is VC_I_GET_CONFIGURATION_IBASE.

[Former Member · Accepted solution]

How it works:

first you have to figure out on which  datasource you want to extract the var. config.

On which object is the configuration defined?  Is it sales order?  Then you could use 2LIS_11_VAITM, is it on material, then you could use 0material_attr etc.

Then: go to txn CTBW (in ECC).

In basis datasource fill in the datasource from above, client = client, class type = 300 (for variants), the object table is dependent on what you are extracting (for batch f.e. MCHA or MCH1), and then if it is a master data or transactional data datasource.

Then add characteristics and save.

This will generate a new datasource (1CL_...) and can be loaded in a standard way.  Create a transformation for it etc.

[Former Member · Accepted solution]

Thanks a lot for your help ! 🙂

[former_member186445 · Accepted solution]

a step by step can be found here:

http://affine.co.uk/cms/uploads/How_to_Extract_Classification_Data_into_BW.pdf

[former_member188080]

Hi,

check following links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0a8b9c1-dee5-2d10-feb5-9b0d54126...

http://help.sap.com/saphelp_nw70/helpdata/en/44/761894e2bb18e8e10000000a1553f7/content.htm

Thanks and regards

Kiran

[Former Member]

There is a blog on this just posted recently in SCN:

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

[former_member182470]

Hi,

What exactly you are looking for? You mean Fiscal Variants or delta Variants?

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

Regards,

Suman