Skip to Content

Extracting Data from SAP ECC

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 14, 2018 at 03:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2018 at 03:45 PM

    Hi Javier Barberena,

    Sorry for missing the link. Please check 1510986.

    Best regards,
    Maggie

    Add comment
    10|10000 characters needed characters exceeded