topic Re: file with Vertical Format in Application Development and Automation Discussions

file with Vertical Format

Former Member — Wed, 13 Feb 2008 15:59:48 GMT

Hey Folks,

I have a requiremnet where i have to produce 2 flat files one for current year and another for last year . I have to download it to the presentation server .Could somebody send me the sample code to download it to presentation server.

And i need format like this

Regarsd

Rock

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 16:04:34 GMT

Use the method

>GUI_DOWNLOAD in the Class

>CL_GUI_FRONTEND_SERVICES.

> CALL FUNCTION 'GUI_DOWNLOAD'

> EXPORTING

> filename = v_file " file Name

> filetype = 'ASC'

> TABLES

> data_tab = i_error_file " Table to be Downloaded

> 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.

Hope this Helps.

Amandeep

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 16:51:06 GMT

Hey,

I need it in the vertical format how wud i do it.

Regards

Rock

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 17:01:28 GMT

Please give an example of Vertical format. I really didn't get.

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 17:05:38 GMT

Hey Aman,

Actually i m having the internal table like

having fields

vkorg , vbeln, matnr , prodh etc.,

and I need to display them as

aa01 company

90000012 billing doc

2209 material number

0031 product id

Regards

Rock

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 18:29:12 GMT

sample Code.


TYPES: BEGIN OF ty,
        vkorg TYPE vkorg ,
        vbeln TYPE vbeln,
        matnr TYPE matnr,
        prodh TYPE prodh1,
        END OF ty.

DATA: ls TYPE string,
      lt TYPE string_table,
      itab TYPE TABLE OF ty WITH HEADER LINE.
FIELD-SYMBOLS: <dat> TYPE ANY.


DO 3 TIMES.
ADD 12 TO itab-vbeln.
ADD 142 TO itab-MATNR.
  itab-vkorg = 'DUMM'.
  itab-vbeln = itab-vbeln.
  itab-matnr  = itab-matnr.
  itab-prodh = 'DUMMY'.
  APPEND  itab.
ENDDO.


LOOP AT itab.
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE itab TO <dat>.
    IF sy-subrc NE 0.
      EXIT.
    ELSE.
      CASE sy-index.
        WHEN 1.
          CONCATENATE <dat> 'company' INTO ls SEPARATED BY cl_abap_char_utilities=>horizontal_tab.
        WHEN 2.
          CONCATENATE <dat> 'billing doc' INTO ls SEPARATED BY cl_abap_char_utilities=>horizontal_tab.
        WHEN 3.
          CONCATENATE <dat> 'material number' INTO ls SEPARATED BY cl_abap_char_utilities=>horizontal_tab.
        WHEN 4.
          CONCATENATE <dat> 'product id' INTO ls SEPARATED BY cl_abap_char_utilities=>horizontal_tab.
      ENDCASE.
    ENDIF.
    SHIFT ls LEFT DELETING LEADING SPACE.
    APPEND ls TO lt.
  ENDDO.
ENDLOOP.

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 19:11:36 GMT

Hey Aman,

i ahve a requirement like this

01 9100 kathy

01 9200 gret

01 9300 mike

02 100 Foods

02 200 taco

02 300 beef

03 501 customer group1

03 502 customer group2

03 503 customer group3

04 1301 material1

04 1302 material2

04 1303 material3

basically its the same data we get in the internal table as

01 9100 foods customer group1 material1

How wud i achieve this ..

Regards

Rock

Re: file with Vertical Format

Former Member — Wed, 13 Feb 2008 22:36:30 GMT

Hey Ama,

If i want to add header say

H1 H2 H3

1102 redf 22

How wud i do it.

Regards

Rock