Find Table for SQ01: statistic of Variant Configurator (SO, Characteristic, Values)

[Viktoria]

Hi, I need to create a Report in SQ01: Enter a Period of time and VC Part Number and get a list of SOs with Characteristics and Values (from Variant Configurator). It would be very useful for our statistic.
A transaction that give me some of required information is CL30N (Find Objects in Classes) - I can extend the layout to display all Characteristics (not only Chars and Values used in Search) and will get a report, where SOs, all Characteristics and Vales are displayed. Unfortunately I cannot set a time limit here to get a list of SOs for e.g. last year. I can not find a table used in the Transaction CL30N with button F1...
I found a SQ01 Report with tables VBAP, VBAK and additional fields Z_CH_NAME and Z_CH_DESC 1 till 18 that is almost what I need, but columns of Characteristics have name "Ch Val 1", "Ch Val 2" etc., not the description from the VC.
Could you please help me to find the solution?

[ai4retailers]

Hi 

You could try using the table CUOBJS, joining VBELN and MATNR from VBAP, and restricting on AUDAT from VBAK!?

[raymond_giuseppi]

Isn't CUOBJS a structure not a table?

[Viktoria]

Thank you for the answer! I am just at the beginning to learn how to program SQ01. CUOBJS is a structure: can I use it? I have not seen any Characteristics and values from the Variant Configuration in CUOBJS andf VBAK. Do you know any table with VC Chars & Values?

[ai4retailers]

REPORT Z_GET_CONFIGURED_MATERIAL. DATA: lv_sales_document TYPE vbak-vbeln, lv_configured_material TYPE mara-matnr, lt_sales_order_items TYPE TABLE OF vbap, ls_sales_order_item TYPE vbap, lt_configured_materials TYPE TABLE OF mara-matnr, lv_error_message TYPE string. * Retrieve all sales order items for the specified sales document SELECT * FROM vbap INTO TABLE @LT_sales_order_items WHERE vbeln = @lv_sales_document ORDER BY posnr. * Iterate over each sales order item and retrieve the configured material LOOP AT lt_sales_order_items INTO ls_sales_order_item. CLEAR: lv_configured_material. " Determine the configured material based on characteristics using function module CALL FUNCTION 'DETERMINE_CONFIGURED_MATERIAL' EXPORTING IV_CHARACTERISTICS = ls_sales_order_item IMPORTING EV_MATERIAL = lv_configured_material EXCEPTIONS NO_CONFIGURATION_FOUND = 1 TOO_MANY_CONFIGURATIONS = 2 NO_UNIQUE_CONFIGURATION = 3 OTHERS = 4. IF sy-subrc <> 0. " Error handling lv_error_message = |Error determining configured material for sales order item { ls_sales_order_item-posnr }|. ELSE. " Add configured material to list for validation APPEND VALUE #( material = lv_configured_material ) TO lt_configured_materials. " Display the configured material for the current sales order item WRITE: / 'Sales Order Item:', ls_sales_order_item-posnr, ' Configured Material:', lv_configured_material. ENDIF. ENDLOOP. NB!! You should be more specific on your Variant configuration setup if you need a precise answer!

[Viktoria]

I checked mentioned tables, but could not find any Characteristic and Value assigned to SOs, only SO Numbers and Materials Numbers. Probably because I am not very familiar with the complex logic you described!? 😞 I need a table where Characteristics and Values (that where created in CT04) are assigned to SOs (configured VC), table like in CL30N.

[raymond_giuseppi]

Replace the F1-driven search with a SQL (ST05-Database access) or Abap (SAT-Database + FM/Classes) trace during execution of CL30N.

Consider also creation of a DataSet with SQ02 to add some Abap code to access/format characteristics.