Graphical Mapping Errors- File to Idoc- Creating Orders05

[Former Member]

Hi Experts/Gurus

I have to create a new Orders05 Idoc for every change in BILLING_DOC. I have attached the test file. So for e.g- if i have to the Billing NO is same for 2 items- as in my case ("91500963")- i want to create only 1 Doc for them

I tried all the different ways but still it would create  3 Idoc's for the test file, where I want only 1 Idoc

All inputs would be appreciated.

<?xml version="1.0" encoding="utf-8"?>

<ns:MT_PALADIN_ORDERS xmlns:ns="http://shire.com/xi/SAPERP/IF0137_Paladin_Sales_Orders">

          <Recordset>

                    <BILLING_DOC>91500963</BILLING_DOC>

                    <ITEM_NO>000010</ITEM_NO>

                    <MATERIAL>2879186971</MATERIAL>

                    <MAT_DESC>REPLAGAL INJ 1mg/mL VIAL 3.5mL</MAT_DESC>

                    <BATCH>FGD11-014</BATCH>

                    <SOLD_TO>8002864</SOLD_TO>

                    <SOLD_TO_DESC>SHOPPERS DRUG MART # 0129</SOLD_TO_DESC>

                    <SHIP_TO>0008002864</SHIP_TO>

                    <SHIP_TO_DES>SHOPPERS DRUG MART # 0129</SHIP_TO_DES>

                    <BILL_TO>1014579</BILL_TO>

                    <BILL_TO_DES>UNIVERSITY HEALTH NETWORK</BILL_TO_DES>

                    <PAYER>23.01.2012</PAYER>

                    <PAYER_DES>ZSF2</PAYER_DES>

                    <BILL_DATE>4.000</BILL_DATE>

                    <BILL_TYPE>0.00</BILL_TYPE>

                    <BILL_QTY>PG2-08101-JD8</BILL_QTY>

          </Recordset>

          <Recordset>

                    <BILLING_DOC>91500963</BILLING_DOC>

                    <ITEM_NO>000010</ITEM_NO>

                    <MATERIAL>2879186971</MATERIAL>

                    <MAT_DESC>REPLAGAL INJ 1mg/mL VIAL 3.5mL</MAT_DESC>

                    <BATCH>FGD11-014</BATCH>

                    <SOLD_TO>8002913</SOLD_TO>

                    <SOLD_TO_DESC>THE DRUGSTORE #0331</SOLD_TO_DESC>

                    <SHIP_TO>0008002913</SHIP_TO>

                    <SHIP_TO_DES>THE DRUGSTORE #0331</SHIP_TO_DES>

                    <BILL_TO>1014579</BILL_TO>

                    <BILL_TO_DES>UNIVERSITY HEALTH NETWORK</BILL_TO_DES>

                    <PAYER>23.01.2012</PAYER>

                    <PAYER_DES>ZSF2</PAYER_DES>

                    <BILL_DATE>5.000</BILL_DATE>

                    <BILL_TYPE>11500.00</BILL_TYPE>

                    <BILL_QTY>PG2-08101-DV14</BILL_QTY>

          </Recordset>

          <Recordset>

                    <BILLING_DOC>91500963</BILLING_DOC>

                    <ITEM_NO>000010</ITEM_NO>

                    <MATERIAL>2879186971</MATERIAL>

                    <MAT_DESC>REPLAGAL INJ 1mg/mL VIAL 3.5mL</MAT_DESC>

                    <BATCH>FGD11-014</BATCH>

                    <SOLD_TO>8005069</SOLD_TO>

                    <SOLD_TO_DESC>AIRDRIE CO-OP PHARMACY</SOLD_TO_DESC>

                    <SHIP_TO>0008005069</SHIP_TO>

                    <SHIP_TO_DES>AIRDRIE CO-OP PHARMACY</SHIP_TO_DES>

                    <BILL_TO>1014579</BILL_TO>

                    <BILL_TO_DES>UNIVERSITY HEALTH NETWORK</BILL_TO_DES>

                    <PAYER>23.01.2012</PAYER>

                    <PAYER_DES>ZSF2</PAYER_DES>

                    <BILL_DATE>5.000</BILL_DATE>

                    <BILL_TYPE>11500.00</BILL_TYPE>

                    <BILL_QTY>PG2-08101-CA161</BILL_QTY>

          </Recordset>

</ns:MT_PALADIN_ORDERS>

[rajasekhar_reddy14 · Accepted solution]

1)Change IDoc segment occurance to 1 to unbounded.

2)Set Billing No occurance to root node.

Try below logic,

Billing NO--->removecontext------>sort--------->splitbyvalue(valuechange)---->CollapseContext----->IDoc

[Former Member]

Thanks Raja!

[Former Member]

Thanks!

[former_member201264]

Hi Jain,

Also you have to create EIEDK01 segments as number of unique items you have.

Regards,

Sreeni.