Skip to Content
avatar image
Former Member

Content Conversion problem

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 20, 2006 at 01:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2006 at 02:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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