topic Re: data to al11 in Application Development and Automation Discussions

data to al11

Former Member — Mon, 20 Oct 2008 08:49:31 GMT

hi gurus,

i am pulling data from the bseg with certain fields and i want that data to move it al11 to one of those directories

how can i do that pls suggest me in this regard and please proivde me step by step as am new to this programme

and your help is much appriciated.

regards,

jacob.

Re: data to al11

Former Member — Mon, 20 Oct 2008 08:52:41 GMT

Hi,

To move the data to one of the directories in AL11 you have to use Dataset operations.

Goto ABAPDOCU transaction type in the following keyword:

Open , Tansfer, Close, Read and Dataset. To get the exact syntax of how to write data in application server directories.

Thanks & Regards,

Navneeth K.

Re: data to al11

Former Member — Mon, 20 Oct 2008 08:55:14 GMT

Collect data in internal table than user open dataset commands.

for more help you may search like this:[Search results.|https://www.sdn.sap.com/irj/sdn/advancedsearch?query=uploaddatatoapplicationserver&cat=sdn_all]

Re: data to al11

Former Member — Mon, 20 Oct 2008 08:57:29 GMT

Hi Jacob,

Transaction AL11 shows the directories in Application server, if you want to move the data to application server then look into OPEN DATASET, CLOSE DATASET, READ DATASET, TRANSFER DATASET.

Regards

Kumar M

Re: data to al11

Former Member — Mon, 20 Oct 2008 09:01:30 GMT

Hello,

You will have to select the data from bseg table

loop at each record.

open dataset dsn

transfer to dsn

endloop.


REPORT  zbseg_tst                               .

TABLES bseg.

DATA  : BEGIN OF gt_bseg OCCURS 0.
        INCLUDE STRUCTURE bseg.
DATA  : END OF gt_bseg.

DATA dsn(100) TYPE c.


START-OF-SELECTION.
  SELECT * FROM bseg
  INTO TABLE gt_bseg.

END-OF-SELECTION.

  PERFORM download_file.


*&---------------------------------------------------------------------*
*&      Form download_file
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM download_file.

  DATA : lex_file_open TYPE REF TO cx_sy_file_open,
         lex_file_access TYPE REF TO cx_sy_file_access_error,
         lex_file_io TYPE REF TO cx_sy_file_io.

  DATA l_fsap(150) TYPE c.


  l_fsap = 'usr\zsap\'.


* Try to open the data set and catch the appropriate exception
  TRY.

      OPEN DATASET l_fsap FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

    CATCH cx_sy_file_open INTO lex_file_open.
      MESSAGE lex_file_open->errortext TYPE 'I'.
    CATCH cx_sy_file_access_error INTO lex_file_access.
      MESSAGE lex_file_access->filename TYPE 'I'.

  ENDTRY.

  IF sy-subrc = 0.
    LOOP AT gt_bseg.

      TRY.

          TRANSFER gt_bseg TO l_fsap.

        CATCH cx_sy_file_io INTO lex_file_io.
          MESSAGE lex_file_io->errortext TYPE 'I'.
        CATCH cx_sy_file_access_error INTO lex_file_access.
          MESSAGE lex_file_access->filename TYPE 'I'.

      ENDTRY.
    ENDLOOP.
  ENDIF.

  CLOSE DATASET l_fsap.

  CLEAR : l_fsap.


ENDFORM.                    " gui_download

regards,

Advait

Re: data to al11

Former Member — Mon, 20 Oct 2008 09:01:39 GMT

Sample code

OPEN DATASET p_file1 FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
  LOOP AT itab.
    TRANSFER itab TO p_file1.
  ENDLOOP.
CLOSE DATASET p_file1.

Re: data to al11

Former Member — Mon, 20 Oct 2008 09:06:52 GMT

Try the sample code

Make sure the Directory you specify in "FILE" exists in AL11.

TYPES : BEGIN OF TY_BSEG,
        BUKRS TYPE BSEG-BUKRS,
        END OF TY_BSEG.

DATA : IT_BSEG TYPE TABLE OF TY_BSEG,
       WA_BSEG TYPE TY_BSEG,
       LINE    TYPE STRING.

DATA : FILE TYPE STRING VALUE 'E:\usr\sap\put\file.dat'.

SELECT BUKRS
FROM BSEG
INTO TABLE IT_BSEG UP TO 10 ROWS.

OPEN DATASET FILE FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

LOOP AT IT_BSEG INTO WA_BSEG.

  TRANSFER WA_BSEG TO FILE.

ENDLOOP.

CLOSE DATASET FILE.

WRITE : 'Transfer complete'.

Regards

Edited by: Rajvansh Ravi on Oct 20, 2008 11:07 AM

Re: data to al11

Former Member — Mon, 20 Oct 2008 09:28:54 GMT

Select the entries from BSEG into the internal table T_BSEG

then use this

OPEN DATASET FILE FOR OUTPUT IN BINARY MODE.

LOOP AT T_BSEG

TRANSFER T_BSEG TO application path.

ENDLOOP.