topic Re: interface file structure in Application Development and Automation Discussions

interface file structure

Former Member — Wed, 03 Dec 2008 07:13:24 GMT

i am developing an interface

the file need to be come in below format

"NAMEu201D,u201Du201D,u201D654321u201D,u201Du201D,u201D87654321u201D,u201Du201D,u201DBANK CITY NAMEu201D,u201DGBu201D

seperated by ,

and every field must be in between " "

regrads

sachin.

Re: interface file structure

RaymondGiuseppi — Wed, 03 Dec 2008 07:39:57 GMT

Look at function module [SAP_CONVERT_TO_CSV_FORMAT|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=converttocsv+format&adv=false&sortby=cm_rnd_rankvalue].

Regards

Re: interface file structure

MarcinPciak — Wed, 03 Dec 2008 07:52:02 GMT

Try simply concatenating your fields into one string field (you must also include all qoutation marks in it) i.e.


data: field1(4) type c value 'NAME', 
        field2(6) type c value '654321',
        ...
        result_field type string.

perform concat_with_qoute_marks using field1.
perform concat_with_qoute_marks using field2.
perform concat_with_qoute_marks using field3.
perform concat_with_qoute_marks using field4.

form concat_with_qoute_marks using field type c.
    data: part_result type string.

    concatenate '"' field '"' into part_result.   "field like  "field"

    concatenate result_field part_result into result_field separated by ','.  " "field", "field2",....
endform.

This should help

Regards

Marcin