Find extractor for 0costcenter

[Former Member]

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

[dennis_scoville4 · Accepted solution]

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.