Downloading Master Data

Former Member — Fri, 14 Mar 2008 12:25:04 GMT

Dear All,

I am to download master data for MM. We might need 40 to 200 fields to download.

The area of concern is we do not know what is the volume of data ( might be 5,00,000+ ).

Please suggest a viable alternative to download the data since gui_download to excel sheet might not be a good option.

Re: Downloading Master Data

Former Member — Fri, 14 Mar 2008 12:32:45 GMT

Try using the FM TABLE_EXPORT_TO_MSACCESS .

Hope this helps.

Thanks,

Balaji

Re: Downloading Master Data

Former Member — Fri, 14 Mar 2008 12:40:14 GMT

Excel can be limited to 64k lines depending on version.

If you need it externally, you option could be to export (WS_DOWNLOAD) as a tab delimited file.

WS_DOWNLOAD is only good when going to your local PC.

IF you want to go to an Application Server, you'll need to use something along these lines:



  CONSTANTS: c_tab TYPE x VALUE '09'.

  OPEN DATASET archfilname FOR OUTPUT IN TEXT MODE MESSAGE t_mesg.
  IF sy-subrc NE 0.
    MOVE 'X' TO t_error.
    MESSAGE e100(z0) WITH 'Error opening achrive file:' t_mesg.
    EXIT.
  ENDIF.

  LOOP AT it_out INTO out_rec.
    CONCATENATE
        out_rec-recnum
        out_rec-leadid
        out_rec-ltype
        out_rec-ltype_txt
        out_rec-status
        out_rec-status_txt
        out_rec-statdt
        out_rec-branch
        out_rec-brtextextd
        out_rec-fname
        out_rec-mname
        out_rec-lname
        out_rec-street
        out_rec-city
        out_rec-state
        out_rec-zip
        out_rec-telf1
        out_rec-telf2
        out_rec-telf3
        out_rec-telf3_ext
        out_rec-email
        out_rec-prefcont
        out_rec-prefcont_txt
        out_rec-ctype
        out_rec-ctype_txt
        out_rec-heard
        out_rec-heard_txt
        out_rec-heard_other_text
        out_rec-email_promo
        out_rec-email_promo_txt
        out_rec-creside
        out_rec-creside_txt
        out_rec-zown
        out_rec-zown_txt
        out_rec-bld_tm
        out_rec-bld_tm_txt
        out_rec-ownland
        out_rec-ownland_txt
        out_rec-spnum
        out_rec-cmt1
        out_rec-statseq
        out_rec-actseq
        out_rec-acttyp
        out_rec-acttyp_txt
        out_rec-actrst
        out_rec-actrst_txt
        out_rec-acmt
        out_rec-folseq
        out_rec-foltyp
        out_rec-foltyp_txt
        out_rec-fcmt
      INTO arch_rec
      SEPARATED BY c_tab.
    TRANSFER arch_rec TO archfilname.
  ENDLOOP.
  CLOSE DATASET archfilname.

Re: Downloading Master Data

Former Member — Wed, 24 Sep 2008 06:36:16 GMT

Thanks!

topic Downloading Master Data in Application Development and Automation Discussions

Downloading Master Data

Re: Downloading Master Data

Re: Downloading Master Data

Re: Downloading Master Data