FI Extractors

[Former Member]

Hi Gurus,

I'm in the beginning of a BW Project. The module I've been requested is FI. The end user gave me the reports they need. What I would like to know is which infosource and infocube I need to activate.

All the items in the reports are grouped by different accounts and some are classified by cost centers.

Basically the reports are:

Operational Expenses, Expenses by cost center, Profit and loss, Sales Expenses, etc.

If they are all grouped by accounts, do you think the extractor 0CO_OM_CCA_9 will be OK?

Or what steps I need to follow to know which extractor I should activate?

Best Regards,

Rodrigo.

[Former Member]

I have open another thread with better detail.

[Former Member]

Hi,

The datasource you said will cover your requirement and you can use 0cca_c11 cube.Please check the link below.It is content cube and you need to activate it from business content using rsa1>business content section then you can use.

http://help.sap.com/saphelp_nw70/helpdata/en/3f/9bcf38508bad6de10000000a11402f/frameset.htm

Regards.

[Former Member]

Thanks a lot Rasim, but things changed. I need to extract data from tables BKPF and BSEG. So I thought in extractor 0FI_GL_4. This means I need an ODS so I can use delta extraction.

But I need plan data that it's saved in table COSP, what extractor I should activate for this?

Remember I need to create reports that compares actual/plan data with accounts.

Best Regards,

Rodrigo.

[Former Member]

Hi,

The ODS you can use is 0FIGL_O02.Please check the link.

http://help.sap.com/saphelp_nw70/helpdata/en/6e/ff703b3de59e4fe10000000a114084/frameset.htm

For the data saved in COSP you can use 0CO_OM_CCA_1 extractor which use 0cca_c11.Please check these link too.

http://help.sap.com/saphelp_nw70/helpdata/en/ae/8876724e671341a91ff3ba711bacd0/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/ae/8876724e671341a91ff3ba711bacd0/frameset.htm

Regards.

[Former Member]

Thanks a lot Rasim!

I'm sorry but things have changed AGAIN.

The thing is that all the data I need is in tables GLPCA for actual data y GLPCP for plan data. Do you know any standar extractor to acomplish this? or what would you reccomend me?

Best Regards,

Rodrigo.

Points will be assigned.

[Former Member]

Hi,

There is no SAP delivered data source for that GLPCA.

Check the link below.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b06...

Regards.