cancel
Showing results for 
Search instead for 
Did you mean: 

configurable material

Former Member
0 Kudos

Dear SD Consultants,

i`m using the configurable materials so can any one tell me which data base table the characteristics and the values of the characteristics that were entered in the sales order are stored?

Regards,

Sd Consultant

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Get VBAP-CUOBJ for the sales doc item and call the below function. The table named :attributes" will return the characteristics and thier values

CALL FUNCTION 'CUD0_GET_VAL_FROM_INSTANCE'
       EXPORTING
            instance           = VBAP-CUOBJ
       TABLES
            attributes         = lt_conf
       EXCEPTIONS
            instance_not_found = 1
            OTHERS             = 2.

As for tables that store the characteristics, you can join them like below to get the characteristics and their values

AUSP-OBJEK = VBAP-CUOBJ

If not in AUSP, then stored in as per the joins below

IBIN-INSTANCE = VBAP-CUOBJ

IBINVALUES-IN_RECNO = IBIN-IN_RECNO, 

IBSYMBOL -SYMBOL_ID = IBINVALUES-SYMOBL_ID

Former Member
0 Kudos

Hi,

Please go through the below link.

[VC Question|;

This question has been answered many times.Please search in the forum.

Regards,

Krishna.

Former Member
0 Kudos

Hi,

First Goto SE11/SE16 T.Code.

Enter the table name as "VBAP".

Enter the order number in the field "VBELN",Execute.

Select the line item you need.

Click on display.

Fetch the value of "CUOBJ".

Make a note of it.

Goto SE37 T.Code.

Enter the function module name as "VC_I_GET_CONFIGURATION".

Enter the Instance as the value of the CUOBJ you have noted earlier.

Execute.

Check in Tables tab in the same screen against the field "Result:"

Click on Details View/Edit.

The configuration values will be viewed for your material here.