on 09-16-2006 7:38 AM
hello experts,
i am trying to extract classification data for materials in the material master.
When i try to create a datasource for the same in the transaction CTBW, it asks me for a object table. What is this? how do i know the correct object table from the displayed list?
there are different class types, classes and characteristics for each class. Do i need to create a different datasource for each class type?
how to link the transaction data to these characteristics in BW? i.e for eg: how to have these captured from sales order transaction in R/3?
Detailed answers will definately will rewarded...
thanks a lot in advance.
Hi S B,
The object table is nothing but the master table. I have donethis for many cases. Eg: When I made the extractor for material classification, my datasource was 0MATERIAL_ATTR and my object table was MARA. Similarly, when I was enhancing the vendor classification, the datasource was 0VENDOR_ATTR and the object table was LFA1. So, in all these cases as you can observe, the object table is nothing but the master table. One more point here is that classification is maintained for master data like material, vendor, customer, Internal Order, Sales Order etc. So, if you want to get the Sales Order classification, take the master data source for the same and find the master data table from R/3 as the object table. I have a document which can be of use for you. Please give me your id and i will pass it on to you.
Hope this helps.
Thanks and Regards
Subray Hegde
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Subray,
thanks a lot for the same. My mail id is sb_sdn@yahoo.co.in
Please send me the doc on the same.
Also what should be the datasource type for material master & what should it be for sales order?
If i have reporting requirement for these characteristics based sales reporting, which datasources i need to create( i.e which among 0material_master or sales order).
As these characteristics are assigned in the material master classification view & also selected in creation of sales order?
how do i go ahead with such reporting?
Thanks in advance..
Hi SB,
Please check your inbox for the document.
Coming to the data source type, it should be ATTR. generally, we build the classification datasources based on the *_ATTR datasources.
Regarding your requirement, since you can see the classification you want in the material classification, you need to create this extractor for material master.
Hope this helps.
Thanks and Regards
Subray Hegde
Hello Subray,
thanks a ton for the same.
We have for a single material under a particular class type, under a particular class->multiple characteristics with one value(out of the multiple values for those characteristics)assigned.
for eg: for a material xxx, class type 023, class abc:
characteristics A,B,C,D.
Each characteristic has multiple values possible. but for material xxx there will be only one value for each of this charateristics A,B,C,D assigned at one time.
Now when i try to create a datasource in CTBW, i get the error:
=========
Object type is not a sheet type in the class type
Message no. CLBW024
Diagnosis
A class type with several object types can have several object
hierarchies. All characteristics for objects that are not end node
objects are usually multi-value.
System Response
Multi-value characteristics cannot be extracted.
========
i have selected 0MATERIAL_ATTR as basis datasource, client 100,class type 300,obj. table MARA,Datasource type as ATTR.
can you suggest whre i am wrong?
thanks,
S. B,
I am getting the same error 'Object type is not a sheet type in the class type
Message no. CLBW024' like yours. How did you fix this problem, please ?
Do we have to implement OSS Note 535370 to change the Error Message to Warning message? If 'yes', did you find any difficult while implementing it ?
Could you please send the documents that you have received on this issue to me at venkat_kodi@yahoo.com ?
Thanks in advance.
Best Regards.
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.