Problem with Content Conversion in SAP XI File Adapter

[Former Member]

Hello experts,

I have problem with a content conversion in my file adapter receiver XI:

I use in my file adapter receiver the following conten conversion:

Invoice.fieldSeparator '0x9'

Invoice.endSeparator 'nl'

Invoice.fieldNames 'Product, SerialNumber, ArticelName,Pieces, UnitCOS, COS,InvoiceNumber

But sometimes the SerialNumber is not available for a product then result of the content conversion is as follows:

050-0412-35 0916SXDFH product xyz 245,00 245,00 15900257 170

054-0331 product dwad ys 30 63,60 63,60 15900257 171

What should I do to get this result: How can I add a further tab?

050-0412-35 0916SXDFH product xyz 1 245,00 245,00 15900257 170

054-0331 Blister Pack Slim Tube C2B-L (SET) 30 63,30 63,30 15900257 171

Thanks in advance for answering my question.

Erkan

[Former Member]

Hi Erkan,

In mapping the serial number you use mapwithdefault. Double click on mapwithdeault and put spaces equal to the length of the field(if fixed length file) or space or tab if it is a csv or tab file. Then if that field doesnot populate in source, then it will trigger the mapwithdefault and should take care of your issue.

Regards,

---Satish

[Former Member]

Hi Erkan,

>

> But sometimes the SerialNumber is not available for a product then result of the content conversion is as follows:
> 
> 050-0412-35       0916SXDFH         product xyz             245,00   245,00   15900257        170         
> 054-0331             product dwad ys        30           63,60     63,60     15900257        171        
> 
> What should I do to get this result: How can I add a further tab?
> 050-0412-35       0916SXDFH        product xyz                                             1             245,00   245,00   15900257        170       
> 054-0331                                       Blister Pack Slim Tube C2B-L (SET)          30           63,30     63,30     15900257        171         

The file that you are creating at target is tab-delimited, then you don't need to insert an extra tab if a field value is missing. The adapter will take care on its own, even if the field value is missing, it will still insert a tab over there.

Run it, and it will work.

Let us know if you have more questions.

regards,

Neetesh