Idoc to File Strucutre error..

[former_member238007]

Hi Experts,

The scenario is IDOC to File scenario in which i am mapping the DESADV05 idoc at the source side and at the target strucutre i have structure like below

MT_Receiver

Header

--Field1

--Field2

Purc Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

when i populate with mulitiple Purchase orders from the IDOC the output now coming is as below

MT_Reciver

Header

--Field1

--Field2

Purc Order

--Field1

--Field2

Purc Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

Details

--Field1

--Field2

--Field3

But i require the output as ..

MT_Reciver

Header

--Field1

--Field2

Purc Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

Purc Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

So what change is required for this, i have checked with maximum options.. didnt get the above structure in output.

regards,

Kishore

[Former Member · Accepted solution]

Hi Kishoer,

Just create one datatype for target

DT_Receiver (0..unbounded) then keep your structures (map the each PO Numbers and split for each PO number main root node)

Header (0..1) (just map constant..with empty space)

--Field1

--Field2

Purc Order (0..1) (just map constant..with empty space)

--Field1

--Field2

SubHeader (0..1) (just map constant..with empty space)

--Field1

--Field2

Details (0..1) or 90..unbound..if you want to map line items)

--Field1

--Field2

--Field3

and map DT_Receiver for each PO number so that how many PO's you have that many times main Root node name will repeat...under that as you want you get it...

If you create one more main rootnode hope you can achive your requirement...

Regards,

Venu.

[former_member238007 · Accepted solution]

Hi Venu,

I dont want to repeat the Header structure, i just want to repeat only the Purc Order and Subheader and detail records, for each Purchase order, I hope now you understood my scenario.. if you need any information will provide you..

regards

kishore

[abhijitbolakhe · Accepted solution]

Hi

The following blog suits your requirement.

/people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception

Regards

Abhijit

[former_member200962 · Accepted solution]

at the target strucutre i have structure like below
MT_Receiver
Header
--Field1
--Field2
Purc Order
--Field1
--Field2
SubHeader
--Field1
--Field2
Details
--Field1
--Field2
--Field3

You have to change the hierarchy of some nodes to get the required output structure:

MT_Receiver

-Header

--Field1

--Field2

-POInformation

--PurcOrder

---Field1

---Field2

--SubHeader

---Field1

---Field2

--Details

---Field1

---Field2

---Field3

Unless the structure is changed, the requirement may not be achieved.

Regards,

Abhishek.

[Former Member · Accepted solution]

Hi

Make your receiver structure as below:

MT_Reciver

Header 1-1

--Field1

--Field2

Recordset 1-unbounded

Purc Order 1-unbounded

--Field1

--Field2

SubHeader 1-unbounded

--Field1

--Field2

Details 1-unbounded

--Field1

--Field2

--Field3

Place Purc Order, SubHeader, Details under a Recordset so that they are in a set and come in that particular order

Thanks

Pratichi

[former_member238007 · Accepted solution]

Hi Abhishek,

I have modified the structure as

MT_Receiver

Header

--Field1

--Field2

BODY_NODE

Purc_Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

and when i do testing for the multiple Purchase Orders the output that coming was..

MT_Receiver

Header

--Field1

--Field2

BODY_NODE

Purc_Order

--Field1

--Field2

Purc_Order

--Field1

--Field2

SubHeader

--Field1

--Field2

SubHeader

--Field1

--Field2

Details

--Field1

--Field2

--Field3

Details

--Field1

--Field2

--Field3

Details

--Field1

--Field2

--Field3

So do i need to change any context for this.. still facing this issue

regards

Kishore

[former_member200962 · Accepted solution]

Occurence of BODY_NODE should be 0..unbounded....and the occurence of all the sub-nodes/ fields of BODY_NODE should be 0..1 .... as per the requirement that you specified in first post.

Regards,

Abhishek.

[former_member238007 · Accepted solution]

Hi Abhishek,

Again i have some differient issue.. now the issue was i am getting the output as..

MT_Receiver

Header

--Field1

--Field2

BODY_NODE

Purc_Order

--Field1

--Field2

SubHeader

--Field1

--Field2

Detail

--Field1

--Field2

--Field3

Detail

--Field1

--Field2

--Field3

Detail

--Field1

--Field2

--Field3

BODY_NODE

Purc_Order

--Field1

--Field2

SubHeader

--Field1

--Field2

All the detail records of all the purchase orders are coming in the 1st loop, so how do we split the detail records based on the purchase order

regards,

Kishore