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

Find extractor for 0costcenter

Hi

m tryin to learn how to find which extractor is used for 0costcenter in r3

in bw side i have narrowed it down which datasource is used and what fields are coming in for it

what i did

i wen to source systems in Modelling, selected R3 source system

and find the Datasource for 0costcenter

here i get the idea which field are coming to BW from R3, which bw infoobject it is assigned to?

now i loginto r3

Q1 i want to understand which extractor is used for this datasource

Q2 what fields are selected

Q3 what are underlying database tables

Q4 what attributes?

basically every flow?

pls help

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 03, 2009 at 07:02 PM

    Q1 i want to understand which extractor is used for this datasource

    There are potentially three extractors (DataSources) for 0COSTCENTER that you can use. They are 0COSTCENTER_ATTR for Master Data Attributes, 0COSTCENTER_TEXT for Master Data Texts and 0COSTCENTER_0101_HIER for Master Data Hierarchies.

    Q2 what fields are selected

    You can view the fields being extracted for the DataSources by going to tcode RSA2 in your source R3/ECC environment, enter the name of the DataSource you want to view, click on the Display button and when it brings you into the BI Service API screen, go to the Fields tab.

    Q3 what are underlying database tables

    The data being extracted for the 0COSTCENTER_ATTR DataSource is R3/ECC table CSKS. For 0COSTCENTER_TEXT, the source is R3/ECC table CSKT. I don't recall the source for 0COSTCENTER_0101_HIER, so you may have to use RSA3 in debug mode to step through it to determine the source table(s) in R3/ECC.

    Q4 what attributes?

    The attributes associated with 0COSTCENTER are part of the 0COSTCENTER_ATTR Master Data Attributes DataSource.

    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.