extract data from SAP

Former Member — Wed, 25 Jul 2007 07:00:58 GMT

Hi All,

Can anyone send me a sample code for extracting the data from SAP to a file on the presentation server in ASCII flat file with Pipe Delimeter("|"). And also I require the file to be moved to three different regions to the designated location on to the file server.

Pls suggest me how to go abt this?

Regards,

Ram

Re: extract data from SAP

Former Member — Thu, 26 Jul 2007 04:06:02 GMT

Hi Ramu,

Can you specify how to extract data from SAP. There are a lot of tables and from which table and which data you want ?

For sending the file to the presentation server at designated location you can use the following logic.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = Your desired location [ C:\Test.txt]

FILETYPE = 'ASC'
APPEND = ' '
WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
WRITE_LF_AFTER_LAST_LINE = ABAP_TRUE
SHOW_TRANSFER_STATUS = ABAP_TRUE
IMPORTING
FILELENGTH =

tables

data_tab =

FIELDNAMES =
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

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Here pass the data through the internal table and then you can uncomment the part of the code which ever is needed.

Thanks,

Samantak.

<b>Rewards points for useful answers.</b>

Re: extract data from SAP

former_member194669 — Thu, 26 Jul 2007 04:16:31 GMT

Hi,

use fm

CALL FUNCTION 'GUI_DOWNLOAD' and please check exporting paramete

WRITE_FIELD_SEPARATOR = '|' and pass pipe symbol hee

aRs

Re: extract data from SAP

Former Member — Thu, 26 Jul 2007 04:28:35 GMT

good

you can use the open dataset to fulfill your requiremnet.

thanks

mrutyun^

topic extract data from SAP in Application Development and Automation Discussions

extract data from SAP

Re: extract data from SAP

Re: extract data from SAP

Re: extract data from SAP