classification datasource creation in CTBW

[Former Member]

Hello Experts,

1.In the transaction cTBW, i can see few characteristics already added in the first screen for Basis datasource 0MATERIAL_ATTR.When i try to add few characteristics to these characteristics, the newly added characteristic appear with "N" value in the Main.Stat column(prev characteristic have "R" in this column).

2.if i save this, i can see datasource names generated in the characteristic datasource col. for those characteristics which have type char. The ones among the newly added characteristics with Typ "K" dont have a characteristic datasource name generated!! What should be done?

3. If i delete such char with type "k" and still try to save, it get saved. But when i generate datasource, it gives messages "datasource ""created successfully" for all the this newly added characteristics(with type "C") and at the end gives a message "The extract structure is not permitted". What is the problem?

4. if i check 1CL_OMAT001 in rsa3, i cannot see the newly added characteristics columns. Only the ones existing from before( with value "R" in Main.Stat column) are seen with some values. How to have the newly added characteristics also seen here?

Please suggest....

thanks,

[Former Member · Accepted solution]

1 - R appears after the DS with these characteristics has been generated successfully. I would say do not worry what appears there.

2 - You have a DS for the set characteristics (1CL_OMAT...), and then individual DS for each attribute (for possible master data). Say - there is a classification char COLOR for material. Now you may have COLOR value 1,2,3 in the main DS (DS contains material & Color), and you may have another DS for color master data (eg - Color & Text - 1-blue, 2-red, 3-green and so on). This secondary DS(s) are not of your primary concern and you can ignore these if you do not want them.

Now, a master data can exist for a char type (eg color) but not for a K type (eg Weight), hence you do not see these rows with a DS name assigned. Again, this is as expected. You will have these chars and KFs in the main DS.

3 - The message you are getting can be due to various reasons, you will have to debug and try to find. Some of the likely reasons are

- The client is not open for repository object creation (can you create a program in this client)

- You do not have sufficient authorization (do a SU53 immediately after you get this error)

4 - You are seeing the last activated structure. Since your modifications have not been activated yet, you are seeing the old version. You will need to figure out and fix the error in 3 above and generate the changed DS before you can use it in RSA3 and elsewhere.

[Former Member · Accepted solution]

hello Ajay,

thanks again.

i will get back to you in case of further issues.

One small doubt:

i have class types 001(material class),300(variant) with different characteristics with one value per material in the material master. Now the chars(as u said earlier) under class type 300 are seen in sales order and those chars under 001 are not seen in sales order.

i would like to know that why do i need to extend sales order datasource to capture values of characteristics under class type 300 separately? why cant i capture the values in the 0material_attr datasource enhancement(ctbw)only. the values in both cases will be the same for that material.

i can always do reporting using these characteristics(under 300) as attributes in material master for any transaction data like sales orders, or billing(for reporting sales) etc.

thanks,

[Former Member · Accepted solution]

When you run the extractor for the DS, it will bring data (eg delta) based on changes to the object linked through the object table (MARA Versus VBAP).

When you use variant config data, you specify the characteristic values associated with a material in a sales order. (For example you will say that for this sales order for DELL/INSPIRON, memory characteristic value is 512MB; now this is variant config data; you may have the same product/material with value 1GB in another sales order). How will this link to a Dell/Inspiron material master data in MARA? It will not.

You may need to understand whether you want the variant config data, or the classification data.

The link through CTBW is this - it links the records to be selected based on the key fields of the object table. Object table in case of material_attr (and class 001) will be Material_no (so any material that has changed will be captured in delta); whereas sales order based DS (class 300) will capture delta based on what sales order/item have changed/created.

It all goes back to what you are trying to extract. whether you want the variant config data (eg sales order A - car color - blue, sales order B - car color red); or material master data (Car A - color blue, Car B - color red) will determine what class type and base DS you should use.

[Former Member · Accepted solution]

Hello Ajay,

Thanks again and again for such brilliant responses.

i am still trying to figure out the problem "extract structure is not permitted". i also checked the structure /1SAP1/CLS_OMAT001 which only shows the characteristic which were existing from before and does not show my newly appended characteristics. also the characteristic datasources(text datasources) for the newly appended characteristics have been created and show records in RSA3!!.

I have checked the authorisations which are correct and also i am having a ABAP developer key login. So no issues with that too.

any other reasons you can think of? i am trying this in the IDES system and have created a package for saving this changes. should it be $tmp? Maybe the earlier chars added were in $tmp?

will get back to you in case of further issues on the same.

thanks again..

[Former Member · Accepted solution]

Try to modify this structure in SE11 (/1SAP1/CLS_OMAT001) to see if you get the same error. It could be that it is an SAP generated one and is somehow in an inconsistent state.

You can recreate a new DS in CTBW with same base DS /class type etc and include any characteristics you wish (including ones that exist in the existing DS). Do this by creating a new row in the main CTBW screen and then adding chars to it. Try to save and generate. If it works, you can leave the existing one as it is.

[Former Member · Accepted solution]

Hi Ajay,

Could u please guide me ?..We have a requirement to extract variant configuration data at transactional level ( from sales order). so what should be the entries i need to input in CTBW to create datasource? would below entries work?

basis datasource :2LIS_11_VAITM

class type : 300

object table :VBAP

Datasource type : TRAN

I am getting an error "Class type not defined for this object type" when i enter the above entries in CTBW.As a prerequisite for doing the above, do we need to maintain "VBAP" table in configuration in View "V_CLAO"against class type 300?

Thanks for any guidance in this regard

Ganapathi shenoy