Content Conversion problem

[Former Member]

Hi,

Am facing problem in content conversion.

I am working on file to idoc scenario.

In the file the header and item record data is in the same record types , that is for item level only the amount is changing.There are two amounts in the record,header amount and item level amount.The sum of item level amount is equal to the header amount.The header amount is repeated in every record only the item amount is different .

Again I need to recognize the end of recordset when the sum of all the item amounts is equal to the header amount.

I cannot put a constant key value as this would be again same for all the records.

Following is the sample data:

1818,petrol,110,usa,25,usd

1818,petrol,110,usa,35,usd

1818,petrol,110,usa,20,usd

1818,petrol,110,usa,30,usd

2314,diesel,75,can,15,cad

2314,diesel,75,can,45,cad

2314,diesel,75,can,15,cad

now the field structure is :

material number,material,header amount,country,item amount,currency.

Now for material number 1818 the header amount is 110,the item level amounts are : 25,35,20,30

Now I need to identify the end of recordset after the sum of item level amounts is equal to the header amount.

Am not able to design the sender file adapter content conversion parameters.

Can any one please help.

Thnx.

Pravesh.

[Former Member]

Hi Shabarish,

Thank you for ur reply.

I wanted to identify the end of recordset in order to generate multiple messages, one or each recordset.

As multiple idocs needs to be posted.

How can I achieve this split in the mapping,inorder to generate multiple idocs.

Thnx,

Pravesh.

[moorthy]

Hi,

If you are posting multiple idocs of the same Idoc type,

you can change the occurence of the idoc structure and map the fields. For this you can refer this blog~

/people/michal.krawczyk2/blog/2005/12/04/xi-idoc-bundling--the-trick-with-the-occurance-change

Regards,

Moorthy

[Shabarish_Nair]

1818,petrol,110,usa,25,usd

1818,petrol,110,usa,35,usd

1818,petrol,110,usa,20,usd

1818,petrol,110,usa,30,usd

2314,diesel,75,can,15,cad

2314,diesel,75,can,45,cad

2314,diesel,75,can,15,cad

>>> Now I need to identify the end of recordset after the sum of item level amounts is equal to the header amount.

Acheive this in your mapping !!!

Dont make the content conversion complex.

You can move in for a simple content conversion.

Ref:

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file