Skip to Content

Content conversion for seperate idoc

Hi

My scenario is file to idoc as follows.

v.no|amount|currency|documenttype

1011|1000|INR|01

1011|1500|INR|02

1011|1600|INR|02

1211|1000|INR|02

1211|1200|INR|02

1234|1000|INR|01

1234|1000|INR|01

my key field is v.no and v.no can be anything(voucher number).

i want seperate idoc should be created for similar v.no. (3 idocs should be created in above case)

what should i give in key field value as it is not fixed?

Regards

Abhijit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Sep 10, 2009 at 06:06 AM

    Hi Abhijit,

    >>my key field is v.no and v.no can be anything(voucher number).

    if your vno. repeats then it can't be taken as a key field. Do a FCC without considering it as a key field.

    Regards

    Suraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 12:48 PM

    Hi,

    You read the file as it is ,and while Mapping remove context on V.NO and use SPLIT BY VALUE on value change then do the mapping accordingly ,you can create 3 idocs for the same.

    Hope this helps.

    Thanks,

    Madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 01:41 PM

    Hi,

    You need to do the following:

    1. Configure your FCC as delimiter file(v.no|amount|currency|documenttype)

    2. Export your IDOC structure and change the occurrence of IDOC node from "1" to "1...unbounded"

    3. Import IDOC xsd as an external definition.

    4. Use this xsd in your message mapping.

    5. Handle the idoc creation logic inside of the message mapping.

    Regards

    Ivan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 02:36 PM

    Hi Abhijit,

    Since you dont have a key field in your file, you create a flat structure with one segment called Records and add all the fields. Read all the data records into this. Here you dont need a key field for content conversion then. Once you have all the records then for each change in v.no. (splitby value on change) you create an idoc.

    Regards

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhijit Bolakhe

      Hi Abhijit,

      If you follow the process what I mentioned then you dont have any key field. All your records should be read without key field only. Once you have then use splitbyvalue change in mapping. Also you need to change the occurrence of idoc as mentioned as jose.

      Regards,

      ---Satish

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.