Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Output CSV file problem

Hi Guru,

I encounted 1 problem where my output csv file content incorrect. Source is from SAP Proxy.

Example my csv file should have Material code, material description and date. However when i open the csv file, it is only have material code in one line and the rest of fields are not display in the csv file.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_PRD_MASTER_SND xmlns:ns0="http://com.starhub/sapprdcat">

<RECORDSET> 1:1

<RECORD> 1:unbounded

<MATNR/>

<MAKTX/>

<DATE_ADD/>

</RECORD>

</RECORDSET>

</ns0:MT_PRD_MASTER_SND>

My source and target are same.

CC Receiver setting:

Transport Protocal : File System NFS

Message Protocal : File Content Conversion

Adapter Engine : Integration Server

Recordset Structure : RECORD

RECORD.fiedlNames : MATNR,MAKTX,DATE_ADD

RECORD.endSeparator : 'nl'

RECORD.fieldSeparator : ,

RECORD.processFieldNames: fromConfiguration

RECORD.addHeaderLine: 0

The INCORRECT result only display MATNR in one line only.

HNOK0000102 HNOK0000108 C032S31384A C032S3XDATA CFGSC300300 CRAWC300001

Expected Result should be :

HNOK0000102,Material test 1,01/01/2007

HNOK0000108,Material test 2,01/02/2007

C032S31384A,Material test 3,01/01/2007

C032S3XDATA,Material test 4,01/01/2007

CFGSC300300,Material test 5,01/01/2007

CRAWC300001,Material test 6,01/01/2007

Thank you very much for help.

Regards,

Former Member
Not what you were looking for? View more on this topic or Ask a question