Skip to Content
author's profile photo Former Member
Former Member

Object table: classification extraction?

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2006 at 01:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.