Receiver File Adapter Header Line Not generated

[Former Member]

Hi All,

I have an ERP to File Scenario (CSV File generation )

File Structure

-<VMOReportsPart>

- <VMOReports>

     <field1>

     <field2>...

  .....

      <fieldn>

</VMOReports>

</VMOReportsPart>

Header Line is not getting generated in the output file.

CC file Configuration

RecordSet Structure: VMOReportsPart,VMOReports

VMOReportsPart.fieldSeparator   ,

VMOReportsPart.endSeparator   'nl'

VMOReports.addHeaderLine       3

VMOReports.headerLine              field1,field2,field3....fieldn

VMOReports.fieldSeparator         ,

VMOReports.endSeparator          'nl'

All the Fields are populated but not with Header Value...

Even I have tried other combinations of adding Header Line for VMOPartsReport still no luck.,

Kindly provide your suggestions. PFA for your reference.

Best Regards,

Suresh S

[Former Member · Accepted solution]

Hi ,

We have similar scenario,below will aptly suits to your req.

In receiver structure Create Header segment for the fields under that segment pass the column names as constant values .

[Former Member]

Hi Venkat/Peter,

Your solution solved the issue.

Thanks for the help

Best Regards,

Suresh S

[PeterJonker]

Change (by mapping) the structure to

<VMOReportsPart>

fielda

fieldb

fieldc

</VMOReportsPart>

<VMOReports>

field1

field2

field3

<VMOReports>

Now make sure that <VMOReportsPart> has the header values in it (with occurrence 1)

No need to addHeaderLine. The structure <VMOReportsPart> is handled as a RecordSetStructure (as you had already defined it)

-      -        ...     

[abranjan]

Hi Suresh,

Adding header line works only if 1 structure is defined in FCC. Since you've VMOReportsPart, VMOReports, I don't think it will work. This is standard SAP behaviour.

Check this link:

https://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Thanks,

Abhishek

[Muniyappan]

Hi,

can you give a try with the same order as in the below thread.

Regards,

Muni.