Skip to Content

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

Conversion file adapter

Hi all,

I have the following xml:

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

<ns:PayLinkV1 xmlns:ns="urn:basf:sa:fi:cash">

<payRecord>

<recType>PAY</recType>

<countryCode>032</countryCode>

...

<payFlag />

<filler />

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000GAL1</description>

<filler />

</invoice>

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000GAL2</description>

<filler />

</invoice>

</payRecord>

<payRecord>

<recType>PAY</recType>

<countryCode>032</countryCode>

...

<payFlag />

<filler />

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000CIT3</description>

<filler />

</invoice>

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000CIT2</description>

<filler />

</invoice>

</payRecord>

<trailer>

<recType>TRL</recType>

<qtyTransaction>000000000000000</qtyTransaction>

<qtyAmount>000000000000000</qtyAmount>

<qtyRec>000000000000000</qtyRec>

<qtyRecNo>000000000000000</qtyRecNo>

<filler />

</trailer>

</ns:PayLinkV1>

I need to convert it in one text file with this layout:

fields of payrecord

fields of invoice

fields of invoice

...

fields of payrecord

fields of invoice

fields of invoice

...

fields of trailler

In may file conversion type has the following configuration:

Recordset structure: payRecord,invoice,trailer

payRecord.fieldFixedLengths: 3,3,10,6,3...

invoice.fieldFixedLengths: 3,3,10,15...

trailer.fieldFixedLengths: 3,15,15...

But in the file adapeter occurs one error with this configuration.Anybody have an ideia to do it?

thanks!

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