transfering data from bsis table to file on application server

[bhaskar_pasupuleti]

Hi Gurus,

In my program iam selecting data from bsis table and transferring to file on the application server.

Code:

Tables: BSIS.

data: file type rlgrap-filename.

Select * from BSIS into BSIS.

Open dataset output in text mode encoding default.

Transfer bsis to file.

closesdataset.

1, Issue when transferring iam getting dump due to type conflict.

2, Here I cant create a structure like bsis and define type c

varialbles as its an upgrade project.

3, I tried field-symbols using type casting but data in the

application server is showing junk data with ##### in currncy

fields.

4, In earlier program there is no internal table defined for bsis,

Directly passing to work area and transferring to file on

application server.

Please let me know any feasble solution to approach.

If need i can post the complete code.

Regards

Bhaskar

[Former Member]

do you need each and every field from BSIS? how many records are you looking at? can't you go to SE16N and export your results?

also, have you tried declaring a structure with 1 field that's char1000 or something, the moving your BSIS line to that field. then, transfer that to your app server?

[bhaskar_pasupuleti]

Hi Robert,

Here is my code....in ECC. While executing program is going to dump saying character type error.

tables: bsis.

data: begin of i_tab occurs 100.

include structure bsis.

end of i_tab.

parameters: outfile(1000) lower case.

open dataset outfile for output in text mode encoding default

ignoring conversion errors..

select * from bsis into table i_tab

where bukrs = bukrs.

loop at i_tab.

transfer i_tab to outfile.

endloop.

close dataset.

Please let me know if any soluton.

regards

Bhaskar

[Former Member]

Hi,

Define a structure with one field with say 1000 characters and declare an itab of that structure.

data : begin of file_data occurs 0,

data(1000) type c,

data end of file_data

Move the data from BSIS table to the file_data one by one and append to file_data.

Use file_data in the transfer statement.

regards,

Advait