Multiple IDOCs from one Flat file

[Former Member]

HI Gurus,

Sender file is of such format

Header1,Item1 details

Header1,Item2 Details

Header2, Item1 Details

Header2,item2 Details

Header3, Item1 Details

I need to map this file format to IDOC strucutre, In Header there is a filed which is the Key value to identify the change in header.

Eg: Order Number is the field in the following file which identifies the change in header: First three fields are header details and following are the item details:

ABC,ON1,22,Item1,XX

ABC,ON1,33,Item2,FF

ABC,ON2,44,Item1,MM

ABC,ON3,66,Item1,LL

How would be the Data type strcuture to capture this type of falt file strcuture and FCC parameters?

I need to send a single IDOC per one header with multiple Items. is it possible to achieve?

Thanks

Rajeev

[Former Member · Accepted solution]

Rajeev,

Take your structure like this:

Record

Header(1..Unbounded)

Item(1..Unbounded)

Details(0..Unbounded)

Using the key field try to read the file using content conversion. If you are not sure of content conversion let us know, somebody will help you.

Regards,

---Satish

[Former Member · Accepted solution]

Hi Satish,

Do we need to do some configuration to produce 3 IDOCs from the below strcuture?

ABC,ON1,22,Item1,XX

ABC,ON1,33,Item2,FF

ABC,ON2,44,Item1,MM

ABC,ON3,66,Item1,LL

From the above structure 3 IDOCs should be generated as below:

1st IDOC as

ABC,ON1 (Header Details)

-

---

22,Item1,XX (Item1 Details)

-

---

33,Item2,FF (Item2 Details)

2nd IDOC as

ABC,ON2 (Header Details)

-

---

44,Item1,MM (Item1 Details)

and 3rd IDOC as

ABC,ON3 (Header Details)

-

---

66,Item1,LL (Item1 Details)

Do following Data type for the above file structure is valid? or I can use one flat DT?

Record

Header(1..Unbounded)

---F1 (Field 1)

---ON (Key Field Order Number)

Item Details(1..Unbounded)

---F1 (Field1)

---F2

---F3

If the above DT is correct then how would be the FCC parameters?

Thanks

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

You are correct u can achieve this by using multi mapping(using BPM or Without BPM)

In mapping ,

Take the source structue as u have mentioned for the file.

For the receiver since u have Idoc u can import them and use the structures.

And regarding the FCC(File content conversion) u specify whether it is fixed length or CSV file

[Former Member · Accepted solution]

If it is a CSV u can have like

Record.endSeparator 'nl'

Header.endSeparator 'nl'

Header.fieldNames F1,ON

Header.feildSeparator ','

Header.keyFieldValue ON

ItemDetails.endSeparator 'nl'

ItemDetails.fieldNames F1,F2,F3

ItemDetails.fieldSeparator ','

I hope this will solve ur problem................