on 09-21-2007 4:32 PM
Hai All,
While uploading File upload , In my text file i am having 68 records, but it is showing 69 records, after successfully loading the data in to cube.
it is showing message reading as 69 record read, file is having only 68 records(is it taking headerline also)
File Upload: Encoding = DEFAULT
File Upload: Overwrite data = No
File Upload: Skip header line = No
File Upload: Convert fields = No
File Upload: Convert amounts = No
69 records read, 0 generated, 68 changed, 0 deleted
Changed Parameter as Overwrite Data as Delta mode
After sometime, removed 67 records and I Changed only one record (Changed Fiscal year / Period) and loaded only one record, while uploading the file its shows message as given below
File Upload: Encoding = DEFAULT
File Upload: Overwrite data = Delta
File Upload: Skip header line = No
File Upload: Convert fields = No
File Upload: Convert amounts = No
69 records read, 1 generated, 0 changed, 0 deleted
Why it is showing 69 Records Read , In my text file having only one record , but it is showing 69 records read.
Any one can help me out.
Thanks,
Bhima
Hi.....make
File Upload: Skip header line = YES
Function will read the data based on filters. I think its fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1) do you have records with the same characteristics? If so these are aggregated
2) did you implement the bug fix? If I'm not mistaken there was a similar issue mentioned on the blog of Marc Bernard
D
...
. After importing the transport request, please implement the following corrections:
Class Interface ZCL_RSPLF_FILE_UPLOAD
Method IF_RSPLFA_SRVTYPE_IMP_EXEC~EXECUTE
DATA:
l_data TYPE string,
l_chavl_ext TYPE rschavlext, "insert
l_chavl_int TYPE rschavl, "insert
...
ASSERT sy-subrc = 0.
Convert field value only if necessary and use correct type
IF NOT <f> IS INITIAL. "insert
l_chavl_ext = <f>. "insert
CALL FUNCTION 'RRSV_EX_IN_CONVERT'
EXPORTING
i_chavl_ext = l_chavl_ext "change
i_convx = l_s_iobj_pro-convexit
i_inttp = l_s_iobj_pro-inttp
i_intlen = l_s_iobj_pro-intlen
i_outputlen = l_s_iobj_pro-outputlen
i_iobjnm = l_iobjnm
IMPORTING
e_chavl_int = l_chavl_int "change
EXCEPTIONS
no_input_given = 1
input_not_numerical = 2
conversion_not_supported = 3
date_not_correct = 4
time_not_correct = 5
invalid_format = 6
OTHERS = 7.
IF sy-subrc = 0. "change
<f> = l_chavl_int. "insert
ELSE. "insert
add_msg_error3 'Field conversion error. Field/Line:'(048) l_iobjnm l_len.
l_subrc = 4.
ENDIF.
ENDIF. "insert
...
Merge loaded data
TRY.
l_len = 0.
LOOP AT <l_t_file> INTO <l_s_file>. "delete
LOOP AT <l_t_file> ASSIGNING <l_s_file>. "insert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.