topic Re: upload into table in Application Development and Automation Discussions

upload into table

Former Member — Wed, 13 Feb 2008 14:34:25 GMT

Hi experts,

I have requirement for uploading data into a Z Table .

and my data is in Application server with .csv file.

I Want to write aprogram should pick the file , read the data and load into the table.

please send any referal program.

Thanks & Regards,

Aruna Rathod.

Re: upload into table

Former Member — Wed, 13 Feb 2008 14:39:53 GMT

Hi aruna,

No need to write a program. SAP provided many tools to upload data. One such is SCAT.

All you need to do is goto transaction SCAT & record online for one entry. Then prepare download the txt file for the format in which the data to be given from SCAT. Prepare the file in the format and run it by giving the path of it.

You have many tutorials available online for eloborate information on step by step guide. just search in Google.

Please reward points if useful

rgds,

harikrishna.

Re: upload into table

Former Member — Wed, 13 Feb 2008 17:44:42 GMT

PARAMETERS : p_file TYPE rlgrap-filename.

OPEN DATASET p_apspth IN TEXT MODE FOR INPUT ENCODING DEFAULT.

IF sy-subrc NE 0.

message...............like unable to open file........

EXIT.

ENDIF.

DO.

READ DATASET p_apspth INTO lv_string.

IF sy-subrc EQ 0.

split lv_string at ','

into gwa_data-field1 gwa_data-field2......etc.

APPEND gwa_data TO gt_data.

CLEAR gwa_data.

ELSE.

EXIT.

ENDIF.

ENDDO.

CLOSE DATASET p_apspth.

now the internal table gt_data contains the appl server data.