Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CSV file with cell format as TEXT

Former Member
0 Likes
1,149

i would like to create a CSV file with text in all cell for a BDC report.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
796

hi,

There are different ways in creating a CSV file. The RIGHT way is to use the function SAP_CONVERT_TO_CSV_FORMAT. You can just go thru the function, everything is clear. To complete, for every convert fuction there is an equal and opposite convert function, so is TEXT_CONVERT_CSV_TO_SAP.

Otherwise, you can create an internal table with one char field of size as required and try to concatenate all values with the required delimiters and so put into this internal table and download this table.

But the RIGHT way is to use the function. Hope this could help you

reward points if helpful.

i would like to create a CSV file with text in all cell for a BDC report.

1 REPLY 1
Read only

Former Member
0 Likes
797

hi,

There are different ways in creating a CSV file. The RIGHT way is to use the function SAP_CONVERT_TO_CSV_FORMAT. You can just go thru the function, everything is clear. To complete, for every convert fuction there is an equal and opposite convert function, so is TEXT_CONVERT_CSV_TO_SAP.

Otherwise, you can create an internal table with one char field of size as required and try to concatenate all values with the required delimiters and so put into this internal table and download this table.

But the RIGHT way is to use the function. Hope this could help you

reward points if helpful.