ABAP : Read File with OPEN DATASET
Tuesday, November 22, 2011 at 1:20 AM | 0 comments
In SAP ABAP you can read file with open dataset,
The command used to read a file on the application server is as follows.

OPEN DATASET ... FOR INPUT

Please see example code below.

REPORT YSANTO_12 .

data: lv_fname(100),
       &nbsp   lv_msg like sy-msgv1.

data: begin of gi_data occurs 0,
      &nbsp  &nbsp  &nbsp   txt(255),
       &nbsp   end of gi_data.


lv_fname = '/home/data/data.txt'.

open dataset lv_fname for input message lv_msg in text mode encoding default.

if sy-subrc = 0.
    &nbsp do.
    &nbsp   read dataset lv_fname into gi_data-txt.
    &nbsp   if sy-subrc <> 0.
    &nbsp       &nbsp   exit.
    &nbsp   endif.
    &nbsp   append gi_data.
    &nbsp   clear gi_data.
    &nbsp enddo.
else.
    &nbsp   write 'File does not exist!'.
endif.

close dataset lv_fname.
Posted by Shanto Labels:
FTP from ABAP
Sunday, November 20, 2011 at 11:08 PM | 0 comments
Here is an example of how to FTP a file from the Application server to a remote server using standard SAP functions.


REPORT YSANTO_12 .

data: begin of gi_data occurs 0,
                line(132) type c,
           end of gi_data.

data: lv_password(20) type c,
           lv_key type i value 26101957,
           lv_pwd_len type I,
           lv_handle type I.

START-OF-SELECTION.

lv_password = 'password'.

describe field lv_password length lv_pwd_len in character mode.


call 'AB_RFC_X_SCRAMBLE_STRING'
           id 'SOURCE' field lv_password id 'KEY' field lv_key
           id 'SCR' field 'X' id 'DESTINATION' field lv_password
           id 'DSTLEN' field lv_pwd_len.

call function 'FTP_CONNECT'
         exporting
           user = 'userid'
           password = lv_password
           host = 'host'
           rfc_destination = 'SAPFTP'
         importing
           handle = lv_handle
         exceptions
           not_connected = 1
           others = 2.

check sy-subrc = 0.

call function 'FTP_COMMAND'
         exporting
           handle = lv_handle
           command = 'dir'    " for get file -> exe commnad 'asci'
         tables                          " then exe command 'get sourcefile targetfile'.
           data = gi_data
         exceptions
           tcpip_error = 1
           command_error = 2
           data_error = 3
           others = 4.


call function 'FTP_DISCONNECT'
         exporting
           handle = lv_handle
         exceptions
           others = 1.
Posted by Shanto Labels: ,
SAP Data Archiving
Friday, November 4, 2011 at 12:51 AM | 0 comments
What is Data Archiving?
Data Archiving is a decongestion process used to delete large volume of data that is no longer needed from a database and storing same outside the database in a format that allows for data retrieval and analysis when need be. The emphasis here are on “deleting” and “storing”. It is common knowledge that if a database is left to grow unmaintained, there is a possibility of having performance bottlenecks and high database maintenance cost. Hence, one of the ways to maintain the database is to delete records that can be termed obsolete. The word “obsolete” is relative. For the archiving process to be complete, data has to be stored using a defined method.

How is data archived?
The data archiving run follows a sequence of steps. A brief overview is provided below.
1. Creation of the archive file: During an archive run, the write program first creates archive files which initiates the reading process (from the database) and the consequent writing process (to the archive file)

2. Storage of the archive file: After successful run of step 1, the created archive files are stored. A number of methods can be leveraged to store an archive file. Archived files can be stored hierarchically, optically or manually. It is important to state that SAP does not recommend the manual storage of archive file. This is as a result of some standardization issues

3. Deletion of data: This step terminates the archive run. Before data is deleted from the database, the program first read the content of the archive file. It is after this task, that the program deletes the corresponding entry from the database.

Benefits of Data Archiving
1. Reduced Backup and Restore time
2. Reduced access time for tables
3. Reduced database administration cost
4. Reduced downtime for system upgrade
5. Reusability of data


Ref : http://it.toolbox.com/blogs/sap-library/introduction-to-sap-data-archiving-27976
Posted by Shanto Labels: