topic Re: REG abap query in Application Development and Automation Discussions

REG abap query

Former Member — Sat, 21 Apr 2007 07:26:32 GMT

Hi Friends,

1.I want to extract data from sap to text file..

2.The possible three ways are using report program,abap query and report writer.....which extract method(tool) is best.....

3.What is report writer?(please provide clear idea.....and actual use)

4.If abap query is best ....how to do..... Is this Possible to take out...please mention the option

please, tell me......

Regards

Mani R

Re: REG abap query

Former Member — Sat, 21 Apr 2007 08:07:31 GMT

Hi..

Report Program is better..using function module GUI_DOWNLOAD.

EX:

SELECT * FROM SPFLI into table t_spfli.

<b>CALL FUNCTION 'GUI_DOWNLOAD'</b>

EXPORTING

BIN_FILESIZE =

FILENAME = 'C:\RAM\TST.TXT'

FILETYPE = 'ASC'

FIELD_SEPERATOR = 'X'

TABLES

TABLE = T_SPFLI.

<b>Report writer:</b>

Why List & Label as Report Writer?

With the reporting tool List & Label you enhance your applications with reports, lists, diagrams, forms, labels, mail merges and web reporting with only a few lines of code. It takes only one step to add classic printing options, intelligent preview and comprehensive export functions. Moreover, you add real value to your application by integrating the List & Label Designer: provide your end users with the opportunity to create custom print projects.

Re: REG abap query

Former Member — Sat, 21 Apr 2007 09:31:46 GMT

Hi Rammohan Nagam

Thanks for ur reply...I know this procedure already....i want reasons and benefits for all tools...

Abap query has two options excel and word...it hasn't option for text file(but there is file store)...what we to do in this situation....

we extract data from sap to txt file or not....is have seperator.....please telll me..

regards

Mani R

Re: REG abap query

Former Member — Sat, 21 Apr 2007 09:34:06 GMT

Hi Rammohan Nagam

Thanks for ur reply...I know this procedure already....i want reasons and benefits for all tools...

Abap query has two options excel and word...it hasn't option for text file(but there is file store)...what we to do in this situation....

we extract data from sap to txt file or not (using abap query)....is have seperator.....(adv & disadvantages)please telll me..

regards

Mani R