01-31-2008 8:27 AM
Hi there,
I downloaded a file in application server. It shows a part of data (part of records) which an internal table contains. Once I download that file using CG3Y transaction, but the file contains same data as it appears in Appl server.
For eg: An internal table having 40 columns, but the downloaded file is just showing a data of 36 columns.
Is there any restriction on record size that is to be downloaded in Appl server.
can you please suggests how to solve this problem so that all the columns will display in Application server file.
Thanks in advance.
Naseer.
01-31-2008 8:45 AM
Dear Naseer,
Can you paste the code you have written...I don't think there is any restriction on number of columns.
Regards,
Mohaiyuddin
01-31-2008 1:32 PM
Dear Mohaiyuddin,
Thanks for replay.
FORM f_download_to_appl.
CHECK wa_temp-arbpl IS NOT INITIAL.
DATA: l_tab(1) TYPE c,
l_rec TYPE string,
l_heading(65535) TYPE c,
l_len TYPE i.
l_tab = cl_abap_char_utilities=>horizontal_tab.
CONCATENATE v_str wa_temp-arbpl '.xls' INTO v_path_file.
OPEN DATASET v_path_file
FOR OUTPUT
IN TEXT MODE ENCODING NON-UNICODE
IGNORING CONVERSION ERRORS.
IF sy-subrc = 0.
LOOP AT i_temp INTO wa_temp.
CLEAR: l_len,l_rec.
AT FIRST.
CONCATENATE 'ORDER'
'ORDER DESCRIPTION'
'OP NO'
'OP WRK CTR'
'CKEY'
'OPERATION SHORT TEXT'
'WORK'
'NO'
'DUR'
'ACTUAL'
'ESS DATE'
'REVISION'
'TYPE'
'MAT'
'NOTIFICATION'
'PGRP'
'MAIN WRK CTR'
'FUNCLOC'
'EQUIPMENT'
'P'
'S'
'WMS PID'
'ENTERED BY'
'CREATED ON'
'BASIC START DATE'
'BASIC FINISH DATE'
'SCHEDULE FINISH'
'SCHEDULE START'
'ACTUAL START DATE'
'CONFIRMED ORDER FINISH DATE'
'ROUTING NUMBER OF OPERATIONS'
'PM ORDER REFERENCE DATE'
'NUMBER OF SUPERIOR NETWORK'
'PROJECT DEFINITION'
'MAINTENANCE PLAN'
'MAINTENANCE ITEM'
'ACTIVITY TYPE'
'COMP CONFIRMATION NUMBER'
'NORMAL DURATION/UNIT'
'UNIT FOR WORK'
'LATEST SCHEDULED FINISH DATE'
'ACTUAL START DATE'
'ACTULA FINISH DATE'
INTO l_rec SEPARATED BY l_tab RESPECTING BLANKS.
l_len = STRLEN( l_rec ).
TRANSFER l_rec TO v_path_file LENGTH l_len.
CLEAR: l_len,l_rec.
ENDAT.
CONCATENATE wa_temp-aufnr
wa_temp-ktext
wa_temp-vornr
wa_temp-arbpl
wa_temp-steus
wa_temp-ltxa1
wa_temp-arbei
wa_temp-anzzl
wa_temp-dauno
wa_temp-ismnw
wa_temp-fsavd
wa_temp-revnr
wa_temp-auart
wa_temp-ilart
wa_temp-qmnum
wa_temp-ingpr
wa_temp-vaplz
wa_temp-tplnr
wa_temp-equnr
wa_temp-priok
wa_temp-anlzu
wa_temp-pspel
wa_temp-ernam
wa_temp-erdat
wa_temp-gstrp
wa_temp-gltrp
wa_temp-gltrs
wa_temp-gstrs
wa_temp-gstri
wa_temp-getri
wa_temp-aufpl
wa_temp-addat
wa_temp-aufnt
wa_temp-pronr
wa_temp-warpl
wa_temp-wapos
wa_temp-larnt
wa_temp-rueck
wa_temp-daune
wa_temp-arbeh
wa_temp-ssedd
wa_temp-isdd
wa_temp-iedd
INTO l_rec SEPARATED BY l_tab RESPECTING BLANKS.
l_len = STRLEN( l_rec ).
TRANSFER l_rec TO v_path_file LENGTH l_len.
ENDLOOP.
CLOSE DATASET v_path_file.
ELSE.
PERFORM f_write_output.
WRITE:/ text-008 COLOR COL_NEGATIVE INTENSIFIED OFF.
ENDIF.
ENDFORM. "f_download_to_appl
Regards,
Naseer.