How to get Material from Variant

[Former Member]

Hi Guys,

Is there any standard process of getting Material from Variants? If i have Characteristic Name, Characteristic Value and Variant name, is it possible to find corosponding Material?

[Former Member]

Hi,

In FI (actually your query is for MM), in SPRO, in General Ledger, Master Data, there is an option for adding additional fields for line item display wherein there reference field are taken from BSEG. For material the combination can be BSEG-MATNR which can be further used for variant creation in FI.

Just check whether the same can be used or a similar functionality is available in MM.

Regards

Hari

[Former Member]

Hi Hari,

After doing research, we have boilled down to a solution but it also doesnt give any linkage of Variant to material.

Using standard SAP tables:

a) Go to table CUVTAN_VALC (CHAR format values for variant table) and provide input as Variant Condition in the field VALC, we will get VTINT (Internal Number of Variant Table) and ATINN (Internal Characteristic) as an output.

Note: Here VALC is Characteristic Value.

b) Go to table CUVTAB (Variant Table Basic Data), provide VTINT as an input to get VTNAM (Variant Table).

c) Go to t-code CU60 (Table Maintenance) and provide input as VTNAM, once we click on display we will get Characteristic Name, Characteristic Value and Variant Condition Name.

d) Get Variant Name and corresponding Characteristic Name, Characteristic Value. Go to table AUSP (Characteristic Values) and provide input as ATINN (Internal Characteristic), KLART (Class Type = 300) and ATWRT (Characteristic Value) to get OBJEK (Material Number).

Note: Variants data is not mentioned in AUSP table.

Problem: All Variant data is not present in AUSP (Characteristic Value) table.

[Former Member]

Hello Abhijeet,

I am a bit confused on what you are looking for but I believe you are searching Material Variants? You can want to know what configurable material is assigned to variant ? Can you please confirm.?

Material variants are finished goods that are assigned to configuratble material on the MRP view or Basic data view.

Configuration is separate to Classification. AUSP table is classification table but a configuration. Configuration is stored in IBASE tables.

The link of a material variant is done through MARC (mrp view ) or MARA (basic data view ).

Eg Material Variant = MAT_VARIANT (MARA-MATNR)

Configurable Material = MAT_CONF

Now to check what is assigned to the material variant MAT_VARIANT use table MARA (if assigned basic view)

MARA-MATNR = MAT_VARIANT

check for fields SATNR and CUOBF.

SATNR should be the configurable material MAT_CONF with a unique ID CUOBF. That CUOBF holds all the configuration information eg characteristic assigned to the material and all the values set for that variant. You can then use CUTABLEINFO enter that CUOBF in the field instance ..All the data is in that transaction. All the tables linked to configuration can be found there.

Now to check what is assigned to the material variant MAT_VARIANT use table MARC (if assigned MRP view)

MARC-MATNR = MAT_VARIANT

check for fields STDPD and CUOBJ.

STDPD should be the configurable material MAT_CONF with a unique ID CUOBJ. That CUOBJ holds all the configuration information eg characteristic assigned to the material and all the values set for that variant. You can then use CUTABLEINFO enter that CUOBJ in the field instance ..All the data is in that transaction. All the tables linked to configration can be found there.

IBINVALUES is the table that holds information for the characteristic values.

Hope that helps

Please let me know if I missunderstood it

Thanks

Amber

[Former Member]

Hi Amber,

Thanks for your reply, i have gone through the solution you suggested, but materials here which i have dont have values for SATNR and CUOBF.

I wanted to know the linkage of Variants to the corrosponding materials in SAP.

I had one more solution, but it also doesnt have any direct linkage.

go to table CUVTAB_VALC, once you execute it you will get combination of Characteristic name - Characteristic Value - Variant Name. Again go to CUVTAB_VALC put this Variant name in filed Internal characteristic and execute, you will get Internal table no and Combination no. Again go to CUVTAB_VALC and put these values of Int table no and combination no to get Characteristic Value.

This Characteristic Value has Material no in it.

But again there is no direct linkage where in you can find this material from Variant.

[Former Member]

Hello Abhijeet,

CUVTAB_VALC tables is entirely different thing to material variant. These are variant tables that are used in object dependcies which are then assigned to material . Are you looking for variant tables or material variants ? As these two are completely differemt things. There is not direct link of variant tables to material as variant tables is smply table with values that can be used n ODs

For table MARA-SATNR , if you dont have a value there then it means the material variant is plant specific which means assigned on mrp level. As I mentioned above You have values in MARA if variant is plant independent ie assigned on basic data view but if it is plant dependent then it is assigned on mrp and in this case you need to check MARC-STDPD and CUOBJ.

Please clarify what exactly are you looking for. Variant tables or Material Variants ?

Thanks

Amber

[Former Member]

Dear Abhijeet

What type of classification you have assigned i.e., is it a material master characteristic or quality inspection charecteristics

Please provide clear details

else refer to the tables below specified if material master class:

1 Characteristics :

CABN Characteristics ( o.a. batch/vendor)

CABNT Characteristics description

CAWN Characteristics ( o.a. material)

CAWNT Characteristics description

AUSP Characteristic Values

2 Class types and objects :

TCLAO Several class types for object

TCLA Class types ( vb. lfa1 => v10 en 010)

TCLAT Class type text

TCLT Classifiable objects

TCLC Classification status

3 Links :

INOB Link between Internal Number and Object

KLAH Class header data

KSSK Allocation Table: Object (vb.matnr) to Class

KSML Characteristics for a class (internal number)

[Former Member]

Hi Krishna,

I already have tried these tables, where in i used STPO and MAST tables to get Material Number. But this logic doesnt work for all variants which i have. i know how variants have been created in our SAP system, but there is no material linkage to the Characteristics Name and Characteristic Value of the material.