topic Re: EXPORT TABLE TO ARCHIVE in Application Development and Automation Discussions

EXPORT TABLE TO ARCHIVE

mariano_gallicchio2 — Thu, 31 Jul 2008 14:59:17 GMT

Hello experts, there is a way to export a table(i mean name of fields, type of field etc, NOT the data ) to an archive (XML,EXCEL,HTML, or other )?

THANKS!!

Re: EXPORT TABLE TO ARCHIVE

Former Member — Thu, 31 Jul 2008 17:37:39 GMT

You can try something lile this:


REPORT  Z_TEST.
data: idfies type table of dfies with header line,
      s_file TYPE string.

parameters: p_table type ddobjname.
parameters: filename(80) type c default 'D:\Documents and Settings\Desktop\download.xls'.

call function 'DDIF_FIELDINFO_GET'
exporting
tabname = p_table
tables
dfies_tab = idfies
exceptions
not_found = 1
internal_error = 2
others = 3.

s_file = filename.

CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      FILENAME                = s_file
      FILETYPE                = 'DAT'
    TABLES
      DATA_TAB                = idfies
    EXCEPTIONS
      FILE_WRITE_ERROR        = 1
      NO_BATCH                = 2
      GUI_REFUSE_FILETRANSFER = 3
      INVALID_TYPE            = 4
      NO_AUTHORITY            = 5
      UNKNOWN_ERROR           = 6
      HEADER_NOT_ALLOWED      = 7
      SEPARATOR_NOT_ALLOWED   = 8
      FILESIZE_NOT_ALLOWED    = 9
      HEADER_TOO_LONG         = 10
      DP_ERROR_CREATE         = 11
      DP_ERROR_SEND           = 12
      DP_ERROR_WRITE          = 13
      UNKNOWN_DP_ERROR        = 14
      ACCESS_DENIED           = 15
      DP_OUT_OF_MEMORY        = 16
      DISK_FULL               = 17
      DP_TIMEOUT              = 18
      FILE_NOT_FOUND          = 19
      DATAPROVIDER_EXCEPTION  = 20
      CONTROL_FLUSH_ERROR     = 21
      OTHERS                  = 22.

Re: EXPORT TABLE TO ARCHIVE

mariano_gallicchio2 — Thu, 31 Jul 2008 18:21:28 GMT

Thanks a lot for the answer. Problem Solved!!!

Re: EXPORT TABLE TO ARCHIVE

Former Member — Thu, 31 Jul 2008 19:12:15 GMT

Hi,

I answered your question and told you the transaction SARA but i am not able to see it .. how? also my points got deducted..? any idea?

Re: EXPORT TABLE TO ARCHIVE

mariano_gallicchio2 — Thu, 31 Jul 2008 19:20:41 GMT

I dont know...

But i put the 6 point again in the answer...