create multiple records from single xml file.

[former_member561528]

Hi Friends,

   My scenario is file to proxy.

   i need pick the xml file from source and send to the ECC(Ztable)

   In xml file having multiple records.

   example

- <InventoryResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" MajorVersion="1" xmlns="http://retalix.com/R10/services">

- <Header>

<Response ResponseCode="OK" />

</Header>

- <InventoryAction ActionCode="Get" Type="Receiving">

<Id>c5af721a-5bcf-46c3-ad79-e4d2debd9cd5</Id>

<Description>Alcoholic Beverages</Description>

<GenerationMethod Source="Nex">Generated</GenerationMethod>

<DateTime TypeCode="EffectiveDate">2014-10-20T22:09:10.0997822+03:00</DateTime>

<DateTime TypeCode="CreationDate">2014-05-07T10:37:27</DateTime>

<DateTime TypeCode="DeliveryDate">2010-01-28T00:00:00</DateTime>

- <InventoryItem>

<ItemID Name="Red Merlot Wine">484129</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>8.4</CostForInventoryBalance>

<InventoryBalance>58.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="5.00000" UnitOfMeasure="Pack" Name="Red Wine S Case" Cost="43.00000" EntityKey="484129RATIO5">10048412951</Package>

<GeneratedCost>42.0000</GeneratedCost>

<GeneratedCost Source="ASN">42.0000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>5.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">5.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

- <InventoryPackage>

<Package Ratio="1" UnitOfMeasure="Each" Name="Red Merlot Wine" Cost="9.50000" EntityKey="484129">10048412911</Package>

<GeneratedCost>9.5000</GeneratedCost>

<GeneratedCost Source="ASN">9.5000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>100.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">90.000</GeneratedQuantity>

<IsDefault>false</IsDefault>

</InventoryPackage>

</InventoryItem>

- <InventoryItem>

<ItemID Name="Riesling White Wine">484123</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>9.0000</CostForInventoryBalance>

<InventoryBalance>2.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="1" UnitOfMeasure="Each" Name="Riesling White Wine" Cost="9.20000" EntityKey="484123">1004841231</Package>

<GeneratedCost>9.0000</GeneratedCost>

<GeneratedCost Source="ASN">9.0000</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

<GenerationMethod Source="Order">Generated</GenerationMethod>

<GeneratedQuantity>45.000</GeneratedQuantity>

<GeneratedQuantity Source="ASN">40.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

- <InventoryPackage>

  <Package Ratio="10.00000" UnitOfMeasure="Pack" Name="White Wine M Case" Cost="85.00000" EntityKey="484123RATIO10">1004841231101</Package>

  <GeneratedCost>85.0000</GeneratedCost>

  <GeneratedCost Source="ASN">85.0000</GeneratedCost>

  <AdditionalQuantity>1</AdditionalQuantity>

  <Operator>admin</Operator>

  <DateTime TypeCode="EffectiveDate">2014-05-07T10:37:27</DateTime>

  <GenerationMethod Source="Order">Generated</GenerationMethod>

  <GeneratedQuantity>20.000</GeneratedQuantity>

  <GeneratedQuantity Source="ASN">20.000</GeneratedQuantity>

  <IsDefault>false</IsDefault>

  </InventoryPackage>

</InventoryItem>

- <InventoryItem>

<ItemID Name="Bamba">12345</ItemID>

<Quantity>0</Quantity>

<QuantityForInventoryBalance xsi:type="InventoryItemQuantityType">0</QuantityForInventoryBalance>

<CostForInventoryBalance>1.725</CostForInventoryBalance>

<InventoryBalance>2.000</InventoryBalance>

- <InventoryPackage>

<Package Ratio="10.00000" UnitOfMeasure="Pack" Name="10 pack Bamba 50 gr" EntityKey="12345RATIO10">22222</Package>

<GeneratedCost Source="ASN">17.2500</GeneratedCost>

<AdditionalQuantity>1</AdditionalQuantity>

<Operator>admin</Operator>

<DateTime TypeCode="EffectiveDate">2014-10-20T21:42:31</DateTime>

<GenerationMethod Source="AdvancedShipmentNotice">Generated</GenerationMethod>

<GeneratedQuantity Source="ASN">1.000</GeneratedQuantity>

<IsDefault>true</IsDefault>

</InventoryPackage>

</InventoryItem>

<Operator>admin</Operator>

<ApproveOperator>admin</ApproveOperator

In this XML Inventory package is comming multiple times. we need to split each inventory package in to one record and put in Ztables.

Can we do this in Mapping. if its possible please let me know me logic.

i tried but its created only one record.

Thanks,

Bhanu.

[former_member182412]

Hi Bhanu,

Dont split in PI mapping, why dont you send all the items to inbound proxy then you can write the logic to insert all items into Ztable.

Regards,

Praveen.

[former_member561528]

Hi Praveen,

So you mean write code in ABAP. while developing proxy.

Thanks,

Bhanu

[former_member182412]

Yes BhanuPrakash, you can write the code in inbound ABAP proxy in ECC.

Regards,

Praveen.