Extractions

[Former Member]

Hi Experts!

I'm new in BW,

I came to a situation where I have to extract datas from six different tables in R/3. Can some body help me how to do that, the easier way please.

Thanks in Advance

Alex.

[Former Member]

Hi,

check the following

http://help.sap.com/bp_biv235/BI_EN/html/bw.htm

business content

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how%20to%2...

https://websmp203.sap-ag.de/co

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm

(navigate with expand left nodes)

also co-pa

http://help.sap.com/saphelp_nw04/helpdata/en/53/c1143c26b8bc00e10000000a114084/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fb07ab90-0201-0010-c489-d52...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/1910ab90-0201-0010-eea3-c4a...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ff61152b-0301-0010-849f-839...

LO Extraction

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

Check these links:

/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Also Refer this link:

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

FI-CO 'Data Extraction -Line Item Level-FI-CO

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a7f2f294-0501-0010-11bb-80e...

FI-GL

http://help.sap.com/saphelp_nw04/helpdata/en/c9/fe943b2bcbd11ee10000000a114084/frameset.htm

http://help.sap.com/saphelp_470/helpdata/en/e1/8e51341a06084de10000009b38f83b/frameset.htm

http://www.sapgenie.com/sapfunc/fi.htm

FI-SL

http://help.sap.com/saphelp_nw2004s/helpdata/en/28/5ccfbb45b01140a3b59298c267604f/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/41/65be27836d300ae10000000a114b54/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ee/cd143c5db89b00e10000000a114084/frameset.htm

Please reward for the same.

[Former Member]

Hi Alex,

If you know ABAP, it would be easier for you to go for Functional Module Extraction starting from RSO2, as explained earlier.

Regards

Sajeed

[Former Member]

Hello Sajeed,

I don't know ABAP, Can you please give me step by step how to do it?

Thanks

Alex.

[Former Member]

Alex,

First you should find out if there's a business contect etractor that is close to giving you that data.

If you find one, you can enhance it to add other fields and use an exit to populate them from other tables.

If no BC datasource is close, then first you should know the relationship between the tables. you may be able to create a view, if they are simple join conditions. But i think you may have to create a functional module (ABAP) to provide data from so many tables.

Hope it helps,

Farhan

[Former Member]

Hi Alex!

Farhan is correct. You need to start searching the BUSINESS CONTENT extractors first. In order to do that you need to:

1. TCODE = RSA5

2. Search your extractor (You can use descriptions to search -Ex. Material)

3. Select and review the extractor if it gives you all the Fields that you need

4. Hide, Unhide, Pick Selection Criteria Fields

5. Transfer it

If you cant find your fields or your extractor in the BUSINESS CONTENT and given that you are confident with your 6 tables what you can do is make a GENERIC EXTRACTOR:

1. TCODE = RSO2

2. Build your extractor (it can be a MASTERDATA, TEXT or TRANSACTION)

3. Select your Application Component

4. Fill in the table values

5. Save

6. Hide, Unhide, Select Fields

7. Configure DELTA (if applicable)

8. Save

--- After Activating (BUSINESS CONTENT) or Creating (GENERIC EXTRACTOR) run TCODE = RSA3 to test it

R,

Adwin

[Former Member]

Hi Farhan,

The Tables are BKPF,BSEG,BSAD,BSID,BSAK AND BSIK all these tables are in FI they are related I have to take several fields from each table, so how do I do it?

I hope this will help you guys to answer me.

Thanks again.

Alex

[Former Member]

Hi,

Take a look on help of the business content data source 0FI_GL_4.

http://help.sap.com/saphelp_nw04/helpdata/en/8b/02f93abb013b0de10000000a114084/frameset.htm

And what are the fields you need to get from BSAD,BSAK,BSIK<BSID.

MAy be to get these fields you have to enhance the DS 0FI_GL_4.

With rgds,

Anil Kumar sharma .P