Skip to Content
Author's profile photo Former Member

Extract data from SAP table / query

I made data extractor for SAP table and query.

icoxfog417/SAPExtractorDotNET · GitHub

You also use it by command line.

SAPExtractorDotNET/saploader at master · icoxfog417/SAPExtractorDotNET · GitHub

I confirmed it in SAP 6.0 (SAP_AP 700 SP29).

If you find some bug in this tool at your SAP, please notify me.

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Hynek Petrak
      Hynek Petrak

      Nice, but you're not allowed to distribute NCO binaries. You shall remove them from github.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Sorry, I missed the licence term of connector.

      I deleted dlls from repository and commit logs.

      Author's profile photo Hynek Petrak
      Hynek Petrak

      Hi Takahiro,

      I've been reading some parts of your work. I believe the way, how you parse the RSAQ_REMOTE_QUERY_CALL result - the LDATA table - is not correct. You shall not split based on delimiters ',', ';' and/or ':', but rather to use the field length provided.

      I've written a blog with the way I think is correct ... Download SQ01 or SQVI query results with .NET Connector

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Hynek.

      Thank you for reporting bugs and useful blog post(I also check your Github issue).

      I'll fix it as soon as possible.

      Author's profile photo Florian Wiedemann
      Florian Wiedemann

      Hi Takahiro,

       

      is it possible to influence the returned columns and their order of the query result somehow with your data extractor? I experimented with report variants and different layouts of the query ALV grid viewer but I always get all columns in their default order.

      I struggled with this issue already in my ABAP program when calling RSAQ_QUERY_CALL directly. ref_to_ldata contains always all columns nevertheless I defined different variants/layouts of the output columns.

      Kind regards

      Florian