Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

REG abap query

Former Member

‎2007 Apr 21 8:26 AM

0 Likes
434

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2007 Apr 21 9:07 AM

0 Likes
416

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.

Read only

Former Member
In response to Former Member

‎2007 Apr 21 10:31 AM

0 Likes
416

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

Read only

Former Member
In response to Former Member

‎2007 Apr 21 10:34 AM

0 Likes
416

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