cancel
Showing results for 
Search instead for 
Did you mean: 

BI IP ---> Planning function for File Upload - 69 Records read

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi.....make

File Upload: Skip header line = YES

Function will read the data based on filters. I think its fine.

Former Member
0 Kudos

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