Extracting data from 3.0F

[Former Member]

The company that I'm at is upgrading R/3 from 3.0F to ECC 5.0, as well as implementing BW 3.5

They would like to bring in 3 - 5 years of history from the R/3 3.0F inot BW. The problem is, the current extractor's don't exist/work on that version. So obviously, I could use an ETL tool or write a program to extract the data.

However, I wonder if there's already some SAP BAPI's or conversion programs out there that could do it for me? Or, Is there a quick & easy place to look to determine what R/3 tables & fields are being utilized by the current data sources so that I could mimick them? I know about table ROOSOURCE, however, if the extractor type is F1 (which most of the major ones are), then it's extremely tough to impossible to figure out!!

Thanks for your help!!

Best regards,

Mark Ulrich

[Former Member · Accepted solution]

for a start:

1)

in case of logistics > lbwe > expand the application component > expand the extrator > maintain extractor structure > you get the list of tables and fields for that extractor.

2) help.sap.com > bw > BI content > select the application component > datasources..

[Former Member · Accepted solution]

Very good point about LO extractors. However, the one's I'm interested in are financial - outside of the LO area.

When I went to help.sap.com as you suggested, I found NO BW area. I checked through ALL the tabs. Did I miss it, is it hidden somewhere? Can you give a more detailed path to it? Thanks again!!

[Former Member · Accepted solution]

Hi Mark,

You might have seen NW04s documentation(Still under Ramp up)!

Any way, BI content for NW04s ->

http://help.sap.com/saphelp_nw04s/helpdata/en/6a/44b2420e71c511e10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/3d/5fb13cd0500255e10000000a114084/frameset.htm

I think you need specifically BW 3.5(NW04) Business content ->

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

http://help.sap.com/saphelp_nw04/helpdata/en/65/7beb3cad744026e10000000a11405a/frameset.htm

Hope this helps!

Regards

Naveen

PS: Assigning point to the helpful answers is the way of saying thanks in SDN

[Former Member]

Thanks everyone for your quick replies and Excelent recommendations - you're the best!!!

Mark Ulrich

[edwin_harpino]

hi Mark,

i may not understand well the whole situation you encountered. some thoughts :

- do you mean the extractor you are looking for not available after you install 'hot packages'/add-on/plug-in in your r/3 3.0f

(release strategy oss note 99907)

- possible to extract data after r/3 upgrade ?

- to determine r/3 tables from datasource, have you try help.sap.com, search documentation with option 'netweaver' and type datasource ? read Roberto's weblog ? take a look this excellent one :

/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

i think it will hard to mimick, build your own generic extractor ?

hope this helps perhaps a little bit.