cancel
Showing results for 
Search instead for 
Did you mean: 

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

Viktoria
Discoverer
0 Kudos

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?

View Entire Topic
ai4retailers
Discoverer
0 Kudos

Hi 

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

raymond_giuseppi
Active Contributor
0 Kudos
Isn't CUOBJS a structure not a table?
Viktoria
Discoverer
0 Kudos
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
Discoverer
0 Kudos
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
Discoverer
0 Kudos
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.