Message Mapping Doubt

[prasanna_shanmugasundaram]

Hi Experts,

Im stuck up with a message mapping issue. Need your advice if I can handle this in message mapping or should I changed the FCC.

FILE to RFC scenario.

Input file sample.

1|OPENED|153-01-19|T001|005151|0237|20100705|17:35:55|001 |20100705

101|A005152|1|20100705|11:46:38|001 ||||001||1|N|SALE

111|WCAKE004|1.000|42.00|42.00||G||0.00|LIQUOR|||N|42.00|0.00|$|0.00|WCAKE004

111|WCAKE004|-1.000|42.00|42.00||G||0.00|LIQUOR|||N|-42.00|0.00|$|0.00|WCAKE004

111|WCAKE005|1.000|38.00|38.00||G||0.00|LIQUOR|||N|38.00|0.00|$|0.00|WCAKE005

121|38.00|0.00|0.00|0.00|0.00|I|N||0.00|0.00

131|T|CASH|S$|1.0000000|38.00||||38.00

141|G|0.00

1|CLOSED|153-01-19|T001|005162|0237|20100705|17:35:55|001 |20100705

After the FCC the message comes into XI in the format (Source message) .

GMRSTORES

--CODE1

-

---

1

-

---

OPENED etc..

--CODE101

-

---

101

-

---

A005152

-

---

1 etc..

--CODE111

-

---

111 etc..

--CODE111

-

---

111 etc..

--CODE111

--121

--131

--141

--1

The problem is on the target side when I try to map the Code111 (line item) to the targert RFC it comes only once or all the Code111 nodes comes under the same "ITEM_LI" The target RFC structure is like.

--/POSDW/CREATE_TRANSACTIONS_EXT

-

---

IT_TRANSACTION

-

---

ITEM

-

---

RetailLIne Item

-

---

ITEM_LI (here is the problem I expect 3 ITEM_LI nodes for each CODE111)

Pls advice.

Thanks

Prasanna

[prateek · Accepted solution]

Need your advice if I can handle this in message mapping or should I changed the FCC.

Changes in message mapping should be enough.

+when I try to map the Code111 (line item) to the targert RFC it comes only once or all the Code111 nodes comes under the + same "ITEM_LI"

Make sure that the Code111 is mapped to ITEM_LI and you have handled the context properly.

Regards,

Prateek

[prasanna_shanmugasundaram]

Thanks for your replies. It was helpful and solved the mapping requirement buy some changes in the source structure and the handling context.

Thanks

Prasanna

[Former Member]

1. Ensure the max. occurance be unbounded.

2. Check your FCC parameters, the recordset structure should be represented with '*' to repeat.

The recordset structure code1,1,code101,1,code111,*,code121,1,code131,1,code141,1

3. Ensure your mapping logic is correct.

[former_member200962]

The problem is on the target side when I try to map the Code111 (line item) to the targert RFC it comes only once or all the 
Code111 nodes comes under the same "ITEM_LI"
here is the problem I expect 3 ITEM_LI nodes for each CODE111

1) Ensure that you have raised the Context of the source node (CODE111) to a higher node.

2) Is your mapping logic proper..... is the ITEM_LI node or its parent node mapped properly so that when the CODE111 repeats, the target is also able to repeat?

3) did you check the max occurence of ITEM_LI node.....it should be more than 1

Regards,

Abhishek.