Question Re: Extracting Data from SAP ECC in Technology Q&A

Extracting Data from SAP ECC

Former Member — Tue, 13 Nov 2018 17:12:43 GMT

I am looking for ideas on how to extract data from SAP ECC. I am an end-user and not from the Technology team. So, I have limit ways to extract data from SAP ECC. I understand there are extractors to extract data from SAP ECC. But as an end-user I do not have rights or the ability to use these extractors.

I developed a process to extract data from SAP ECC either using Transactions SE16 or SE16N. The steps I have developed are; (1) Extract data using SE16 or SE16N and save the data as "Text with Tabs" file (report) in a network folder. (2) Covert the "Text with Tabs" file (report) as pipe delimited text file. (3) Load the pipe delimited file to an SQL database. These approach works well, but I am looking for ways to improve my solution.

I also know that there is a SAP ECC funtion "CBRC_LIB2_CONVERT_ITAB_TO_CSV" that can be used to create a delimited file. Again, since I am an end-user I do not have the rights to develop a ABAP program to create pipe delimited file.

Looking forward to hear your suggestions .... Thank you in advance.

Re: Extracting Data from SAP ECC

maggie_yi — Wed, 14 Nov 2018 15:23:46 GMT

Hi Sir,

Frankly speaking, I've never used this function before. But please see if the following note could give you some hits:

1510986 - IC 7.5 - Data extraction from SAP ERP or SAP BW

Best regards,
Maggie

Re: Extracting Data from SAP ECC

Former Member — Wed, 14 Nov 2018 15:31:48 GMT

maggie.yi

Thank you. Could you please elaborate more on your reply ? Is there a weblink to your reply ? Or, are you suggesting to do a Google search on your reply ?

Re: Extracting Data from SAP ECC

maggie_yi — Wed, 14 Nov 2018 15:45:44 GMT

Hi Javier Barberena,

Sorry for missing the link. Please check 1510986.

Best regards,
Maggie

Re: Extracting Data from SAP ECC

Former Member — Wed, 14 Nov 2018 16:10:02 GMT

maggie.yi

Again,thank you for you reply.

The link you provided me takes me to the "SAP One Support Launchpad". Do I need a S-user ID to look at the information from the link you provided me? I am currently using a P-user ID !

sap-supportlaunchpad.png