on 11-16-2011 10:39 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.