Standard extractor

[Former Member]

Gurus,

Is there a complete documentation on what is the purpose for each of the SAP standard extractor? Like what does this extractor do etc.

Please advice, thanks!

[Former Member · Accepted solution]

Dear PM,

Here you go...

Purchasing

EKBE/EKPO/EKKO

The line items are extracted from the following tables in the R/3 source system:

Application R/3 Table BW DataSource

FI-GL: General Ledger BKPF/BSEG 0FI_GL_4

FI-AR:Accounts Receivable BSID/BSAD 0FI_AR_4

FI-AP: Accounts Payable BSIK/BSAK 0FI_AP_4

Orders :-Cost and Allocations

0CO_OM_OPA_1 - Internal Orders

COSP and COSS AUFK

Cost Centers :Costs and Allocations

0CO_OM_CCA_1 COSP and COSS

0CO_OM_CCA_9 COVP (COEP and COBK)

Note 65075 - CO reports R/3 and BW: displaying debits and credits

Note 355586. - CO-OM InfoSources: No display of settlements

Plant Maintenance

OPM_OM_OPA_1

OPM_OM_OPA_2 - Delta

Tables

1. PMSDO

2. AFIH

3. EQUZ

4. PLKO

5. EAPL

6. ILOA

extracts only maintenance order ACTUAL costs.

Quality notifications

QMEL

Quality notifications - causes

QMUR

Quality notifications - items

QMFE

Maintenance notifications

Maintenance notifications - causes

Maintenance notifications - items

Service notifications

Service notifications - causes

Service notifications - items

HR -

Time and Labor data

Datasource -0HR_PY_1

table- PCL2

Datasource- 0HR_PT_1

table -PA0001 PA0007 T550A T550A

Datasource- 0HR_PT_2

PA0001 PA0027 PA2001 PA2002,PCL2(B2)

No data- ASSOB_HR PA2003 PA2010

After adding P_BAS_ALL (Authorization for Personal data) to BW RFC user, we can finally extract Payroll data from R/3 into BW.

Travel Management-

0FI_TV_01

Tables - PTRV_HEAD PTRV_PERIO PTRV_SHDR PTRV_SREC

General trip data- PTRV_HEAD

Period data for trip- PTRV_PERIO

Trip statistics/Amounts- PTRV_SHDR

Trip statistics/Receipts - PTRV_SREC

0FI_TV_02

Tables- PTRV_HEAD FTPT_PLAN FTPT_ITEM FTPT_HOTEL FTPT_CAR FTPT_FLIGHT FTPT_FLIGHT_TSTK

General Plan data FTPT_PLAN

Travel service request Item FTPT_ITEM

Ticket Information FTPT_FLIGHT_TSTK

FI-AP

0FI_AP_6 LFC1

0FI_AP_6 REPLACES 0FI_AP_1

Delta capable

Cube - 0FIAR_C03

0FI_AR_4

Tables BSID (open items) and BSAD (cleared items) in the R/3 source system.

0FI_AR_4 REPLACES 0FI_AR_3

Delta capable

0FI_AP_4

Tables - BSIK (open items) BSAK(Cleared items)

0FI_AR_10

Table- KNB4

0FI_AR_10 REPLACES 0FI_AR_5

Infocube - 0PCA_C01

Profit Center Accounting - 0EC_PCA_1

Table- GLPCT

0EC_PCA_3

Cube 0FIGL_C10

Datasource 0FI_GL_10

Table - FAGLFLEXT

0FIGL_O02 Line Item for FIGL

Datasource - 0FI_GL_4

Tables - BKPF BSEG

Try searching in SDN you will find a lot,

Hope it helps,

Thanks

[Former Member · Accepted solution]

Dear Allen,

Very helpful info. I tried but can't find any in SDN.

There should have some complete info of each standard extractor, any idea where to get them?

Thanks!

[former_member345199 · Accepted solution]

Hi,

http://help.sap.com/search/sap_trex.jsp

select the option SAP Netweaver and specify the data source name.

Hope this helps.

Thanks,

JituK

[Former Member · Accepted solution]

Thanks Jituk, that really helpful.

[Former Member]

very good info

[Former Member]

Apart from the above blog, try reading this also:

http://help.sap.com/saphelp_nw2004s/helpdata/en/28/4c553c42360a40e10000000a114084/content.htm

Thanks...

Shambhu

[Former Member]

Hi,

There are these blogs where in you can find almost everything about extractors, have a look:

[SAP Network Blog: One stage stop to know all about BW Extractors-Part1|]

[SAP Network Blog: One stage stop to know all about BW Extractors-Part2|]

Hope this is of help....

Cheers,

Habeeb

[Former Member]

Thanks for the link.

However, my question is what is the purpose for each of the standard SAP extractor?

i.e. 2LIS_02_ITM, this extractor will extract all the PO Item info into BI, table involve will be EKKO etc.

What about other type of extractor? What is the purpose and what table involve?

Please advice, thanks.