Extracting Data from SAP ECC

[Former Member]

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.

[maggie_yi]

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

[Former Member]

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 ?